Re: [Springframework-developer] Problem with MySqlMaxValueIncrementer

[<tri...@tr...>]

Isabelle and All,

I have commited my changes to the MySQLMaxValueIncrementer.  

You now declare the "sequence" table like this:
 
   create table sequence (id int not null) type=MYISAM;
   insert into sequence values(0);

No need for auto-increment for either table.  The "type=MYISAM" is nor 
necessary, but it underscores that this table is not part of any transaction.

Everything else works the same.

I changed the increment logic to use

   update sequence set id=last_insert_id(id+?);

where ? is the batch size.

This works fine during my testing.  Let me know if you run in to any problems.

I'll make some changes to the OracleSequenceMaxValueIncrementer next.

--Thomas