Problem with JDBC

[Former Member]

Hello All,

I am working with JMS to JDBC Interface. When I am trying to insert data to database Receiver JDBC channel is throwing following error. Can any one suggest me how to resolve this problem.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@myserver:1521:ORCL': SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

Thanks&Regards,

VenkatK

Edited by: venkat k on Jul 23, 2008 3:42 PM

[MichalKrawczyk · Accepted solution]

hi,

did you deploy oracle's jdbc driver on XI ?

Regards,

michal

[Former Member · Accepted solution]

Hi,

I didn't deploy oracle drivers. Can you guide me what is the procedure of deploying oracle drivers on PI Box.

Thanks&Regards

VenkatK

[Former Member]

Hi Venkat,

Check this :

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Thanks,

Mahi

[Former Member]

Hi Venkat,

Have u deployed required JDBC Driver for u r JDBC Adapter given by vendor.

If not please do it. Kindly while doing see if u r jdbc drivers are compatible with JDK1.4 since j2ee stack of PI is of JDK 1.4.

U can deploy drivers using SDA from Visual Admin of pi.

If u have done this check the copatibility of u r driver again

rwd points if useful

rgds

srin