java.sql.SQLException: Invalid JDBC escape syntax at line position 29 '}' character expected. at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:238) at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:789) at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:891) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:894) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:825)

jtds | peterschaefer | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    {fn } escape can't handle nested functions

    jtds | 1 decade ago | peterschaefer
    java.sql.SQLException: Invalid JDBC escape syntax at line position 29 '}' character expected. at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:238) at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:789) at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:891) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:894) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:825)

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid JDBC escape syntax at line position 29 '}' character expected. at net.sourceforge.jtds.jdbc.SQLParser.mustbe(SQLParser.java:238) at net.sourceforge.jtds.jdbc.SQLParser.escape(SQLParser.java:789) at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:891) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:894) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:825)

      at de.ecosx.jdbctest.QueryThread.run()
    2. de.ecosx.jdbctest
      QueryThread.run
      1. de.ecosx.jdbctest.QueryThread.run(QueryThread.java:106)
      1 frame