JDBC receiever adapter error

[Former Member]

Hello,

I'm trying out a proxy-JDBC scenario. I'm getting a error in my receiver JDBC adapter. i got the foll. error in RWB.

java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

Addtional information: JDBC driver 'oracle.jdbc.driver.OracleDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant

I'm trying to connect to an Oracle 8i database.

My connection string is: jdbc:oracle:thin:@IPadress:port:databasename.

I have installed ojdbc14.zip driver on my XI server.

Regrads,

Sekar

[Former Member · Accepted solution]

Sadasivan,

The oracle document should give more info on the error, see if the info below helps troubleshooting your issue.

databasename - must be the SID of the database; most often ORCL !!

from oracle:

TNS-12505 TNS:listener could not resolve SID given in connect descriptor

Cause: The SID in CONNECT_DATA was not found in the listener's tables.

Action: Check to make sure that the SID specified is correct. The SIDs that are currently registered with the listener can be obtained by typing "LSNRCTL SERVICES listener_name". These SIDs correspond to SID_NAMEs in TNSNAMES.ORA, or DB_NAMES in the INIT.ORA file.

Regards

Saravana

[Former Member · Accepted solution]

Hi Saravana,

Should i try giving the SID instead of databasename? I tried ORCL, that didn't work.

Udo, i have confirmed that my username and Password are correct.

[Former Member · Accepted solution]

Sadasivan,

Yes it should be your service name i beleive. Does your SID have a dot notation ? chk this link, if so and see if it helps.

https://service.breezecentral.com/support/coldfusion/ts/documents/oracle_thin_ds_fails.htm

Basically only the prefix(string before your dot) of your service name should be used

Regards

Saravana

Message was edited by: Saravana Kumar Kuppusamy

[bhavesh_kantilal · Accepted solution]

Hi Sekar,

I think it is the SID that is used to access the Oracle Database.

Regards,

bhavesh

[Former Member · Accepted solution]

Hi,

Following is the connection string that we are currently using for connecting to Oracle 8i.

This setting has been working for us. give it a try.

connection string : jdbc:oracle:oci8:userid/password@server

Cheers,

Naveen

[Former Member · Accepted solution]

Hi,

Note that this connection string is only if you use the Oracle OCI driver. The OCI driver requires a shared library or DLL on the server.

The thin driver for Oracle is more commonly used as it doesn't require any additional libraries. The connection string is as already listed above:

jdbc.oracle.thin:@server:port:SID

There is no need to put the user and password into the connection string in the adapter config, putting it into the user and password fields works just fine.

Regards

Christine

[Former Member · Accepted solution]

Hi,

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 christine is correct !!

Cheers,

Naveen

[udo_martens]

Hi Sadasivan,

r u shure, that ur user and ur password put in the communication channel r correct?

Regards,

Udo