Hi, I am using H2 in combination with Hibernate in our project. Now we are selecting data from tables and Hibernate creates us the query.
I have now two issue from which I solved one myself. First, H2 and temporary tables from Hibernate are not working very well. The issue is that Hibernate generates the table by using "on commit drop" which leads to the creating and immediate dropping of the tables due to automatical commit of created tables. I am not able to disable autocommit as it interferes with other scripts we are using. My solution for this was to overwritte the H2Dialect from Hibernate by replacing "on commit drop" with "on commit delete rows" which seems more appropriate. (Note: this should help others having the same issue". My second issue is that Hibernate generates queries with subquery having multiple columns in the return statement which seems not to be support in H2 (even in 1.3.173). Will this be supported soon or is there a way to overcome this issue (e.g., telling hibernate not to generate such queries). This would be very import to get solved as I am not able to change anything on the SQL statements as they are optimized for Oracle. We want to use H2 for testing purposes due to the ease of generating, deleting and modyfing the database. Best regards, Markus -- 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 to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
