Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Can we create auto key generation(sequence) for  composite PK Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can we create auto key generation(sequence) for  composite PK" Watch "Can we create auto key generation(sequence) for  composite PK" New topic
Author

Can we create auto key generation(sequence) for composite PK

bala kumar
Greenhorn

Joined: Sep 13, 2007
Posts: 10
Can we create auto key generation(sequence) for composite PK in ejb 2 in weblogic server.

Pls any help me.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
a surrogate key (a key generated from a sequence is independent of any logic or rules related to the row it identifies) and is by definition unique.

a composite key is used with natural keys or to identify a row in a fact table.

what is it you are trying to make unique with a composite key?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Can we create auto key generation(sequence) for composite PK
 
Similar Threads
Using generator with composite keys in hibernate
primary key generation in CMP
primary key generation in CMP
CMP 2.0 with oracle-sequence and composite primary key
Autokey generation and WAS