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
  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)
  2. 0

    Incorrect comments processing inside callable statement

    jtds | 6 years ago | niagarafaults
    java.sql.SQLException: Invalid JDBC escape syntax at line position 19 '}' character expected.
  3. 0

    jTDS - SQL Server and Sybase JDBC driver / Bugs / #500 Statement.execute() raises executeQuery() exception

    sourceforge.net | 4 months ago
    java.sql.SQLException: The executeQuery method must return a result set. at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:952) at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541) at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:464) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    jTDS - SQL Server and Sybase JDBC driver / Bugs / #500 Statement.execute() raises executeQuery() exception

    sourceforge.net | 11 months ago
    java.sql.SQLException: The executeQuery method must return a result set. at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:952) at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541) at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:464) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
  6. 0

    Statement.execute() raises executeQuery() exception

    jtds | 1 decade ago | michael_69
    java.sql.SQLException: The executeQuery method must return a result set. at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:952) at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541) at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:464) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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