JDBC Adapter

[Former Member]

Hi Experts,

i facing the problem in file to JDBC scenario.

i am using Oracle database.

JDBC Driver : jdbc.oracle.driver.OracleDriver

Connection: jdbc:oracle:thin:@15.78.88.34:1521:CDWDEVL2.BOI.HP.COM

and Passing User id and password.

Records are not inserted into the system.

when i check the Communication channel monitoring i am getting this error.

"Error during database connection to the database URL 'jdbc:oracle:thin:@15.78.88.34:1521:CDWDEVL2.BOI.HP.COM' using the JDBC driver 'oracle.jdbc.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@15.78.88.34:1521:CDWDEVL2.BOI.HP.COM': SAPClassNotFoundException: oracle.jdbc.OracleDriver'"

In SXMB_moni it is showing successfull.

can any one help.

Thanks for the help in advance.

Regards,

Srini

[Former Member]

Hi All,

Thanks for your help. My issue is solved.

Regards,

Srini

[Former Member]

Hi,

What is the system ID of the oracle. you have to use the system ID , not the service Name.

Check the URL. This explains how you should use JDBC URL's

http://www.devx.com/tips/Tip/28818

With regards

K.Varadharajan

[prabhu_s2]

check to install oracle driver, just check this link,

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

The details that have to be entered while adapter configuration,

URL : jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)>

<b>Driver: <u>oracle.jdbc.driver.OracleDriver</u></b>

[Former Member]

Srini,

check your if these correct values

JDBC Driver : jdbc.oracle.driver.OracleDriver

Connection: jdbc:oracle:thin:@15.78.88.34:1521:CDWDEVL2.BOI.HP.COM

and Passing User id and password.

and also check whether Database is up at the otherside. and no firewalls

[Former Member]

Hi,

Check the JDBC Adapter connection parameters. And check the jdbc driver installation also. Have a look into this-

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Also see PI FAQ note and the first question in the note 831162 also mentions that the driver needs to be insalled.

---Satish

[Former Member]

Have you installed the driver into the XI system ?

SXMB_MONI shows successful processing in integration engine, however the message has failed in adapter engine...

use the below given how-to document to load the jdbc drivers ..

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Thanks,

Renjith

Message was edited by:

Renjith Andrews