Skip to Content
avatar image
Former Member

Re:JDBC Communication Channel

Hi,

I am getting the following error in Communication channel of JDBC:

Error during database connection to the database URL 'jdbc:oracle:thin:@host:port:SID' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SQLException: Io exception: The Network Adapter could not establish the connection'

Connection Parameters in CC are as :

Connection: 'jdbc:oracle:thin:@host:port:SID'

Drivers: 'oracle.jdbc.driver.OracleDriver'

If I change Connection Parameters in CC as:

Connection: 'jdbc.oracle.thin.@host:port:SID'

Drivers: 'oracle.jdbc.driver.OracleDriver'

Then I recieve the following error:

Error during database connection to the database URL 'jdbc.oracle.thin.@KFTDERSHAPP14:1521:CTAQ' using the JDBC driver 'oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection:'

Oracle system is on 10G

PI 7.1 Basis team mentioned ojdbc14.jar are already installed on PI Server. Can any one light on this issue?

Thanks

Santosh.

Thanks

Santosh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Aug 10, 2009 at 01:58 PM

    Hi Santosh,

    Check similar discussions here:

    installing-jdbc-oracle-pi-7

    JDBC connection problem , SAPClassNotFoundException: oracle.jdbc.driver.Ora

    and have a look at this guide and cross check the steps you have performed.

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d88f

    Regards,

    Ravi kanth Talagana

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2009 at 02:08 PM

    HI,

    Even I struggled a lot to make it work but at last tried below and it worked for me.

    Please refer below:

    Connection url: Format is --> jdbc:oracle:thin:@hostname:port:SID

    For e.g. -

    jdbc: oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ntbomsap13)(PORT = 1527)) ) (CONNECT_DATA = (SID = XI3) (SERVER = DEDICATED) ) )

    Here in this connection url I have replaced: @hostname: port: SID with the TNSNAMES file content.

    Ask Your Basis for TNSNAMES File .

    I hope it will solve your Query.

    Regards,

    Anurag Garg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi.....

      This is problem with Database system....

      Try to log in to the system....

      might be problem with port or host names.....

      Sreedhar Goud.

  • avatar image
    Former Member
    Aug 21, 2009 at 11:08 AM

    Hi Santosh ,

    Try giving IP address in the URL instead of Hostname . Problem does nt seem to be the drivers.

    Thanks ,

    Kavitha .G

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2014 at 02:48 PM

    It seems you're having firewall problems between the systems, try to check with basis team or network administrator.

    Add comment
    10|10000 characters needed characters exceeded