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 Android Security Essentials Live Lessons this week in the Android 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 ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Entity primary key with null value
 
Similar Threads
JPA - Joining of two tables
long post IBM.158
primary key class of entity beans?
combining LEFT OUTER JOIN and WHERE
select count(*) from Table