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

Available drivers :

oracle.jdbc.driver.OracleDriver, jdbc 1.0 compliant

please provide the solution for this problem.

Any help would be highly appreciated,

Regards,

Hari

[bhavesh_kantilal]

Hi,

The parameters in the JDBC adapter should be mentioned as follows.

<b>Connection :</b>

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

jdbc:oracle:thin:@192.168.10.1:1527:SXI.WORLD

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

In your case, you have entered the Connection as <i>oracle:jdbc:driver:thin:@192.168.10.1:1527:SXI.WORLD:</i>which is the cause of the problem.

Regards,

Bhavesh

[Former Member]

Hi Hari,

Check these threads..

/thread/19665 [original link is broken]

cheers.

Prashanth