[h2] BigInt[IDENTITY] field not incrementing correctly

Hi, I have a Time Log database using H2 with LibreOffice Base as the front end. The TimeLog Table's Key is - TimeLogID BigInt[IDENTITY] This automatically assigns the next number for each new record. It works well for several records, then it suddenly jumps by 30 or 31 for no apparent

Re: [h2] JdbcConnection default connection in function calls

Is it possible to get the client connection from this object? Maybe with the unwrap() call in beta? Or is that something else? On Friday, August 15, 2014 2:32:54 AM UTC-7, Thomas Mueller wrote: > > Hi, > > This is documented in > http://h2database.com/html/features.html#user_defined_functions >

[h2] Re: query plan for subselect

I ran an explain analyze on a similar query against a built-in function: explain analyze select a from (select floor(x + 0.1) as a, floor(x - 0.1) as b from system_range(0,100)) where b in (3,4,5,6,7) How should I interpret the scan counts? SELECT A FROM ( SELECT FLOOR((X + 0.1)

[h2] Re: Using psql with H2 database

No comments here? :( Em quarta-feira, 13 de agosto de 2014 19h17min28s UTC-3, Thiago Lima escreveu: > > I'm trying to connect to an h2 in-memory database using the postgresql cli > tool. I tried a lot of things, but couldn't authenticate yet. Could > someone, please, explain me how to properly

[h2] query plan for subselect

I'm doing a select like the following, with a user function B: SELECT B1 FROM (SELECT B(1, x) AS B1, B(2, x) AS B2 FROM system_range(0, 389)) WHERE (B2 IN (?,?,?...)) B is getting called about 130k times. There are about 680 items in the IN clause. So, it gets called a number of times equal to

Re: [h2] H2 Database Growing at Alarming Rate

Thanks for the feedback, I'll check that out asap. On Friday, August 15, 2014 10:12:09 AM UTC-4, Noel Grandin wrote: > > That's pretty much a classic uncommitted transaction problem. > > Try selecting from the INFORMATION_SCHEMA.SESSIONS table to see which > sessions have been bad. > > -- You

Re: [h2] H2 Database Growing at Alarming Rate

That's pretty much a classic uncommitted transaction problem. Try selecting from the INFORMATION_SCHEMA.SESSIONS table to see which sessions have been bad. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

[h2] H2 Database Growing at Alarming Rate

Hi, We recently integrated a database into our web application (*it was previously using a JCR*). We're are currently using *h2* version *1.3.176*. Our problem is that we see our *H2* database file growing very large (*5GB +*) fairly quickly (*within 1-2 hours*). The only way to get the databas

[h2] Does anyone have or know of a good SQL parser for Java that is open source?

I have a requirement to parse SQL statements ( Just DML basic Insert/Update/Delete ... ) from a string and generate custom SQLXML. I had an old project that used javacc and a SQL dictionary to parse SQL commands, but it was not well written and had many issues. This community seems like a go

Re: [h2] Maven shade minimizejar shreds H2 even when configured not to touch H2

Hi, If you want to ignore the H2 classes, I think you need to use "exclude", not "include". Regards, Thomas On Thu, Aug 14, 2014 at 5:18 PM, Chris Anilao wrote: > Has anybody ever used maven shade's minimize jar feature while using H2? > > Like the documentation >

Re: [h2] Re: How to open split .h2 database using java -cp option

Hi, See also the documentation of the split file system at http://h2database.com/html/advanced.html#file_system_split Regards, Thomas On Thu, Aug 14, 2014 at 6:46 AM, Vineet wrote: > Forgot to mention, > 30 is the split size and that can vary. > > > On Thursday, 14 August 2014 10:15:12 UTC+5:

Re: [h2] Issue during execution of alter table with driver version 1.4.181 on an existing DB version 1.3.X

Hi, > or someting is wrong on my side? Yes, I think so. According to the stack trace, you have executed a script that tries to alter a table in a way that is not allowed (convert a column to "timestamp" that already contains values such as "3"). Unfortunately, the statement is not in the .trace

Re: [h2] JdbcConnection default connection in function calls

Hi, This is documented in http://h2database.com/html/features.html#user_defined_functions See also http://docs.oracle.com/javadb/10.5.1.1/devguide/cdevspecial29620.html Regards, Thomas On Tue, Aug 12, 2014 at 1:30 AM, Brian Craft wrote: > Opening a connection, I get an object like > > JdbcC