Re: [h2] Putting the H2 database file on a Java NIO2 based, custom filesystem.

2014-01-14 Thread Harry
Thanks Thomas, for taking the time to confirm. No, I don't have a file-system with me. I had a urgent need to evaluate and report back on H2's capabilities w.r.t. custom file-systems. Now, because this thing was not readily obvious to me from the H2 codebase nor was there any explicit mention

Re: [h2] H2 faster after a database has been open

2014-01-14 Thread Cecil Westerhof
2014/1/14 Thomas Mueller thomas.tom.muel...@gmail.com I don't quite understand sorry. Do you mean, creating a new database takes 0.35 seconds? Yes thats entirely possible. Nope, in both cases the table exists. The only difference is that I opened the database with the browser (on

Re: [h2] H2 faster after a database has been open

2014-01-14 Thread Cecil Westerhof
2014/1/14 Noel Grandin noelgran...@gmail.com On 2014-01-14 11:31, Cecil Westerhof wrote: Nope, in both cases the table exists. The only difference is that I opened the database with the browser (on localhost:8082) and closed it again. I suspect you are warming up the operating system

Re: [h2] how to compile source

2014-01-14 Thread jpgfromfr
Le mardi 14 janvier 2014 08:08:53 UTC+1, Thomas Mueller a écrit : Hi, There is already a feature request for this: Database file name suffix: a way to use no or a different suffix (for example using a slash).. The tricky part is the tools (for example the backup / restore tools). Could

Re: [h2] how to compile source

2014-01-14 Thread jpgfromfr
Hi, A possibilitiy why don't export the file Constants.java to a resource file so no need to recompile the jar if we want to change the extension of the h2 databse file ?? -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this

[h2] Multithreading issues while compiling Java aliases in multi-module Maven project

2014-01-14 Thread Vojtěch Hordějčuk
Hi, I encountered one multithread issue related to alias compiling. I have parent POM project and two sub-projects. Both of these contain unit test with Spring context and H2 in-memory database. In both of them, I create alias like this: 1. CREATE ALIAS HELLO_WORLD AS ' 2. import

Re: [h2] tcp broken after shutdown/restart Connection refused: localhost [90067-169]

2014-01-14 Thread Dave Atkins
Is there any way to diagnose this? Are there any log files I don't know about? Where would I find an exception or some indication that the service did not start properly? On Saturday, January 11, 2014 10:26:35 AM UTC-5, Noel Grandin wrote: On Fri, Jan 10, 2014 at 5:21 PM, Dave Atkins

[h2] how to upgrade from 1.3.169 to 1.3.174

2014-01-14 Thread Dave Atkins
To upgrade...do I simply replace the .jar file and restart the server? Is it necessary to download anything else or run any scripts? Thanks -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails

Re: [h2] Multithreading issues while compiling Java aliases in multi-module Maven project

2014-01-14 Thread Thomas Mueller
Hi, This bug is fixed in the latest version (see issue 530). Regards, Thomas On Tuesday, January 14, 2014, Vojtěch Hordějčuk wrote: Hi, I encountered one multithread issue related to alias compiling. I have parent POM project and two sub-projects. Both of these contain unit test with

Re: [h2] Putting the H2 database file on a Java NIO2 based, custom filesystem.

2014-01-14 Thread Thomas Mueller
Hi, See http://h2database.com/html/advanced.html#file_system I will add Internally, the interfaces are very similar to the Java 7 NIO2 API, but do not (yet) use or require Java 7.. Regards, Thomas On Tue, Jan 14, 2014 at 10:12 AM, Harry simonsha...@gmail.com wrote: Thanks Thomas, for

Re: [h2] Only show changes in GROUP BY

2014-01-14 Thread Thomas Mueller
Hi, OK I see, what about: DROP TABLE IF EXISTS test; CREATE TABLE test(year INT, month INT); INSERT INTO test (year, month) VALUES (2000, 1), (2000, 2), (2000, 3), (2000, 4), (2000, 5), (2000, 6), (2001, 1), (2002, 2), (2002, 3), ; SELECT rownum(), year, month, @prev := case when rownum()=1

Re: [h2] Bug with EXPLAIN-Statement?

2014-01-14 Thread Thomas Mueller
Hi Thanks a lot! Now I understand. It is now fixed in the trunk. Regards, Thomas On Thu, Jan 9, 2014 at 11:05 PM, forma...@gmail.com wrote: Please run this sql-script in your h2 database. --Test-statement --EXPLAIN SELECT * FROM ( --Test dataset SELECT * FROM VALUES(1) UNION ALL

Re: [h2] how to compile source

2014-01-14 Thread Thomas Mueller
Hi, Hm, maybe the suffix could be a system property. Would that work for you? There are a couple in the SysProperties class already. Patches are welcome! Regards, Thomas On Tue, Jan 14, 2014 at 11:50 AM, jpgfro...@gmail.com wrote: Hi, A possibilitiy why don't export the file

Re: [h2] tcp broken after shutdown/restart Connection refused: localhost [90067-169]

2014-01-14 Thread Thomas Mueller
Hi, How did you start the service? I would expect an exception there if it didn't work. Regards, Thomas On Tue, Jan 14, 2014 at 6:23 PM, Dave Atkins datki...@gmail.com wrote: Is there any way to diagnose this? Are there any log files I don't know about? Where would I find an exception or

Re: [h2] how to upgrade from 1.3.169 to 1.3.174

2014-01-14 Thread Thomas Mueller
Hi, For minor version changes, no upgrade procedure is needed. Regards, Thomas On Tue, Jan 14, 2014 at 6:32 PM, Dave Atkins datki...@gmail.com wrote: To upgrade...do I simply replace the .jar file and restart the server? Is it necessary to download anything else or run any scripts? Thanks

Re: [h2] tcp broken after shutdown/restart Connection refused: localhost [90067-169]

2014-01-14 Thread Dave Atkins
The service starts, but the tcp server is not running. It is possible to connect by the file method. The service is started with default options, from a script in init.d...e.g. service careH2 start = /usr/java/latest/bin/java -Dname=CareH2d -cp /home/rules/h2/bin/h2-1.3.169.jar

[h2] I ask for help (\u00a0\u00a0\u00a0\u00a0)

2014-01-14 Thread Kirill Temnenkov
Hi, dear developer team! I ask for help. I use java application with Ormlite (http://ormlite.com/) and H2 Periodically, during the insertion string in CLOB field, after saving in this field SOMETIMES (irregular!) appears many characters \ u00a0 \ u00a0 \ u00a0 \ u00a0 \ u00a0 \ u00a0 \ u00a0

Re: [h2] tcp broken after shutdown/restart Connection refused: localhost [90067-169]

2014-01-14 Thread Thomas Mueller
Hi, The service starts, but the tcp server is not running. Well, if the TCP server is not running, then the service did not start properly, right? I don't know how, but I guess there is a way to look at the output of the server, so see what the problem is? It is possible to connect by the

Re: [h2] Is there any way a trigger can be invoked when a new table is created?

2014-01-14 Thread Thomas Mueller
Hi, The trigger class needs to be public, and in the classpath where the database is running. When using the server mode, the database is running on the server. Regards, Thomas On Thursday, December 26, 2013, Vonmist wrote: Hi, Thanks i will try it out. By the way, is trigger about to be

Re: [h2] Newbe Question: H2 on Raspberry

2014-01-14 Thread Thomas Mueller
Hi, The database URL jdbc:h2:~/test means the database file is stored in the current user home directory. That could be the home directory of root. Maybe the easiest way is to search for the file using sudo find / -name test.h2.db sudo find / -name test.mv.db By the way, the latest trunk