java.sql.SQLException: No suitable driver - COM.ibm.db2.jdbc.app.DB2Driver

Question

I am trying to connect to database using DB2JDBC Type 2 driver. Below is my java code

try
{
    
    String urlPrefix = "jdbc:db2:";
     String url = urlPrefix + paramString1;
       String user = paramString2;
        String password = paramString3;
        
  log.debug(context, 1010, "Connecting to : " + paramString1);
  
  Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
  localConnection = DriverManager.getConnection(url, user, password);
  localConnection.setAutoCommit(false);

I have added db2java.zip to my calss path and db2jdbc.dll is available in C:\Program Files (x86)\IBM\SQLLIB\BIN(Prior to this error I faced db2jdbc.dll not found error)

When I run my code am getting java.sql.SQLException: No suitable driver exception. What am I missing. Should I check the versions of the driver I have downloaded.

Mark Barinstein · Accepted Answer · 2021-04-20 06:33:09Z

2

DB2 JDBC Type 2 Driver is discontinued since Db2 10.1.

Resolution

Use the IBM Data Server Driver for JDBC and SQLJ instead of the DB2 JDBC Type 2 Driver. Refer to the task Upgrading database applications and subtask Upgrading Java applications that use DB2 JDBC Type 2 driver.

If you use the DB2 JDBC Type 2 Driver to compile your Java applications or routines, you will receive an error as the driver cannot be found.

answered Apr 20, 2021 at 6:33

Mark Barinstein

12.8k2 gold badges11 silver badges19 bronze badges

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

Comments

Mureinik · Accepted Answer · 2021-04-19 17:48:52Z

0

Java package names are class sensitive. The "COM" needs to be in lowercase:

Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();
// Here--------^

answered Apr 19, 2021 at 17:48

Mureinik

316k54 gold badges399 silver badges405 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLException: No suitable driver - COM.ibm.db2.jdbc.app.DB2Driver

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