This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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 ]
 
wood burning stoves
 
subject: Entity primary key with null value
 
Similar Threads
long post IBM.158
JPA - Joining of two tables
primary key class of entity beans?
combining LEFT OUTER JOIN and WHERE
select count(*) from Table