java.sql.SQLException: *Incorrect syntax near the keyword 'escape'.*

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 cayenne-user by Andrus Adamchik, 6 months ago
*Incorrect syntax near the keyword 'escape'.*
via cayenne-user by Li Zhou, 1 year ago
*Incorrect syntax near the keyword 'escape'.*
via jtds by furnerc
, 1 year ago
Incorrect syntax near the keyword 'select'.
via by Unknown author, 2 years ago
via jtds by pauer
, 1 year ago
Cannot insert the value NULL into column 'completedFlag', table 'myDB.dbo.Tran'; column does not allow nulls. INSERT fails.
via Spring JIRA by nuytsm, 1 year ago
Incorrect syntax near 'nulls'.
java.sql.SQLException: *Incorrect syntax near the keyword 'escape'.*
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(
at org.apache.cayenne.access.jdbc.SelectAction.performAction(
at org.apache.cayenne.access.DataNodeQueryAction.runQuery(
at org.apache.cayenne.access.DataNode.performQueries(
at org.apache.cayenne.access.DataDomainQueryAction.runQuery(
at org.apache.cayenne.access.DataDomainQueryAction.access$000(
at org.apache.cayenne.access.DataDomainQueryAction$2.transform(
at org.apache.cayenne.access.DataDomain.runInTransaction(
at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(
at org.apache.cayenne.access.DataDomainQueryAction.execute(
at org.apache.cayenne.access.DataDomain.onQuery(
at org.apache.cayenne.util.ObjectContextQueryAction.runQuery(
at org.apache.cayenne.util.ObjectContextQueryAction.execute(
at org.apache.cayenne.access.DataContext.onQuery(
at org.apache.cayenne.access.DataContext.performQuery(

Users with the same issue

72 times, 6 months ago
3 times, 8 months ago
Once, 1 year ago
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 8 months ago

Write tip

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