java.lang.ClassNotFoundException: Class com.ibm.db2.jcc.DB2Driver not found in Worklight platform or project

java db2 ibm-mobilefirst
Mindan picture Mindan · Oct 2, 2013 · Viewed 35.4k times · Source

I try to test an sql adapter that connects to db2 but I get the following result:

java.lang.ClassNotFoundException: Class com.ibm.db2.jcc.DB2Driver not found in Worklight platform or project

here is my code: 

<dataSourceDefinition>
    <driverClass>com.ibm.db2.jcc.DB2Driver</driverClass>
    <url>jdbc:db2://localhost:50000/WLTEST</url>
    <user>db2admin</user>
    <password>db2admin</password> 
</dataSourceDefinition>

any idea what is going wrong?

Answer

Ayanava Sarkar picture Ayanava Sarkar · Jul 12, 2016

Add the two jars:

db2jcc.jar
db2jcc_license_cu.jar

Add them to the libraries jar folder.

Related questions

How do I connect to a Websphere Datasource with a given JNDI name?

I'm using Websphere Portal 7.0 and creating a portlet with RAD 8.0. My portlet is trying to make a db2 connection to a remote server. I wrote a java program locally to do a basic JDBC connection to the server and get …

Read More
What can SQL CODE -104 (error) represent?

I am executing an SQL query via jcc to run a report. When I opened the error log file for the program and examined the SQL query, everything seems to be fine (There are no extra or missing brackets, commas, …

Read More
How to identify DB2 port number

I have to make DB2 connection in java using port number. Is there any command in DB2 or any way that can get the DB2 port number? I have not used the default port 50000 while making DB2 connection as this …

Read More