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
  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 | 6 months ago
    java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist. Error Code: -1
  3. 0

    items not found ejb exception ,plzz gius help

    Oracle Community | 9 years ago | 843830
    java.sql.SQLSyntaxErrorException: Column 'U' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE 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 Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Column 'U' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'U' is not a column in the target table. Error Code: -1 Call: select u from Users as u Query: DataReadQuery()
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot Deploy Ear - EJB Timer Service Not Available

    Oracle Community | 5 years ago | sdoca
    java.sql.SQLSyntaxErrorException: Table/View 'EJB__TIMER__TBL' does not exist. Error Code: 30000 Call: SELECT COUNT("TIMERID") FROM "EJB__TIMER__TBL" WHERE ("APPLICATIONID" = ?) bind => [1 parameter bound] Query: ReportQuery(name="countTimersByApplication" referenceClass=TimerState sql="SELECT COUNT("TIMERID") FROM "EJB__TIMER__TBL" WHERE ("APPLICATIONID" = ?)")
  6. 0

    Cannot Deploy Ear - EJB Timer Service Not Available

    Oracle Community | 5 years ago | sdoca
    java.sql.SQLSyntaxErrorException: Table/View 'EJB__TIMER__TBL' does not exist. Error Code: 30000 Call: SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID", "CREATIONTIMERAW", "INITIALEXPIRATIONRAW", "INTERVALDURATION", "LASTEXPIRATIONRAW", "OWNERID", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?)) bind => [2 parameters bound] Query: ReadAllQuery(name="findTimersByOwnerAndState" referenceClass=TimerState sql="SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID", "CREATIONTIMERAW", "INITIALEXPIRATIONRAW", "INTERVALDURATION", "LASTEXPIRATIONRAW", "OWNERID", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?))")

    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. 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