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
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!