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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by imatua, 1 year ago
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
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(ServerSession.java:473)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.