• 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

Tomcat and DB2

 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to get connection pooling working with Tomcat 5.5 and DB2
v8.1. This was working under Websphere Studio Application Developer
5.x but we are trying to move onto Eclipse and Tomcat.

The datasources seem to get created correctly but I get an error when I
try to get the connection from the datasource:



I can issue a Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); command without getting any errors so it is finding the jar file.

I've tried renaming the db2java.zip to db2java.jar and moving it to
common\lib. No matter what I try I get the same error.


Any help that anyone can give would be greatly appreciated.


Thanks,


Jon
 
Ranch Hand
Posts: 326
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You're certainly on the right track.

All I can say is that I use oracle and keep the .jar with the driver in common/lib and have no problems. Did you restart tomcat after moving the jar to common/lib. Have you backed out any other changes that may have affected this?
 
Jon Christensen
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Here's an update:

I uninstalled Tomcat 5.5 and reinstalled it. Placed the db2java.jar into common\lib and into the classpath for the project. I started Tomcat through MyEclipse, not sure if it matters how I start it.



I can't tell if it is not finding the driver or if I am using the wrong driver.
[ October 25, 2005: Message edited by: Jon Christensen ]
reply
    Bookmark Topic Watch Topic
  • New Topic