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:
- WmDB or IS resetting connection
- MSSQL JDBC driver resetting connection (mssqlserver.jar)
- MSSQL DB resetting connection
- Network/Firewall resetting connection
Any ideas where to go next? Anyone else seen this (if not, I can forget option #1)?