It's nice to read this discussion. Thanks for the focus on HSQLDB. I'd like to add a few comments.
- Open source databases are advancing very quickly. Firebird was missing from the comments and shouldn't be neglected. - There is an order of magnitude of difference between any Java database and non-java ones as far as J2EE use is concerned. You cannot package a non-Java database into the Java install! Specific to HSLQDB, the other order of magnitude of difference is speed for smaller (say 100MB) databases. - SQL standards do stipulate that you can insert many rows containing nulls in the columns of UNIQUE constraints. We had no other than the convenor of the SQL Standard Committee comment on this regarding HSQLDB (which is now compliant). As this feature is not supported uniformly amon different database engines, it should be handled with care in multi-target db applications. - getGeneratedKeys() is a tricky JDBC method and needs a lot of things to consider before it can be implemented. For example, in HSQLDB, you can reset the IDENTITY column of a whole table with a command such as "UPDATE mytable SET idcolumn = null". Now if there are a million rows in that table, are we supposed to keep all the new identity values in the current session just in case the next call is getGeneratedKeys()? - we are currently working specifically on JBoss MQ usage in HSQLDB and have already improved it a lot (I have commented on this recently in the JMQ forum). Please try the latest 1.8.0.RC4 and comment. RC5 should be out soon. Fred Toussi Maintainer, HSQLDB Project View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3863270#3863270 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3863270 ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
