Re: Automatically compact databases from time to time (as a background process)

2012-02-23 Thread IntensiveH2
Hi, I tried your proposal but I have the issue below (with public long transactionTimeout = 33554432): INFO | jvm 1| 2012/02/23 08:54:21 | WrapperManager Error: Error in WrapperListener.start callback. java.lang.StackOverflowError INFO | jvm 1| 2012/02/23 08:54:21 | WrapperManager

Re: Automatically compact databases from time to time (as a background process)

2012-02-23 Thread IntensiveH2
Hi, I tested the compact command. I have no issue regarding corruption but I need time to perform additional validations. But compact command closed all opened connection and if you have a pool of connection, it's a problem The error message is: org.h2.jdbc.JdbcSQLException: Database is already

Re: Something about the License

2012-02-23 Thread Ron
Hi Anybody can help me? On 2月22日, 下午9时06分, Ron nnronk...@gmail.com wrote: Sorry,I do not speak English. I have a question. If I develop a project using H2. This project is DB Server too, and I call it another name, but I tell to the user it is really H2, I just modify some code of H2 and add

FILE ID mismatch - upgrade db

2012-02-23 Thread Onno
Hi, i am using the h2 database in a productive environment and we accidently deployed the version 1.0.71 because that's the one in the spring repository. (Yeah, that was pretty stupid) Now I had to repair several databases manually with some dataloss because the FILE ID mismatch error occured.

Re: Aggregate performance issue

2012-02-23 Thread Loic Petit
Hi Thomas, Thanks for the answer (I didnt see it at first). I'm just testing every possible query plans for a study and I have also an accumulated buffer that can do the trick as well. Any thoughts on why the group sorted has a poorer performance? Is there a way to override the choices? Thanks

Re: backup encrypted database

2012-02-23 Thread Adam McMahon
Thomas, Thanks for pointing that out, I did not realize that SCRIPT allowed that. Your solution will work fine. Thanks again! On Feb 22, 11:44 pm, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, I would use the script statement; it does does support an encrypted

Re: User-Defined Function Values

2012-02-23 Thread Thomas Mueller
Hi, Referencing the column like this:      id = resultSet.getString(getNextIdAndUpdate); Is not going to work when the column is named this:     PUBLIC.GETNEXTIDANDUPDATE() Ah, I guess the main problem is the () at the end. I didn't see that first, sorry. Could you change the query to:

Re: Something about the License

2012-02-23 Thread Thomas Mueller
Hi, I just modify some code of H2 and add some other function. In that case I believe you will have to post the changes you made to the H2 source code. If you just call methods of H2 from within your application, then not. Only if you change the H2 code itself. Regards, Thomas -- You

Re: User-Defined Function Values

2012-02-23 Thread Joe Parsons
Ah, I guess the main problem is the () at the end. I didn't see that first, sorry. Could you change the query to: SELECT getNextIdAndUpdate() AS getNextIdAndUpdate I certainly could, but my goal was to change nothing in the code to accommodate my unit testing. Referencing the column by