RE: locking and sql server..(was 'is this an old .97 bug?')

2003-03-13 Thread Ryan Vanderwerf
Just a follow up to this... setting the isolation level to 'serializable' does no good for preventing SequenceGenerator from giving out duplicate sequences when running multiple servlet engines on the same database (Using SQL server). In theory it should, but it doesn't. 2 App servers can read the

Re: locking and sql server..(was 'is this an old .97 bug?')

2003-03-11 Thread Armin Waibel
Hi Ryan, seems an endless story ;-) First, the 'isolation-level' attribute was only used for locking on ODMG-api level and was completely indenpendent from the database isolation level. > appears that 2 app servers grab out of the OJB_HL_SEQ table at exact > same time (looks like milliseconds d