Connect to DB2 database in eclipse via jdbc

Question

I'm trying to connect to an IBM DB2 database with Eclipse (version Juno) via JDBC. I've added the drivers (external jar files) to my project and the driver is loaded correctly ...

public static void main(String[] args) throws SQLException, ClassNotFoundException {
    Class.forName("com.ibm.db2.jcc.DB2Driver");
    System.out.println("Driver loaded");

    Connection dbConn = DriverManager.getConnection("jdbc:db2://***.**.***.*:50000/BWUEBDB", "username", "password");
    System.out.println("Connected");
}

I also know that the connection data (database path, username, password) is correct. But I get a java.lang.NoClassDefFoundError:

Exception in thread "main" java.lang.NoClassDefFoundError: sun/io/UnknownCharacterException
    at com.ibm.db2.jcc.b.a.<init>(a.java:238)
    at com.ibm.db2.jcc.b.b.a(b.java:1624)
    at com.ibm.db2.jcc.c.p.a(p.java:350)
    at com.ibm.db2.jcc.c.p.<init>(p.java:404)
    at com.ibm.db2.jcc.b.b.<init>(b.java:256)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:163)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at AppTest.main(AppTest.java:17)
Caused by: java.lang.ClassNotFoundException: sun.io.UnknownCharacterException
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    ... 9 more

There must be something wrong with the project properties but I really don't know where to look for.

Do your username or password contain non-ASCII characters, by chance? — mustaccio
– mustaccio, Commented May 22, 2014 at 13:09
What JRE are you using? It seems that sun.io.UnknownCharacterException is not found, and that might be specific to Sun/Oracle JREs. Have you tried an alternate method, such as instantiating a com.ibm.db2.jcc.DB2SimpleDataSource instance? — nitind
– nitind, Commented May 22, 2014 at 14:50
I didn't get it working with com.ibm.db2.jcc.DB2SimpleDataSource. Could you provide example code fitting to my case? I'm using JRE 1.4 btw. — mosquito87
– mosquito87, Commented May 26, 2014 at 6:40

Gaurav Swaroop · Accepted Answer · 2014-10-09 05:50:12Z

7

I was getting the same error. I was running it using java 8, I switched to Java 7 and it worked.

answered Oct 9, 2014 at 5:50

Gaurav Swaroop

1,25112 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Odihase · Accepted Answer · 2015-02-19 08:56:04Z

6

What Version of driver do you use? I encountered the same problem with Java 1.8 and driver version 2 (named db2jcc.jar). Using the driver version 4 (named db2jcc4.jar) it works flawlessly. Be sure, when using e.g. tomcat, that only the right driver is persistent in the lib-directory. If both drivers are persistent, it will strictly use the old one (version 2).

answered Feb 19, 2015 at 8:56

Odihase

631 silver badge6 bronze badges

2 Comments

bourbert Over a year ago

I had to switch to DB2JCC4 Version 4.19.26 to make it work with AIX+Java8. Got it from IBM: www-01.ibm.com/support/docview.wss?uid=swg21363866

BigRedBettaFish Over a year ago

I switched from db2jcc-1.3.1.jar to db2jcc-1.4.2.jar to fix this issue with Java 8.

AngocA · Accepted Answer · 2014-05-22 13:57:39Z

2

Try to use the direct connection from the driver, having the same classpath and user. In this way you can ensure that your environment is correctly configured, and the problem is from Java.

http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_rjv00004.html

java com.ibm.db2.jcc.DB2Jcc -url jdbc:db2://mysys.myloc.svl.ibm.com:446/MYDB -user db2user -password db2pass -tracin

You can even configure this line in Eclipse, by passing the parameters in the "Run..." dialog, and using the same classpath as you run your app.

answered May 22, 2014 at 13:57

AngocA

7,7046 gold badges42 silver badges57 bronze badges

Comments

Paul Roub · Accepted Answer · 2017-10-19 18:27:20Z

0

After I change the DB2 jar to db2jcc4-9.7.jar it works correctly without any issue.

The JDK version that I am using is 1.8.0_131

edited Oct 19, 2017 at 18:27

Paul Roub

36.5k27 gold badges88 silver badges95 bronze badges

answered Oct 19, 2017 at 17:55

Augustine Joseph

2,2872 gold badges17 silver badges16 bronze badges

Collectives™ on Stack Overflow

Connect to DB2 database in eclipse via jdbc

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related