DB2 Driver Error

[Former Member]

Hello all,

When i am connection DB2 Database i am getting following error.

<b>Initialization error: Loading jdbc driver 'com.ibm.db2.jdbc.app.DB2Driver' failed: java.lang.ClassNotFoundException: com.ibm.db2.jdbc.app.DB2Driver

Found in negative cache</b>

-

---

Loader Info -

---

ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]

Parent loader name: [Frame ClassLoader]

References:

service:com.sap.aii.af.cpa.svc

service:com.sap.aii.af.ms.svc

service:com.sap.aii.af.svc

service:com.sap.aii.adapter.xi.svc

library:com.sap.aii.af.lib

library:com.sap.aii.messaging.runtime

library:com.sap.xi.util.misc

common:service:iiop;service:naming;service:p4;service:ts

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore

library:ejb20

library:sapxmltoolkit

library:com.sap.util.monitor.jarm

library:com.sap.guid

library:com.sap.tc.Logging

library:com.sap.aii.af.jmsproviderlib

Resources:

D:\usr\sap\C08\DVEBMGS00\j2ee\cluster\server0\bin\services\com.sap.aii.adapter.jdbc.svc\aii_adapter_jdbc_svc.jar

Loading model: {parent,local,references}

-

---

<b>Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

COM.ibm.db2.jdbc.net.DB2Driver, 8.1 JDBC compliant

com.microsoft.jdbc.sqlserver.SQLServerDriver, 2.2 JDBC compliant</b>

i given DataBase Connection

JDBC Driver : com.ibm.db2.jdbc.app.DB2Driver

Connection : jdbc:db2://nw4sr1:50000/kotla

User Name : db2admin

Password : db2admin

Why i am unable to connect DB2 Database. What was the wrong.

[Former Member]

Hello Prabhu

I am using DB2Database version8.2. for this version do you have any DB2Database drivers. If you have plz send drivers to me.

mail id: kvenkatsap@rediffmail.com

[Former Member]

Hi Francesco Bersani,

did you install the driver on xi box?

Yes I install the driver on SAP XI Box.

Hi Prabhu

Change the name of ur JDBC Driver,

Where will i change the name.

If possible can u send me the DB2Driver files to me.

mail id : kvenkatsap@rediffmail.com

Thanks

[former_member614185]

Hi san,

The Following JAR files are required to use the DB2 JDBC Universal driver

1. Db2jcc.jar

2. Db2jcc_license_c.jar

Do you want these JAR Files.

[former_member614185]

>>>>Where will i change the name.

You need to use that JDBC Driver in your receiver or sender Adapter in XI configuration

[former_member614185]

Hi san,

You can download the Driver files from IBM site

IBM site:

https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=swg-dm-db2jdbcdriver&S_PKG=dl&S...

<b>File name: db2_v9_db2driver_for_jdbc_sqlj.zip</b>

You need to download the above mentioned file and deploy the following files in XI

1. Db2jcc.jar

2. Db2jcc_license_c.jar

Restart your J2EE engine now use that JDBC Driver in your adapter

[former_member614185]

Hi san,

I dont know the exact meaning of ur error. but i have done successfull connection to DB2.

Change the name of ur JDBC Driver,

<b>JDBC Driver: com.ibm.db2.jcc.DB2Driver</b>

[Former Member]

Hi

did you install the driver on xi box?

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b3848d77...

Best Regards,

Francesco