db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Craig Russell <Craig.Russ...@Sun.COM>
Subject Fwd: Auto generation of database keys
Date Mon, 13 Jun 2005 17:31:15 GMT


Begin forwarded message:

> From: Craig Russell <Craig.Russell@Sun.COM>
> Date: June 13, 2005 9:57:55 AM PDT
> To: sun-derby-discuss@Sun.COM
> 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
> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
> 408 276-5638 mailto:Craig.Russell@sun.com
> P.S. A good JDO? O, Gasp!
>

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!


Mime
View raw message