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)
Anthony LuciaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CEHJCommented:
:)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.