[hai]

Hi,

I am getting a DB2 driver error when I try to start Tomcat within MyEclipse.
It complains that the driver is not found.
I have added it to the %Catalinea_HOME%/common/lib/db2java.jar.
It works when I start Tomcat outside of MyEclipse environment but not within.
Any suggestion would be helpful.

Thanks,
Hai

[Riyad Kalla]

Hai,
You need to “Append to Classpath” your db2java.jar file. Go to Window > Preferences > MyEclipse > Application Servers > Tomcat 5 > Paths, from there click the “Add ZIP/JAR” button next to the “Append to Classpath” section, and add it.

[hai]

Hi Riyad,

I’ve tried appending the db2java.jar file to classpath in MyEclipse preference but I am still getting the same error below. It will work if I start Tomcat outside of the MyEclipse IDE. My environment has the following configurations:

Win2K
SUN JDK 1.4.2.03
Eclipse 3.0M8
MyEclipse 3.7.2

Thanks for you help,
Hai

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class ‘COM.ibm.db2.jdbc.app.DB2Driver’ for connect URL ‘jdbc:db2:FLEETUDB’, cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:243)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at com.dcx.slsmkt.webfleet.component.db.util.DataSourceUtil.getConnection(DataSourceUtil.java:104)
at com.dcx.slsmkt.vehicleremarketing.security.VRSecurityManager.getConnection(VRSecurityManager.java:76)
at com.dcx.slsmkt.vehicleremarketing.security.VRSecurityManager.getUserProfile(VRSecurityManager.java:316)
at com.dcx.slsmkt.vehicleremarketing.security.VRSecurityManager.login(VRSecurityManager.java:140)
at com.dcx.slsmkt.vehicleremarketing.action.LoginAction.performTask(LoginAction.java:76)
at com.dcx.slsmkt.vehicleremarketing.servlet.VehicleRemarketingServlet.execute(VehicleRemarketingServlet.java:129)
at com.dcx.slsmkt.vehicleremarketing.servlet.VehicleRemarketingServlet.doPost(VehicleRemarketingServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

[Riyad Kalla]

Hai,
Does this thread help at all: https://www.genuitec.com/forums/topic/db-driver-not-found-when-starting-from-myeclipseide-closed/&highlight=com+ibm+db2+jdbc+app+db2driver

[hai]

Riyad,

Thank you very much. That is the solution to my problem.

Hai

[Riyad Kalla]

Great, I’m glad to hear it worked.

[Author]

Posts