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
Back to discussions
Expand all | Collapse all

WmDB: SQLServer Socket Closed

  • 1.  WmDB: SQLServer Socket Closed

    Posted Wed June 15, 2005 08:31 AM

    Hey,

    I have this nagging problem w/ IS6.1 (Linux) connecting to SQLServer 2000 via WmDB. I consistently see errors we lose connection to DB w/ error:
    “[Microsoft][SQLServer 2000 Driver for JDBC]Socket closed”

    I can’t reproduce the event at will but processing large feeds (2h+ processing time) inevitably shows some error like this. I’ve thought of this problem a bit and I guess it could be caused by:

    1. WmDB or IS resetting connection
    2. MSSQL JDBC driver resetting connection (mssqlserver.jar)
    3. MSSQL DB resetting connection
    4. Network/Firewall resetting connection

    Any ideas where to go next? Anyone else seen this (if not, I can forget option #1)?

    Cheers,
    ++Yoni


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


  • 2.  RE: WmDB: SQLServer Socket Closed

    Posted Wed June 15, 2005 09:03 AM

    My situation was not exactly like yours, but similar. I am running the SAP Business Connector (wM 4.7) on Win2K, also using SQLServer.

    I was getting “Connection reset by peer: socket write error” errors. I got rid of them by upgrading the JDBC drivers to SP3.

    HTH

    Howard


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


Related Content