java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKSTORE_BOOKS' does not exist. Error Code: -1 Call: SELECT BOOKID, PRICE, DESCRIPTION, FIRSTNAME, TITLE, CALENDAR_YEAR, SURNAME, INVENTORY, ONSALE FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) Here is the Log File: Timestamp May 1, 2009 22:25:04.781 Log Level SEVERE Logger javax.enterprise.system.container.web Name-Value Pairs _ThreadID=19;_ThreadName=httpSSLWorkerThread-8080-1;_RequestID=5c7cf420-9f73-45c5-a393-1c1bcc55230f; Record Number 759 Message ID StandardWrapperValve[BookStoreServlet] Complete Message PWC1406: Servlet.service() for servlet BookStoreServlet threw exception Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b60e-fcs (12/23/2008))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKSTORE_BOOKS' does not exist. Error Code: -1 Call: SELECT BOOKID, PRICE, DESCRIPTION, FIRSTNAME, TITLE, CALENDAR_YEAR, SURNAME, INVENTORY, ONSALE FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by imatua, 1 year ago
: ReadObjectQuery(com.sun.bookstore.database.Book) Here is the Log File: Timestamp May 1, 2009 22:25:04.781 Log Level SEVERE Logger javax.enterprise.system.container.web Name-Value Pairs _ThreadID=19;_ThreadName=httpSSLWorkerThread-8080-1
via Coderanch by nav katoch, 1 year ago
via Oracle Community by 843830, 1 year ago
statement then 'U' is not a column in the target table. Error Code: -1 Call: select u from Users as u Query: DataReadQuery() PWC2775: Session attribute event listener threw exception Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink
via manning.com by Unknown author, 1 year ago
Table/View 'USERS' does not exist. Error Code: -1
via Oracle Community by 843841, 1 year ago
Schema 'ROOT' does not exist Error Code: -1 Call: SELECT studid, dob, grade, studentname, email FROM student Query: ReportQuery(database.Student)
java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKSTORE_BOOKS' does not exist.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1162)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:612)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:485)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.