File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Very odd connection error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Very odd connection error" Watch "Very odd connection error" New topic

Very odd connection error

Simon Machin

Joined: Jun 18, 2002
Posts: 5
When I run a program that connects to a DB2 backend on it's own, it connects with no problems. When I use the class from another program (the calling class is running inside a jar file) it produces this error. All the properties are the same: [IBM][JDBC Driver] CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at signet.internet.catalogueutils.DeleteFreeProduct.<init>(
at signet.internet.catalogueutils.DeleteFreeProduct.getInstance(
at signet.util.SKUImport.SKUFileWatcher.processFileArrived(
at signet.util.FileWatcher.notifyFileArrived(
It falls over at this line

I'm utterly stumped, any suggestions?
martin samm
Ranch Hand

Joined: Nov 09, 2000
Posts: 31
i presume you're running it on the same machine? i.e. can the machine giving the error 'see' the database? Also if it is a different database, is it restricted by IP? I'm not used to DB2, but certainly the above for Oracle would suggest the database has been brought down.

martin samm<BR>
I agree. Here's the link:
subject: Very odd connection error
It's not a secret anymore!