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 Adapter issue

    Posted Tue February 03, 2009 01:14 AM

    I am getting the following exception once in a while, can some one let me know what this exception means and I have set Minimum Pool Size: 0. I really appreciate any reply in this regard.

    2009-01-23 13:22:49 EST compass.connectors.jdbc:NCCDB An error occurred while attempting to destroy connection compass.connectors.jdbc:NCCDB(4) javax.resource.ResourceException: An error occurred while attempting to destroy connection compass.connectors.jdbc:NCCDB(4)
    at com.wm.app.b2b.server.jca.WmConnectionLogger.genResourceException(WmConnectionLogger.java:209)
    at com.wm.app.b2b.server.jca.WmConnectionPool.destroyConnection(WmConnectionPool.java:880)
    at com.wm.app.b2b.server.jca.WmConnectionPool.removeAvailableConnection(WmConnectionPool.java:689)
    at com.wm.app.b2b.server.jca.WmConnectionPool.access$400(WmConnectionPool.java:40)
    at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionTimeoutMgr.run(WmConnectionPool.java:1090)
    d702cdb0e97a11dd835bbfe1d0676238 NULL d702cdb0e97a11dd835bbfe1d0676238

    2009-01-23 13:22:49 EST [ADA.1.208] Cannot disconnect from the database. " (17002) Io exception: Connection reset" Io exception: Connection reset >>>BasicData:errorResourceBundleName=com.wm.adapter.wmjdbc.JDBCAdapterResourceBundle,errorMessageArgs=[0]
    (17002) Io exception: Connection reset,errorCode=208,pipeline=null,stack=java.sql.SQLException: Io exception: Connection reset
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
    at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:393)
    at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1036)
    at com.wm.adapter.wmjdbc.connection.JDBCConnection.destroyConnection(Unknown Source)
    at com.wm.adk.connection.WmManagedConnection.destroy(WmManagedConnection.java:275)
    at com.wm.app.b2b.server.jca.WmConnectionPool.destroyConnection(WmConnectionPool.java:872)
    at com.wm.app.b2b.server.jca.WmConnectionPool.removeAvailableConnection(WmConnectionPool.java:689)
    at com.wm.app.b2b.server.jca.WmConnectionPool.access$400(WmConnectionPool.java:40)
    at com.wm.app.b2b.server.jca.WmConnectionPool$ConnectionTimeoutMgr.run(WmConnectionPool.java:1090)
    ,exceptionClass=java.sql.SQLException,reason=Io exception: Connection reset,serviceCallStack=null,date=Fri Jan 23 13:22:49 EST 2009,message=Cannot disconnect from the database. "
    (17002) Io exception: Connection reset"<<<
    d700d1e0e97a11dd8359bfe1d0676238 NULL d700d1e0e97a11dd8359bfe1d0676238


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


  • 2.  RE: JDBC Adapter issue

    Posted Wed February 04, 2009 11:26 PM

    Nancy,

    Is this issue with Oracle? If so you might want to check this link

    [url]http://www.dba-oracle.com/t_connect_time_idle_expire_timeout.htm[/url]

    I think you will have to set this in other properties field of the JDBC connection.


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


Related Content