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.


#TechXchangePresenter
 View Only

  • 1.  JDBC Service Open Hangs

    Posted Fri January 26, 2007 02:24 AM

    I try to Open an existing JDBC Service (Select, Update) in Developer and it takes an excessively long time to return (20 minutes) or it just hangs the Developer session. The Oracle database is up and the JDBC connection works. If I kill some of my sessions from the IS Admin, then Open JDBC Service returns some of the time. The IS is v6.1. Any idea what’s causing this problem?

    Thanks,
    Jay


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


  • 2.  RE: JDBC Service Open Hangs

    Posted Fri January 26, 2007 03:25 PM

    What are the settings of your JDBC connection?


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


  • 3.  RE: JDBC Service Open Hangs

    Posted Fri January 26, 2007 11:06 PM

    Our resident wM infrastructure support determined it was caused by database latency and the following JDBC adapter connection property change has fixed it.

    Other Properties driverType=thin;oracle.jdbc.TcpNoDelay=true;restrictGetTables=true;TCP.NODELAY=yes


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


Related Content