File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Beginning Java and the fly likes Problem in running one resultset into another Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Problem in running one resultset into another" Watch "Problem in running one resultset into another" New topic
Author

Problem in running one resultset into another

arun mahajan
Ranch Hand

Joined: Dec 07, 2001
Posts: 305
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

Joined: May 10, 2001
Posts: 3244
Moving this to JDBC


Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem in running one resultset into another