• Post Reply Bookmark Topic Watch Topic
  • New Topic

Very odd connection error

Simon Machin
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!