aspose 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
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