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

Enabling JDBC Adapter hangs WM Server

  • 1.  Enabling JDBC Adapter hangs WM Server

    Posted Fri January 07, 2005 04:48 PM

    I am trying to configure a JDBC Adapter DB connection. I am able to save the config info successfully but when I try to enable the JDBCAdapter connection, the browser hangs, which also prevents the admin window from displaying the jdbc connections for other people logged on to the admin web page but we can still go to other windows like Error, Audit, WmDb. When this happens, I can’t shut down the server through the browser nor using webm.sh stop. I have to kill the process. Once server is restarted, I can see the JDBCAdapter connections. WmDB connection works fine for the same database using COM.ibm.db2.jdbc.app.DB2Driver driver and db URL jdbc:db2:DB2Dev.

    Config info:
    webMethods version 6.1 on Unix (also tried on Windows)
    DB2 on the mainframe
    Driver type 2
    DataSource ClassName – COM.ibm.db2.jdbc.DB2DataSource
    LOCAL_TRANSACTION (also tried NO_TRANSACTION)
    ServerName: full server name (also tried IP)
    User ******
    Password ******
    DatabaseName: DB2Dev
    Port Number: *****

    Log:
    2005-01-07 10:45:19 EST [ART.0118.5505V1] Adapter Runtime (Connection): Starting
    connection db2:testcon.
    2005-01-07 10:45:19 EST [ART.0118.5505V1] Adapter Runtime (Connection): Starting
    connection db2:testcon.
    2005-01-07 10:45:20 EST [ART.0118.5517V1] Adapter Runtime (Connection): Creating
    connection manager properties: >>>BasicData:poolable=true,minimumPoolSize=1,max
    imumPoolSize=10,poolIncrementSize=1,blockingTimeout=1000,expireTimeout=1000,sele
    ctionSize=1,poolOnCommit=true<<<.

    Any help would be appreciated.

    Thanks,
    Harsha


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