Azure: Java 连接SQL Azure数据库及Connection timeout问题解决方法(二)

2014-11-24 09:12:24 · 作者: · 浏览: 1


AddKeepAlive.cmd的内容如下:

[plain]
if exist C:\keepalive.txt goto done
time /t > C:\keepalive.txt
REM Workaround for JDBC keep alive on SQL Azure

REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters /v KeepAliveTime /t REG_DWORD /d 30000 >> C:\keepalive.txt
REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters /v KeepAliveInterval /t REG_DWORD /d 1000 >> C:\keepalive.txt
REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters /v TcpMaxDataRetransmission /t REG_DWORD /d 10 >> C:\keepalive.txt
shutdown /r /t 1
:done