File To JDBC Scenario

[Former Member]

I got the following error when I did this scenario....

History:

- 2008-09-16 17:55:13 EDT: Error: Accessing database connection 'jdbc:oracle:thin:@RAM:1521:ORCL10G' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@RAM:1521:ORCL10G': SAPClassNotFoundException: com.sap.portals.jdbc.oracle.OracleDriver: SAPClassNotFoundException: com.sap.portals.jdbc.oracle.OracleDriver

I am really confused as to what to fill in the

JDBC Driver com.sap.portals.jdbc.oracle.OracleDriver

Connection jdbc:oracle:thin:@RAM:1521:ORCL10G

In SXMB_MONI, i can see a green flag....

In RWB --- Adapter Monitoring --- CC_Sender -

---

OK

Adapter Monitoring --- CC_JDBC_Receiver ....Failing...

Can someone help me with this...

I have sap GUI in my system.....

What else I can do to resolve this problem...

Any sample drivers and connection parameters I can try with...

Regards

[deepak_shah]

Hi

For Jdbc driver use "oracle.jdbc.driver.OracleDriver"

& give connection string in case of Oracle database as" jdbc:oracle:thin:@hostname:port:DB".

Also chek if the USer you are using has necessary access to database.

Regards,

Deepak.

[Former Member]

Hi,

Related driver (OJDBC14.jar) files needs to be installed.Take the help from Basis team.

find the below links...

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/jdbc%2bconnection%2bsetup

Thanks & Regards,

Naresh

[Former Member]

Hi Vinshu,

there migth problem with the JDBC drivers configuraton in the Communicaton Channel of JDBC try and chk that the user and pwd given are correct in SMXB_MONI only the sender adapter is fine due to that it appears green

chk this link it will help

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a04cd6f9-9eb0-2a10-07b8-a0fc6e88...

Regards

Sampath

[Former Member]

Hi

JDBC Driver com.sap.portals.jdbc.oracle.OracleDriver
Connection jdbc:oracle:thin:@RAM:1521:ORCL10G

try out this

user name:

password: ####

driver Name: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@hostname:1521:SID

(System ID of oreacle server).

Regard's

Chetan Ahuja

[dharamveer_gaur2]

Oracle data base connectivity you have to use

this driver oracle.jdbc.driver.OracleDriver.

and if this driver is not installed at XI then talk to your basis people

Edited by: Dharamveer Gaur on Sep 17, 2008 6:02 AM

[VijayKonam]

Your basis must install JDBC Oracle drivers in your XI system. Them this would work. Search the forum for installing JDBC drivers..

VJ