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 | 8 months 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

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

    sourceforge.net | 1 year 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 | 8 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

    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