Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create an entity having multiple primary keys.

PamelaApr 7 2015 — edited Apr 7 2015

Hello,

Jdeveloper Version 11.1.2.4.0

I am trying to create an entity object based on a table with 5 columns. The combination between them is unique.

I make the five columns primary keys, but when I delete a row I get: RowAlreadyDeletedException, though the row still exists in the database.

Also when displaying the view sometimes I get JBO-25019: Entity row of key oracle.jbo.Key[1 2 null null null].



How to create an Entity object having a Primary Key based on a multiple columns?

I don't want to add an additional column just for a Primary Key because this table is used in many PL/SQL procedures and I am not sure, that this won't affect them.

Also using Rowid as a primary key must be avoided.

Regards,

Pamela.

This post has been answered by Timo Hahn on Apr 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2015
Added on Apr 7 2015
4 comments
691 views