DB2 Connection Issue using JDBC from eclipse

Question

I need to connect to a DB2 database server using jdbc from Eclipse. Even though I have already installed the required jar file, I am getting the following error:

Error occurred java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver
Error occurred java.sql.SQLException: No suitable driver found for jdbc:db2://db2server

What do I do?

Thanks.

duffymo · Accepted Answer · 2011-04-05 02:32:27Z

1

Make sure the JAR containing com.ibm.db2.jcc.DB2Driver is in your CLASSPATH.
If it is, check the URL syntax. That error usually means that the driver class was loaded, but the URL was incorrect. Here are the docs to show you what the correct syntax is.
If both of those look right, make sure that the server name is visible from your machine. Ping that machine name; find out that you have it in your hosts table.

answered Apr 5, 2011 at 2:32

duffymo

310k46 gold badges376 silver badges571 bronze badges

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

Comments

Sabir Khan · Accepted Answer · 2016-10-19 07:13:12Z

0

I had similar issue.

Well I tried to download IBM Driver and the Downloaded folder also contains db2jcc.jar and db2jcc4.jar put both these jars in WEB-INF/lib folder all do add them in classpath (Build path options). also your code must look something like this,

Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();

        //context
        //DataSource datasource = null;
    //  datasource = (DataSource)initCtx.lookup("jdbc:sqlserver://AZNICSQL02;DatabaseName=CIO;schemaName=dbo");


        //Connect to Data source
        dbconnection = DriverManager.getConnection("jdbc:db2://192.168.4.58:50001/", "", "");
        dbstatement = (Statement) dbconnection.createStatement();`

Try exploring in DataSource Explorer plugin in eclipse

edited Oct 19, 2016 at 7:13

Sabir Khan

10.2k7 gold badges51 silver badges105 bronze badges

answered Aug 7, 2012 at 18:54

tosha Shah

1,21711 silver badges13 bronze badges

Collectives™ on Stack Overflow

DB2 Connection Issue using JDBC from eclipse

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related