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
Expand all | Collapse all

webMethods JDBC Adapter Issue

  • 1.  webMethods JDBC Adapter Issue

    Posted Fri December 02, 2016 01:53 AM

    Facing below issue while trying to enable the JBDC adapter connection -

    Error encountered
    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource jdbc:databaseConnection.
    [ART.118.5063] Adapter Runtime (Connection): Unable to start connection jdbc:databaseConnection: after 1 attempt(s).
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
    IO Error: Got minus one from a read call

    Can someone please help on this ?


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


  • 2.  RE: webMethods JDBC Adapter Issue

    Posted Fri December 02, 2016 03:51 AM

    Kindly provide the details below:
    1> JDBC Adapter version with fix levels
    2> DB version with JDBC driver details
    3> Connection params from JDBC adapter connection (screen shot)
    4> Is issue permanent or intermittent?

    IMO, The error message “Io error:
    Got
    minus
    one
    from a read
    call” is returned by the database communication layer and most possible root cause is an unexpected communication issue between the client database driver and the back-end (Oracle database) system, due the TCP socket is being closed.

    The problem can be located also at the database side, the Oracle administrators can check if there is any kind of error recorded at database side when the connection issue at JDBC Adapter side is detected. The error can be due to any resource issue at database side like maximum number of connections, processes, an Oracle listener (TNS) issue, etc.

    To isolate the issue from wM side you have the latest fix levels installed on your JDBC version and have the correct JDBC driver installed with it.


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