org.apache.derby.client.am.SqlException: 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()

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 843859, 5 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 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 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 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 rooz, 1 year ago
Syntax error: Encountered "*" at line 1, column 199.Error Code: -1 Call:SELECT t0.ID, t0.NODO_ID, t0.ATTORE_ID, t0.STATOORDINE_ID, t0.CLASSIFICAZIONE_ID FROM ordini t0 LEFT OUTER JOIN an_nodi t1 ON (t1.ID = t0.NODO_ID) WHERE ((t1.NOME = 'abc') OR t0.NODO_ID =* NULL) Query:ReportQuery(it.test.app.entity.Ordine)
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)
org.apache.derby.client.am.SqlException: 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()
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.threetier.ServerSession.executeCall(ServerSession.java:465)
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.