CODEWITHSUNDEEP
javasql-serverstored-proceduresjdbcresultset
Waseem
Waseem

Reputation: 11

java.sql.SQLException: Invalid state, the ResultSet object is closed

I am trying to run StoredProcedure using jtds. My database is on SQL SErver 2008

private String DRIVER_NAME_VALUE = "net.sourceforge.jtds.jdbc.Driver";  
private String URL_VALUE = "jdbc:jtds:sqlserver://"; 
...
cstmt =dbConnection.getCallableStatement("{? = call dbo.GetAgentStats (?)}");
.
.
.
rs = cstmt.executeQuery();

when trying to go over the Result set I got the Exception:

java.sql.SQLException: Invalid state, the ResultSet object is closed.
        at net.sourceforge.jtds.jdbc.JtdsResultSet.checkOpen(JtdsResultSet.java:299)
        at net.sourceforge.jtds.jdbc.JtdsResultSet.first(JtdsResultSet.java:527)
        at com.verint.impact360.WFM_plugins.CCE.CCEASCMAdapter.runReport(CCEASCMAdapter.java:238)
        at com.verint.impact360.WFM_plugins.CCE.CCEASCMAdapter.retrieveData(CCEASCMAdapter.java:131)
        at com.bluepumpkin.Plugins.PTeXtender.GenericDCSPlugin.retrieveStatisticsData(GenericDCSPlugin.java:332)
        at com.bluepumpkin.Plugins.PTeXtender.GenericDCSPlugin.start(GenericDCSPlugin.java:68)
        at com.verint.impact360.WFM_plugins.CCE.CCEASCMAdapter.main(CCEASCMAdapter.java:75)
Logger.logStackTrace():----- End Stack Trace   ------

Is it related to SQL Server 2008? I am not sure ,but I didn't have this error when connectig to SQL Server 2005.

Thanks

Upvotes: 1

Views: 13425

Answers (1)

BalusC
BalusC

Reputation: 1108802

You can only iterate over the ResultSet when it has not already been closed by calling close() on ResultSet, Statement and/or Connection.

If your actual intent is to pass the content of the ResultSet out of the scope of the method where it is been created, then you should be mapping this to a List<SomeObject> first and then return it instead. Or if your actual intent is to pass it to some other class/method which expects a ResultSet as argument (which is by its own a poor design, but that aside), then you should be doing that inside the very same try block as the ResultSet is been created.

Upvotes: 5

Related Questions