Re: [Springframework-developer] Problem with MySqlMaxValueIncrementer

[Isabelle M. <isa...@me...>]

Hi Thomas,

This is indeed better. I didn't know you could give last_insert_id an argument, which is why I was looping.

Isabelle

On Sat, May 31, 2003 at 02:11:56PM -0400, tri...@tr... wrote:
> 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
> 
> 
> 

-- 
Isabelle Muszynski
Software Engineer
Zandweellaan 4
2660 Antwerpen
Belgium
Tel. 32-(0)3-830 18 54
Mobile: 32-(0)485 49 50 89
Email: isa...@me...
Website: www.meta-logix.com