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 manning.com by Unknown author, 1 year ago
Table/View 'USERS' does not exist. Error Code: -1
via Coderanch by nav katoch, 11 months 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 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)
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
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)
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:319)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:566)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:452)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

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