bob mcgee wrote: > On Jul 21, 10:10 am, Jesse Long <[email protected]> wrote: > >> Notice the part where they neglect to document lack of DDL support? >> > That's because it's different for every database. JDBC specifies an > interface, and > methods to discover the capabilities of a DBMS, but it can't add the > features itself. > DDL transactions aren't supported by all major DBMSes -- MySQL, for > example > lacks them. > I see. Yesterday I was just a little frustrated at the gotcha. JDBC docs never mention any chance that DDL wont work, H2 implements JDBC, H2 doesn't say "except DDL in transactions", I had no reason to expect it not to support it. Could have saved some time by reading a that in the docs somewhere.
Anyways, as far as MySQL support goes, they also dont support actual enforcement of foreign keys last time I used, so.... Not to mention performance when joining anything but the smallest tables.... > This feature is coming though -- it's been in the Roadmap for a while, > and Thomas > just bumped it up a bunch in priorities. Let it never be said he > isn't responsive to > feature requests! > > See for proof: > http://code.google.com/p/h2database/source/diff?spec=svn1665&r=1665&format=side&path=/trunk/h2/src/docsrc/html/roadmap.html > Awesome, thanks Thomas! Cheers, Jesse --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
