org.apache.derby.client.am.SqlException: Column 'BOOKID' 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 'BOOKID' is not a column in the target table.Error Code: -1 Call:SELECT bookid, author, price, title, inventory, catagory FROM BOOKS WHERE (catagory = CAST (? AS VARCHAR(32672) )) bind => [Technical] Query:ReportQuery(cart.Books)

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

Solutions on the web

via Oracle Community by 843830, 1 year ago
statement then 'BOOKID' is not a column in the target table.Error Code: -1 Call:SELECT bookid, author, price, title, inventory, catagory FROM BOOKS WHERE (catagory = CAST (? AS VARCHAR(32672) )) bind => [Technical] Query:ReportQuery(cart.Books)
via Oracle Community by 843830, 1 year ago
statement then 'BOOKID' is not a column in the target table.Error Code: -1 Call:SELECT bookid, author, price, title, inventory, catagory FROM BOOKS WHERE (catagory = CAST (? AS VARCHAR(32672) )) bind => [Technical] Query:ReportQuery(cart.Books)
via GitHub by glassfishrobot
, 7 months ago
Syntax error: Encountered "\'Attleboro\'" at line 1, col umn 152.Error Code: -1 Call:SELECT t0.ID, t0.NAME, t0.FK5_FOR_CUSTOMER_TABLE, t0.CODE, t0.COUNTRY, t0.FK6_FOR_CUSTOMER_TABLE FROM CUSTOMER_TABLE t0, ADDRESS t1 WHERE ((t1.CITY IN 'Attleboro') AND (t1.ID = t0.FK6_FOR_CUSTOMER_TABLE)) Query:ReportQuery(com.sun.ts.tests.ejb30.persistence.query.language.schema30.Customer)
via Oracle Community by 843859, 4 months ago
Syntax error: Encountered ":" at line 1, column 67.Error Code: -1 Call:select count(d) from App.Documents as d where d.PERSONALACCOUNT = :suppAcc; Query:DataReadQuery()
via Oracle Community by loopdruid, 1 year ago
Table 'SEQUENCE' does not exist.Error Code: -1 Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? bind => [50, SEQ_GEN] Query:DataModifyQuery()
via Oracle Community by 807581, 1 year ago
Table 'WEB_BOOKSTORE_BOOKS' does not exist.Error Code: -1 Call:SELECT BOOKID, INVENTORY, DESCRIPTION, PRICE, TITLE, FIRSTNAME, SURNAME, ONSALE, CALENDAR_YEAR FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) bind => [203] Query:ReadObjectQuery(com.sun.bookstore.database.Book)
org.apache.derby.client.am.SqlException: Column 'BOOKID' 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 'BOOKID' is not a column in the target table.Error Code: -1 Call:SELECT bookid, author, price, title, inventory, catagory FROM BOOKS WHERE (catagory = CAST (? AS VARCHAR(32672) )) bind => [Technical] Query:ReportQuery(cart.Books)
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.executeCall(UnitOfWorkImpl.java:1355)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)

Users with the same issue

You are the first who have seen this exception.

Write tip

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