java.sql.SQLException

*Incorrect syntax near the keyword 'escape'.*

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4957

  • via cayenne-user by Andrus Adamchik, 2 weeks ago
    *Incorrect syntax near the keyword 'escape'.*
  • via cayenne-user by Li Zhou, 9 months ago
    *Incorrect syntax near the keyword 'escape'.*
  • via Apereo Issues by Dan McCallum, 1 year ago
    Incorrect syntax near the keyword 'as'.
  • Stack trace

    • java.sql.SQLException: *Incorrect syntax near the keyword 'escape'.* at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776) at org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71) at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87) at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269) at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422) at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69) at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395) at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850) at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392) at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121) at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743) at org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:333) at org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96) at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278) at org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    2 times, 1 month ago
    Unknown user
    Once, 5 months ago
    24 more bugmates