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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Re: likeIgnoreCaseDbExp syntax error in 3.0.1
    via by Andrus Adamchik,
  • likeIgnoreCaseDbExp syntax error in 3.0.1
    via by Li Zhou,
  • Consulta bibliográfica - Derecho de Autor
    via by Unknown author,
  • Consulta bibliográfica - Derecho de Autor
    via by Unknown author,
  • Upgrade to 6u29 JTDS fails
    via jtds by agility
    ,
    • 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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    odd
    odd2 times, last one,
    Unknown visitor1 times, last one,
    24 more bugmates