Hello,
The snippet of the logs only shows the query being executed. You will need to verify that using the same login and schema you have specified in your persistence.xml that the "SELECT BOOKID, INVENTORY, FIRSTNAME, SURNAME, PRICE, ONSALE, CALENDAR_YEAR, TITLE, DESCRIPTION FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = 207)" should return a value.
How are you inserting the data, and could you have told the provider to drop and create the tables in your persistence.xml?
Best Regards,
Chris
[Message sent by forum member 'chris_delahunt' (chris_delahunt)]
http://forums.java.net/jive/thread.jspa?messageID=318827