IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Error creating JDBC connection using OCI driver mode

  • 1.  Error creating JDBC connection using OCI driver mode

    Posted Thu June 28, 2007 07:47 AM

    I am trying to create an adapter connection using OCI driver mode. I have downloaded “instantclient-basic-win32-10.2.0.3-20061115.zip” from Oracle.

    Extracted the files to a location on the disk.

    Set the PATH (environment variable) pointing above location.

    Copied ojdbc14.jar to <IS_HOME>\lib\jars.

    Environment:

    wM 6.5, JDBC Adapter 6.5, Oracle 10g RAC (10.2.0.2.0), Windows XP Professional

    Transaction Type LOCAL_TRANSACTION
    DataSource Class oracle.jdbc.pool.OracleDataSource
    serverName
    user username
    password ******
    databaseName DBNAME
    portNumber 1521
    networkProtocol tcp
    Other Properties url=jdbc:oracle:oci:@(DESCRIPTION=(failover=on)(failover_mode=(type=session)(method=basic))(address_list=(ADDRESS=(PROTOCOL=TCP)(Host=host1)(Port=1521))(ADDRESS=(PROTOCOL=TCP)(Host=host2)(Port=1521))(load_balance=on))(CONNECT_DATA=(service_name=)))

    also tried:

    Other Properties driverType=oci

    I am getting following error:

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource test.flowService:testConn.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    C:\instantclient\ocijdbc10.dll: The specified procedure could not be found

    When driverType is set as “Thin” it is working perfectly.

    I think OCI drivers are backward compatible, as i got 10.2.0.3 drivers and my DB version is 10.2.0.2.

    Thanks in advance!

    Raheel


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: Error creating JDBC connection using OCI driver mode

    Posted Wed July 11, 2007 07:54 AM

    Hi,

    I got the Oracle 10.2.0.1.0 Client Installed now. Now I am able to see the connection enabled.

    I’ve tested the connection with a custom adapter service, and it works fine. :slight_smile:

    When i tried with a select adapter template, the thread just hangs and server is down in no time.

    I see the below error in java core dump:

    An unexpected exception has been detected in native code outside the VM.
    Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x61D
    32910
    Function=xaolog+0x6294
    Library=C:\ORACLE\product\10.2.0\client_1\bin\OraClient10.Dll

    JVM:

    Java VM: Java HotSpot™ Server VM (1.4.2_07-b05 mixed mode)

    Any help will be appreciated.

    Raheel


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


Related Content