[Springframework-developer] JDBC Insert functionality for HSQL

[Ken K. <kk...@kk...>]

Thomas,

I have been using the incrementers for Mysql and Hsql for the petclinic 
demo. The Mysql version of the incrementer was changed to use an  UPDATE 
statement on the sequence. The Hsql version uses an INSERT statement as 
the Mysql version used to do. I notice that the Hsql version  leaves 
extra rows in the sequence table because of this. There also is a 
different way  of caching blocks of keys. I don't understand why this is 
so. Is this something that just never got changed after the Mysql 
version got reworked ???

I have pretty much completed and tested (with the exception of testing 
on the Oracle version) most of my proposed refactoring of this class 
hierarchy. Should the Hsql version be changed to use a similar 
implementation as Mysql ???

It seems like they could both use the virtually the same code with the 
exception of the SQL used to get the last inserted value.

Regards,

Ken Krebs