• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Very odd connection error

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
Cheers
James
 
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic