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
  • 1.  JDBC adapters

    Posted Sun July 31, 2011 09:42 PM

    Hi,
    Quite often , we notice the below error.
    Seems like the connection is lost. And the connection will be enabled in the next second. Because of this we have several transaction failures.

    Please advice.

    2011-07-31 09:13:01 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.204] Cannot connect to the database with Dat
    aSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.
    Io exception: The Network Adapter could not establish the connection
    2011-07-31 09:13:01 EDT [SCC.0126.0119E] An error occurred while attempting to create connections for SelJdbc:dbConnectCDW
    2011-07-31 09:13:01 EDT [SCC.0126.0106E] An error occurred while attempting to retrieve a connection from SelJdbc:dbConnectCDW
    2011-07-31 09:13:01 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.118.5053] Adapter Runtime (Connection): Unable
    to get a connection to resource SelJdbc:dbConnectCDW.
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.
    Io exception: The Network Adapter could not establish the connection
    2011-07-31 09:13:01 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4012] Adapter Runtime (Adapter Service): U
    nable to run adapter service. Error occurred when connecting to resource SelJdbc:dbConnectCDW.
    [ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource SelJdbc:dbConnectCDW.
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”.
    Io exception: The Network Adapter could not establish the connection

    Connection Settings:

    Connection Management PropertiesEnable Connection PoolingtrueMinimum Pool Size0Maximum Pool Size20Pool Increment Size1Block Timeout (msec)1000Expire Timeout (msec)1000Startup Retry Count0Startup Backoff Timeout (sec)10


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


  • 2.  RE: JDBC adapters

    Posted Mon August 01, 2011 03:08 PM

    Seems your dropping a connection to the oracle database servers that your jdbc talks to. Are you on a RAC config for the database or a stand alone server?


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