Solved

"Invalid operation : result set closed" ??

Posted on 2004-03-30
6
1,383 Views
Last Modified: 2012-05-04
I am using UDB 8.0 on Windows (trial version).I am using type 4 driver (db2jcc.jar) and my Web application
runs on Weblogic 7.1sp3.I call a stored procedure (witih an EJB method) that returns me a resultSet of 5 records.I traverse thru the result set using a simple while(rs.next()) { ...}.

I am seeing that after reading the first record when it comes back to read the second record (ie calls while(rs.next() the second tiime) , an SQLException is thrown saying "Invalid operation : result set closed".Sounds strange since in the while loop the resultSet rs is never closed.

Would really appreciate, if anyone could give me hints what could be going wrong ?

Thanks in advance
-mmarwaha
0
Comment
Question by:mmarwaha
6 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 10715859
are you debugging this ?
has db2 closed the cursor / recordset because of a timeout...?

0
 

Author Comment

by:mmarwaha
ID: 10720915
No, I am not debugging this.Its happening in a normal flow.
0
 

Expert Comment

by:jakeDBA
ID: 10731945
I'm having a very similar problem -- a db2 udb 8.1 based app using ejb with jboss. Get the same error when it's clear I'm not explicity closing the resultset.  I'm also using the type 4 driver. I tried setting the "holdability" to HOLD_ACROSS_COMMITS as has been discussed elsewhere on the net, but this did not help.  Have you had any luck yet?

JakeDBA
0
 

Author Comment

by:mmarwaha
ID: 10732010
Yes, to some extent I could figure out the problem.We are using hibernate as our DAO layer to interact with the
database.My problem was I was using the same connection object to initialize the hibernate session and also used the
same connection object to create my statement within the same scope.When I explicitly used a different connection object for the hibernate session, my problem was solved.

I guess you should check that your connection,statement and result set is not used explicilty for the query/stored proc you are worried about.

Hope this helps
-mmarwaha
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12416232
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question