[Chicago] auto incrementing - what options do we have?

David Durham, Jr. david.durham.jr at gmail.com
Fri Oct 10 19:31:46 CEST 2008


>  > So what would be the transaction isolation in this case? Is that
>  >  session option or do I change it only on first insert?
>
> I think you want repeatable read or read serializable.  Here's a
>  Google feeling lucky for read serializable:
>
>  http://www.devx.com/getHelpOn/10MinuteSolution/16488/1954

..

Forgot to say that this can look like this:

   set transaction isolation level read serializable

and yes, this applies to an SQL Session.

-Dave


More information about the Chicago mailing list