java.sql.SQLException: The SET SHOWPLAN statements must be the only statements in the batch. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)

sourceforge.net | 4 months ago
  1. 0

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

    sourceforge.net | 11 months ago
    java.sql.SQLException: The SET SHOWPLAN statements must be the only statements in the batch. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
  2. 0

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

    sourceforge.net | 4 months ago
    java.sql.SQLException: The SET SHOWPLAN statements must be the only statements in the batch. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)
  3. 0

    Statement.execute() raises executeQuery() exception

    jtds | 1 decade ago | michael_69
    java.sql.SQLException: The SET SHOWPLAN statements must be the only statements in the batch. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) 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

    SQuirreL SQL Client / Mailing Lists

    sourceforge.net | 1 year ago
    java.sql.SQLException: Line 1: Incorrect syntax near '-'. at = net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:= 365) at = net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at = net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at = net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at = net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.jav= a:418) at = net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1= 258) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.tab= le.ContentsTab.createDataSet(ContentsTab.java:325) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Bas= eDataSetTab$1.run(BaseDataSetTab.java:123) at = net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:8= 2)
  6. 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)

    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

      The SET SHOWPLAN statements must be the only statements in the batch. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1114)

      at SQLSample.getQueryCost()
    2. Unknown
      SQLSample.body
      1. SQLSample.getQueryCost(SQLSample.java:4225)
      2. SQLSample.MSSQL_plan_statement(SQLSample.java:4160)
      3. SQLSample.body(SQLSample.java:480)
      3 frames
    3. com.cas
      Module.exec
      1. com.cas.Module.exec(Module.java:1260)
      1 frame
    4. Unknown
      SQLSample.main
      1. SQLSample.main(SQLSample.java:564)
      1 frame