Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem in running one resultset into another  RSS feed

 
arun mahajan
Ranch Hand
Posts: 305
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was trying for the following code but it runs one time and gives error after tha:

it runs for one time and than gives error:
java.sql.sqlException Object has been closed
I am trying it with JRUN 3.1 and java 1.3
When I tried debug I found that at the end of first run:
1. conn was available
2. rs1 and rs2 was available
3. st1 and st2 was available
To try for workaround when I created two connection separately it runs very well.
I tried finding the reason for this behaviour in API but failed. Am I missing something on API?
can somebody please explain this
[ July 29, 2002: Message edited by: arun mahajan ]
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving this to JDBC
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!