Sender JDBC Adapter - Connectivity Problems

[Former Member]

I installed JDBC Driver for Oracle 9 ojdbc14.jar on the J2EE Engine as per the instructions in the How To Guide. I updated the tnsnames.ora on the server appropriately. Also I could connect to Oracle database from the server using sqlplus. I configured my Sender Adapter with the following parameters:

JDBC Driver:oracle.jdbc.driver.OracleDriver

Connection:jdbc:oracle:thin:@ORACLEDEV

I get the following error:

Sender Adapter v2108 for Party '', Service 'ORACLEDEV_BS':

Configured at 2006-03-09 17:24:42 EST

History:

- 2006-03-09 17:24:42 EST: Retry interval started. Length: 60.000 s

- 2006-03-09 17:24:42 EST: Error: Accessing database connection 'jdbc:oracle:thin:@ORACLEDEV' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@ORACLEDEV': SQLException: Io exception: SO Exception was generated

- 2006-03-09 17:24:42 EST: Processing started

Help is highly appreciated.

Mike

[bhavesh_kantilal]

Hi Michael,

I think the connection parameters should be ,

jdbc:oracle:thin@:Ipaddress:port:databasename

Regards,

Bhavesh

[Former Member]

Hi,

My bad, Bhavesh is correct

here is the correct format

jdbc:oracle:thin:@<hostname>:<port>:<sid>,<username>,<password>

http://www.oracle.com/technology/sample_code/tech/java/codesnippet/j2ee/jdbc/JDBC_in_J2EE.html

cheers,

naveen

[bhavesh_kantilal]

Hi Naveen,

I am not sure if I mine is exactly correct either. I remember giving the user id and password when I was configuring the JDBC adapter to connect to the Oracle Databse.

Have been searching for the document in which I made the corresponding entrie but to no avail.

Peter, do try out all the options and let us know what works.

Regards,

Bhavesh

[sam_raju]

Hi Bhavesh/Naveen,

You are correct.

Mike, the correct settings are as follows

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@<oracle server>:<port>:XDB<sid>

Username: <oraccle username>

Password: <oracle password

Rgds,

Sam raju

[Former Member]

Hi Bhavesh,

The OCi connection string i gave is the one we are currently using in production, so i know its working.

for the connection string with "thin", i looked up in oracle site. the link i provided has more information.

cheers,

naveen

[bhavesh_kantilal]

Hi Naveen,

Well then as Peter has intalled ojdbc14.jar looks like my answer does have to be the corrct one . My memory is not bad uh??

Peter, we are still waiting for the final result.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

i was digging through the oracle docs for drivers and according to oracle if you have installed ojdbc14.jar the connection string is

url="jdbc:oracle:thin:@server:port:sid"

so i guess Peter has to appraise us with his findings.

Cheers,

Naveen

[Former Member]

Thank you all. This format jdbc:oracle:thin:@server:port:sid worked fine.

Mike.

[Former Member]

I have to give points to two people(Naveen and SAM).

[Former Member]

Hi,

try with the following parameter format

driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:oci8:userid/pwd@server

or

jdbc:oracle:thin:userid/pwd@ORACLEDEV

Cheers,

naveen

Message was edited by: Naveen Pandrangi