File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Entity primary key with null value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Entity primary key with null value" Watch "Entity primary key with null value" New topic
Author

Entity primary key with null value

Jack Lau
Ranch Hand

Joined: Aug 30, 2002
Posts: 166
Hello,

I have written a SQL statement for currency table and customer_bank table, but the selected fields no need to include the primary key "curr_code" in the statement. When I run the application, it shows the following message. So I add the primary key fields to the select statement, however, it also show the same message. Finally, I replace the outter join "curr.curr_code (+)= cb.bank_curr_code" into inner join "curr.curr_code = cb.bank_curr_code", it works but the result is not I expected.

Is the primary key of the entity must selected or fill in non-null value?



Thanks,
Jack
[ December 17, 2007: Message edited by: Jack Lau ]
 
 
subject: Entity primary key with null value