Re: [h2] 1.4.181 BLOB related issue

2014-11-20 Thread Benedikt Waldvogel
Hi, On Wed, November 19, 2014 10:25, Thomas Mueller wrote: To avoid having to change the test case, could you add ;trace_level_system_out=3 to the database URL, and then send me / post the resulting output? This should include all the JDBC API calls. That way it should be quite easy to write

[h2] ConcurrentModificationException while creating Trigger

2014-11-20 Thread christoff . schmitz
Hi, I use H2 1.3.176 (last stable). The following exception was thrown while executing multiple database operations in parallel, maybe it could helpful for you to apply a fix. Unfortunately, I cannot provide a testcase for this. java.sql.SQLException: Folgende SQL-Anweisung konnte nicht

Re: [h2] ConcurrentModificationException while creating Trigger

2014-11-20 Thread Noel Grandin
What does your database URL look like? -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email

Re: [h2] ConcurrentModificationException while creating Trigger

2014-11-20 Thread christoff . schmitz
jdbc:h2:file:PATH;MULTI_THREADED=1;DB_CLOSE_DELAY=-1;LOG=0;UNDO_LOG=0 ;QUERY_CACHE_SIZE=0;CACHE_SIZE=16384 The database is only required during runtime of my application. Therefore undo and transaction log are disabled to improve performance. Kind regards, Christoff Schmitz F I N A R I S

Re: [h2] ConcurrentModificationException while creating Trigger

2014-11-20 Thread Noel Grandin
Yeah, sorry, I'm not really interested in debugging anything with the logs turned off. Those are use at your own risk features. And MULTI_THREADED is still experimental in 1.3.176 (and still buggy in 1.4) If you reproduce with 1.4 and the logs turned on, then I'd be willing to try and track

Re: [h2] 1.4.181 BLOB related issue

2014-11-20 Thread Thomas Mueller
Hi, I can now reproduce the problem, using the following test case. Thanks a lot! http://h2database.com/p.html#88f131803abed52292b7a80c33631624 Regards, Thomas On Thursday, November 20, 2014, Benedikt Waldvogel m...@bwaldvogel.de wrote: Hi, On Wed, November 19, 2014 10:25, Thomas Mueller

[h2] Re: java.lang.NegativeArraySizeException (on H2 1.3.176 build)

2014-11-20 Thread Vishwa
Hello Noel, Thank you very much for quick turn around. is it on 1.3.176 branch? if not could you please make it on this branch for production purpose? -Vishwa On Wednesday, November 19, 2014 11:49:23 AM UTC-8, Vishwa wrote: Hi All, I have strange situation where I get

[h2] How can i configure H2 programmatically in Spring and Spring-Data-JPA

2014-11-20 Thread Arda Orhan
Hi everyone, I try to build a blog engine for myself and i will use H2 database. I'm using JPARepositories in Spring-data to do declarative queries. What i really dont understand is, my DataSource doesn't have any properties about settings. You can see below, but in my desktop application i made

[h2] Large database and finding out what the server is up to

2014-11-20 Thread Henry Berg
Hello - I recently used csvread to load just north of 35 million rows into an H2 table that had a couple indices and several times found myself wondering what's going on in there? To make the process even more fun I had a timestamp conversion going on one of the fields. Total database size

[h2] PreparedStatement.setObject() with array not working properly

2014-11-20 Thread quotenjugendlicher
We are trying to delete an array of objects from a table by using the PreparedStatement.setObject() function, but it doesn't work at all. The code in question looks like this: try (PreparedStatement st = con.prepareStatement(DELETE FROM mqmessages WHERE id IN (?))) {

[h2] H2DB created on Linux fails to open on Mac

2014-11-20 Thread jason herman
Hi all, Here is what i'm doing: a) create an H2 Database using the R package RH2 on Ubuntu verify it works. b) put all database files into a tar archive, send to a Mac machine expand archive c) attempts to connect get the following error: Connecting to H2 DATABASE using url

[h2] Re: java.lang.NegativeArraySizeException (on H2 1.3.176 build)

2014-11-20 Thread Vishwa
Noel, I checked out 1.3.176 version and applied your changes, but still I get this error insert into StgRefSync.ZEUS_PRODUCTPRICE_INT_tmp_int(gta_reporting_company_id,country_id,product_code,price_code,effective_date) select * from StgRefSync.ZEUS_PRODUCTPR ICE_INT union select * from