aspose file tools*
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
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can we create auto key generation(sequence) for composite PK