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

Question

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?

score 9 · Answer 1 · edited Jul 12 '16 at 14:55

9

Add the two jars:

db2jcc.jar
db2jcc_license_cu.jar

Add them to the libraries jar folder.

edited Jul 12 '16 at 14:55

Gustavo Morales

2,614
9
29
37

answered Jul 12 '16 at 13:51

Ayanava Sarkar

371
3
4

add a link to where to get them and i'll be forever thankful – Joey Baruch Sep 14 '16 at 10:13
1

found [this one](http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg21385217) – Joey Baruch Sep 14 '16 at 10:40

score 3 · Accepted Answer · answered Oct 02 '13 at 02:06

3

Do you mean that your Worklight database is DB2-based? If yes,

make sure to also edit worklight.properties with the correct DB2 setup

Also make sure that:

the DB2 connector driver exists in the server\lib folder

answered Oct 02 '13 at 02:06

Idan Adar

44,156
13
50
89

1

Thank you, I added the DB2connector into the server\lib and it worked – Mindan Oct 02 '13 at 09:56

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

2 Answers2

Linked