java.sql.SQLSyntaxErrorException: Table/View 'WEB_BOOKSTORE_BOOKS' does not exist. Error Code: -1 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) Here is the log file: "Record Number 906 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.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3 19) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database Accessor.java:566) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces sor.java:452)

Oracle Community | imatua | 8 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) Here is the log file: "Record Number 906 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.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3 19) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database Accessor.java:566) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces sor.java:452)
  2. 0

    Chapter 9 - Getting the following error message while running the client

    manning.com | 10 months ago
    java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist. Error Code: -1

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      Table/View 'WEB_BOOKSTORE_BOOKS' does not exist. Error Code: -1 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) Here is the log file: "Record Number 906 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.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed. Error Code: 40000 Call: SELECT BOOKID, FIRSTNAME, DESCRIPTION, PRICE, TITLE, ONSALE, SURNAME, CALENDAR_YEAR, INVENTORY FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query: ReadObjectQuery(com.sun.bookstore.database.Book) at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:3 19) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(Database Accessor.java:566) at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAcces sor.java:452)

      at oracle.toplink.essentials.threetier.ServerSession.executeCall()
    2. oracle.toplink.essentials
      ServerSession.executeCall
      1. oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)
      1 frame