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

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

    manning.com | 9 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, 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()
    2. oracle.toplink.essentials
      ServerSession.executeCall
      1. oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:319)
      2. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:566)
      3. oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:452)
      4. oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)
      4 frames