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

Issue JDBC Adapter 6.5 Connection to AS400 DB2 database

  • 1.  Issue JDBC Adapter 6.5 Connection to AS400 DB2 database

    Posted Tue November 10, 2009 06:00 PM

    All:

    We are bringing up a new instance of IS 7.2 (we are upgrading from 6.1.5). I am using the JDBC adapter (v6.5) to access DB2 on an AS400 (V5R3). When I try to enable my connection I get the following error:

    [ART.118.5063] Adapter Runtime (Connection): Unable to start connection BjJDBC.adapters:DB2AS400NotificationAdapter: after 1 attempt(s). For input string: “none”

    Here are my connection properties:

    Transaction Type: NO_TRANSACTION
    DataSource Class: com.ibm.as400.access.AS400JDBCDataSource
    serverName: BJSERP02.usa.bjs
    Other Properties: access=all;naming=system;transactionisolation=none;translatebinary=true;libraries=bjsdtadev,bjscomdev,bjswbmdev;errors=full
    Enable Connection Pooling: true
    Minimum Pool Size: 0
    Maximum Pool Size: 100
    Pool Increment Size :1
    Block Timeout (msec): 3000
    Expire Timeout (msec): 10000
    Startup Retry Count:3
    Startup Backoff Timeout (sec): 10

    I am using the jt400.jar version 6.6. I have also tried the jt400.jar that we have running in production, but I get the same error.

    Any help would be appreciated.


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


  • 2.  RE: Issue JDBC Adapter 6.5 Connection to AS400 DB2 database

    Posted Thu December 17, 2009 02:28 PM

    Where is the jt400.jar located?

    It should be in the directory
    /IntegrationServer/packages/WmJDBCAdapter/code/jars/static


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