Skip to Content
avatar image
Former Member

JDBC receiever adapter error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2006 at 01:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • Apr 05, 2006 at 01:38 PM

    Hi Sadasivan,

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

    Regards,

    Udo

    Add comment
    10|10000 characters needed characters exceeded