Begin forwarded message: Date: June 13, 2005 9:57:55 AM PDT Subject: Auto generation of database keys
Hi,
I'm running into a locking issue when using generated keys. My primary key column is defined as�DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY. I don't care about the key being transactional. That is, if a transaction rolls back, I can live with the key that was allocated being permanently unused.
My application has two transactions inserting rows into the same table, and the threads have internal�synchronization such that I need to have both insert statements succeed independently. The isolation level is the default.�
Am I misusing the key generation? Can I get nontransactional key generation?
Thanks,
Craig Craig Russell P.S. A good JDO? O, Gasp!
|
smime.p7s
Description: S/MIME cryptographic signature
