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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Jdbc adapter

    Posted 12/07/09 10:58 AM

    hi

    I use DB2 with the following configuration
    Transaction Type:LOCAL_transaction
    DataSource Class:com.ibm.db2.jcc.DB2Driver
    serverName:55.2.7.76
    user:ndeye
    password:doudou
    databaseName:bouchon
    Enable Connection Pooling:true
    portNumber:50000
    Minimum Pool Size:0
    Maximum Pool Size:10
    Pool Increment Size:1
    Block Timeout (msec):1000
    Expire Timeout (msec):1000
    Startup Retry Count:0
    Startup Backoff Timeout (sec):10
    and when I do Adapters> JDBC Adapter> Connections’ eereur have the following:

    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SI2MBouchons.Connection: connection.
    [ART.118.5063] Adapter Runtime (Connection): Unable to start connection SI2MBouchons.Connection: connection: after 1 attempt (s).
    com.ibm.db2.jcc.DB2Driver

    does anyone can help me


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


  • 2.  RE: Jdbc adapter

    Posted 12/07/09 11:12 AM

    Hi,

    Try adding appropriate DB2 jar file to IntegrationServer\lib\jars directory

    HTH!


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


  • 3.  RE: Jdbc adapter



  • 4.  RE: Jdbc adapter

    Posted 12/09/09 08:33 PM

    Hi,

    Please try adding the below in the Other Properties of the JDBC Connection Properties
    CHARSET=iso_1;HOSTNAME=MWAdapter;driverType=4;


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