JDBC connection URL

[Former Member]

Hi,

Scenario: RFC to JBDC (oracle 9.0127)

The oracle drivers have been loaded and deployed correctly according to the basis team (drivers - com.sap.jdbc.oracle.OracleDriver). I am using the following URL:

jdbc:oracle://ip address:1521/database name

I have managed to successfully connect to the database using other software using the IP address, port, username and password.

Does anyone have any ideas, I am getting the following error:

Error during database connection to the database URL 'jdbc:oracle://ip address:1521/database name' using the JDBC driver 'com.sap.jdbc.oracle.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle://ip address:1521/database name': SAPClassNotFoundException: com.sap.jdbc.oracle.OracleDriver'

Thanks,

Leanne

[Former Member · Accepted solution]

correct your Driver URL.

jdbc:oracle:thin:@<hostname>:<port>:<SID>

// @machineName:port:SID

Thanks

Farooq.

[Former Member]

Hi

I feel your driver is not installed properly.Try redoing it following all the steps.

Thanks

[Former Member]

Hi,

We have downloaded the jar files again and reloaded the drivers with the guide, we still have the same error.

Any ideas on things we can check?

Thanks,

Leanne

[Former Member]

Hi,

Thanks we restarted the XI server, solving the problem. I now have another problem:

Error during database connection to the database URL 'jdbc:sap:oracle:111.11.111.11:1111;xxx' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection to URL 'jdbc:sap:oracle: 111.11.111.11:1111;xxx ''

Any ideas?

Thanks,

Leanne

[Former Member]

Hi,

Use this for Connection in Configuration:

jdbc:oracle:thin:@hostname:port:SID

Regards,

Balaji.M

[Former Member]

try with this

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@ip address:1521:dbname

regards

pratibha

[Former Member]

Hi,

I have tried :

jdbc:oracle:thin:@111.11.111.11:1521:XXX

oracle.jdbc.driver.OracleDriver

no joy - I get the same message.

Regards,

Leanne

[Former Member]

Hi,

Which driver did you install?

try ojdbc14.jar with

Driver - oracle.jdbc.driver.OracleDriver

Connection String - jdbc:oracle:thin:@111.11.111.11:1521:XXX

Regards,

Balaji.M

[Former Member]

Hi,

We have loaded the suggested drivers and used the test tool. We still get the same error message. What/Where can we/basis look and double check?

We have loaded the drivers on the XI side, do we need to do anything anywhere else i.e. the third party side?

Thanks,

Leanne

[Former Member]

NO..you just have to upload the drivers in XI and it enough..thre is no more setting required in database in order to communicate with XI...becuasue this is the task of JDBC drivers.

So once u loaded all the specific drivers that is enough.

Thanks

Farooq.

[prateek]

Nothing at the third party side.

At XI give it a try again. Download ojdbc14.jar from Oracle site again.

Then follow the How to guide

Regards,

Prateek

[former_member614185]

ask ua basis people whether they have deployed correct ORACLE DRIVER FILE or Not?

try to deploy the correct jar files and the restart ur J2EE engine.

[Former Member]

In Database Connection use the JDBC Driver-- oracle.jdbc.driver.OracleDriver

[Former Member]

To download drivers for Oracle DB,

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

If you want to install Oracle 9i,. OJDBC14.jar should be used. Just check this note 831162.

Also, check this PDF to install Drivers in XI,

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

Regards,

Abhishek Agrahari

[Former Member]

Hi

Communication channel not able to connect using DB Url .

Check these -

1) Verify the DB URL by connecting database using Command line SQL plus or any SQL editor.

2) Check wether the Drivers deployed are supported for the Oracle Db version and JDK version on XI server and OS type ( Solaris )

Check this URL for details on JDBC drivers support list -

also check

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

<b>

Questions are welcome here!!

Also mark helpful answers</b>

Thanks,

Abhishek Agrahari