• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 655
  • Last Modified:

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)
0
Anthony Lucia
Asked:
Anthony Lucia
  • 2
1 Solution
 
CEHJCommented:
:)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now