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 | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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 | 7 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