java.sql.SQL Exception: No suitable driver.

[Former Member]

Hi all...this is hari here...

I'm actually trying to configure the file-2-jdbc scenario. the backend that we are using here is Oracle...I have deployed the JDBC drivers for Oracle...But when I created the communication channel for JDBC Receiver, it shows an error saying database connection : oracle:jdbc:driver:thin:@192.168.10.1:1527:SXI.WORLD:

java.sql.SQL Exception: No suitable driver

please provide the solution for this problem.

Any help would be highly appreciated,

Regards,

Hari

[Former Member]

Hi ,

<i>database connection : oracle:jdbc:driver:thin:@192.168.10.1:1527:SXI.WORLD:</i>

try with this...

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

sekhar

[Former Member]

Hi Hari,

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

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 if you are using the OJDBC14.jar are:

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

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

Also go through these links for more information regarding the same:

http://help.sap.com/saphelp_nw2004s/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

Regards,

Abhy

[Former Member]

Hari,

<i>No suitable driver</i> Clearly states that the driver is not properly deployed in your XI server. Check the installation steps given in Configuration guide. You can get the doc in SAP market place(Need ID for that).

Also FYI the JDBC driver for Oracle is ojdbc14.jar

Regards,

Jai Shankar.

Message was edited by: Jai Shankar