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
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>
It is sorta covered in the JavaRanch Style Guide.
subject: Very odd connection error