Menu

SQLException JZ0S2 using Sybase jconn3

Vee
2006-09-01
2013-04-29
  • Vee

    Vee - 2006-09-01

    Hi,

    I am using the Sybase jConnect v6.0 JDBC and get the following exception thrown when I execute a query :-

    java.sql.SQLException: JZ0S2: Statement object has already been closed.
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.checkDead(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.close(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybStatement.close(Unknown Source)
        at net.sourceforge.sqlexplorer.sqlpanel.SQLExecution.doExecution(SQLExecution.java:178)
        at net.sourceforge.sqlexplorer.sqlpanel.AbstractSQLExecution$LocalThread.run(AbstractSQLExecution.java:61)

    This means that I cannot see the results of my queries.

    Could this be a problem with the plugin, or with something missing from my setup.

    many thanks,

    V

     
    • Davy Vanherbergen

      Hi,

      I believe I've found the issue.  I've made a new build available of the plugin.  The RCP version is still uploading.

      I don't have a Sybase db to test with, so I would appreciate if you could test the new build and let me know if it works.

      Thanks.

      Davy

       
      • Vee

        Vee - 2006-09-04

        Thanks Davy,

        That seems to be working fine.

         

Log in to post a comment.