wood burning stoves*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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:
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:417)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:421)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:324)
at COM.ibm.db2.jdbc.app.DB2Driver.connect(DB2Driver.java:352)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at signet.internet.catalogueutils.DeleteFreeProduct.<init>(DeleteFreeProduct.java:71)
at signet.internet.catalogueutils.DeleteFreeProduct.getInstance(DeleteFreeProduct.java:105)
at signet.util.SKUImport.SKUFileWatcher.processFileArrived(SKUFileWatcher.java:159)
at signet.util.FileWatcher.notifyFileArrived(FileWatcher.java:227)
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>m_sam@rroom.net
jQuery in Action, 2nd edition
subject: Very odd connection error
Similar Threads
Error when getting a connection from DB2 DB
java DB2 program
DB2 Setup in Weblogic5.1/6.1
Problem in JDBC connection in Websphere 3.5.0
connect to db2 8 error using JDBC