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
  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 | 3 years ago | U-L
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "END" at line 1, column 121.
  3. 0

    Not able to start weblogic portal server

    Stack Overflow | 5 years ago | Harry Joy
    java.sql.SQLSyntaxErrorException: Schema 'WEBLOGIC' does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  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 : "".
  6. 0

    java.sql.SQLSyntaxErrorException: Table/View 'x' does not exist

    Stack Overflow | 2 years ago | jisteinberg
    java.sql.SQLSyntaxErrorException: Table/View 'ADDRESSES' does not exist

    4 unregistered visitors
    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