On 2013-09-22 15:10, Markus Waltl wrote:
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.
Nice debugging work.
Issue1 should probably be reported to the Hibernate as a bug fix.
Issue2 should probably be raised on the Hibernate mailing list as a
question. I'm guessing that it might be as simple as copying the
relevant support from the Hibernate Derby stuff to the Hibernate H2 stuff.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
