Link to home
Start Free TrialLog in
Avatar of Anthony Lucia
Anthony Lucia

asked on

Eclipse Error: java.sql.SQLException: Error trying to load driver

From Eclipse I added a database connection using JDBC.  To do this I did the following

I created a User Library, as follows

    Windows -> Preferences -> Java -> Build Path => User Libraries

    Then press the 'New' button, and create a lib

    Then hit the 'Add External JARs' button to add JARS external to ECLIPSE

Open in new window


From there I loaded the following files:

    db2jcc.jar
    db2jcc_license_cu.jar

Open in new window


Then I added the User Library I created to the project Build path as follows:

    - Rt click on the project
    - click on Properties
    - Click on "Java Build Path"
    - Check "TEST_LIB" (the name of the User Library

Open in new window


Then I selected the Driver name class from the wizard (now that the libraries are in the project, magically the GUI can see the class name

    com.ibm.db2.jcc.DB2Driver

Open in new window


I select the class name and put in a url, and TEST THE CONNECTION

The test of the connection is SUCCESSFUL  !!!!

I am happy so I pop in a prepared statement:

    SELECT SUM(BALANCE) FROM ACCOUNT

Open in new window


And then I run the flow as a "Mule Application"

But when I sent an http message to it I  get the following error:

    java.sql.SQLException: Error trying to load driver: com.ibm.db2.jcc.DB2Driver :
    com.ibm.db2.jcc.DB2Driver (org.mule.module.db.internal.domain.connection.Connect
    ionCreationException). Message payload is of type: String

Open in new window


So I can now test the connection when the flow is not running, but when the flow is running, it can not find the driver I used to test the connection with

Any ideas of where I should look to resolve this issue

(Mode:  Previously I inadvertently posted duplicate threads, so I deleted/clear up the previous threads, and am consolidating them to this one)
ASKER CERTIFIED SOLUTION
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
:)