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)

Oracle Community | imatua | 8 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKS

    Oracle Community | 8 years ago | imatua
    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)
  2. 0

    SQL error with javadb

    Stack Overflow | 4 years ago | U-L
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "END" at line 1, column 121.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Not able to start weblogic portal server

    Stack Overflow | 5 years ago | Harry Joy
    java.sql.SQLSyntaxErrorException: Schema 'WEBLOGIC' does not exist
  5. 0

    how can i redesign this query?

    Stack Overflow | 5 years ago | Suhail Gupta
    java.sql.SQLSyntaxErrorException: Lexical error at line 1, column 18. Encountered: "@" (64), after : "".
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    Table/View 'WEB_BOOKSTORE_BOOKS' does not exist.

    at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException()
  2. Apache Derby Client JDBC Driver
    Connection.prepareStatement
    1. org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
    2. org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
    3. org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
    3 frames
  3. Embedded GlassFish Web
    ConnectionHolder.prepareStatement
    1. com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475)
    1 frame
  4. oracle.toplink.essentials
    DatabaseAccessor.basicExecuteCall
    1. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1162)
    2. oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:612)
    3. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:485)
    3 frames