*
The moose likes JDBC and the fly likes invalid Handle exception!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "invalid Handle exception!!" Watch "invalid Handle exception!!" New topic
Author

invalid Handle exception!!

Naresh Rajan
Ranch Hand

Joined: Sep 08, 2005
Posts: 45
Hi i am developing an application which goes like this

f= new FileOutPutSTream(fil2);
b = new BufferOutPutStream(f);

while(resultSet.next()){
b.write(resultSet.getString("asda").getBytes());
b.write(resultSet.getString("asda").getBytes());
b.write(resultSet.getString("asda").getBytes());
b.write(resultSet.getString("asda").getBytes());

//Calling a method which calls an insert SP
insertASD(String,String,String);

}

If I have the insertASD() method then an IOException (The handle is invalid). If I remove the call insertASD() method thus not inserting into the database,I dont get the exception. Please help me in this regard.


Am not a pro and thats why am here!!!
Edward Harned
Ranch Hand

Joined: Sep 19, 2005
Posts: 291

About the only thing I can say for certain is that this is not a Thread problem and you are in the wrong forum.

Perhaps JDBC (since you're using resultSet) or I/O and Streams.


Ed's latest article: A Java Parallel Calamity http://coopsoft.com/ar/Calamity2Article.html
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24183
    
  34

Off to JDBC.


[Jess in Action][AskingGoodQuestions]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: invalid Handle exception!!
 
Similar Threads
column exist but ResultSet.getString(String) return invalid column name
Stored proc not found...
Record store does not remain persistant throughout various openings of MIDLet
Handle is invalid!!!
Writing files across network