JDBC connection problem , SAPClassNotFoundException: oracle.jdbc.driver.Ora

[Former Member]

Hi

I have a connection problem with JDBC from the Sender Side Below is the configuration of Communication Channel for connection and processing tab.

..........................................

Connection tab screen:

JDBC Driver: oracle.jdbc.driver.OracleDriver

connection: jdbc:oracle:thin:ichain/chain@172.20.1.155:1521:srs231

..........................................

Processing tab screen:

Quality of Service: Exactly Once

Poll Interval(secs): 60

Query SQL Statement: SELECT * from ici_loyalty_trans

Document Name: MT_SRS_Loyalty

Update SQL Statement: <TEST>

the below message is displayed in the monitoring of Communication Chanels and it is :

..........................................

'jdbc:oracle:thin:ichain/ichain@172.20.1.155:1521:srs231' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:ichain/ichain@172.20.1.155:1521:srs231': SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver'

What possibly is the error?

Thanks

Antonis

Edited by: Konstantinidis Antonis on Jun 24, 2008 5:32 PM

[GabrielSagaya · Accepted solution]

The connection string should be in the format,

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

In your case,

jdbc:oracle:thin:@172.20.1.155:1521:srs231

i think ichain/chain is username and password to be supplied in separate parameters.

SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

Did you install the driver OJDBC14.jar to access the Oracle DB in your XI server. It is not able to recognise the Oracle Driver.

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...

[Former Member · Accepted solution]

Hi,

Its is very much clear from the error that the Oracle JDBC Driver(ojdbc.jar) is not installed in your XI Server.

Please install that and you will get rid of this error.

However there will be another error once this is resolved because of the incorrect connection string you have given, The connection string should be of the format mentioned below

jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name>

There is seperate parameters userId/pwd in JDBC Receiver channel where you need to specify the userId/pwd and not in the connection string.

Thanks

Amit

Reward points if suggestion helps

[Former Member]

check the driver parameters.

its may due to some configuration data

[Former Member]

Hi,

SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver' --> This error clearly implies that the OracleDriver has not been installed on your XI server.

Ask you admin team to do the needful and install the Oracle Drivers.

Thanks

Vikranth

[Former Member]

Hi,

Check this URL for details on JDBC drivers support list -

Thanks

Vikranth

[Former Member]

Hi,

ClassNotFoundException is because of Corrupted jar files. install correct jar files.

for oracle.jdbc.driver.OracleDriver which requires classes12.jar install the same and try you wont get exception.

Thanks,

RamuV