beykery commented on 21 Dec 2017
|
这个错误我也遇到了，我现在不得已使用1.1.5版本，这个版本没这个问题。 |
ky2c commented on 22 Dec 2017
|
配置一下validationQueryTimeout参数就可以了。 |
|
我也遇到了， 坑了好久。 设置validationQueryTimeout参数大于-1就好了 |
wenshao added this to the 1.1.7 milestone on 24 Dec 2017
wenshao added the Bug label on 24 Dec 2017
|
我加了validationQueryTimeout也不起作用，spring boot 1.5.9 会循环不停的报错： ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://localhost:1433;integratedSecurity=true;databaseName=checkinginMS, errorCode 0, state null |
https://github.com/alibaba/druid/releases/tag/1.1.8
问题已修复，请使用新版本
xhhwc commented on 21 Dec 2017
1.1.6版本Druid连接MSSQL Server 2008 R2报错：com.microsoft.sqlserver.jdbc.SQLServerException: The query timeout value -1 is not valid.经测试1.1.5版本的Druid无此问题；而1.1.6版本Druid连接MySQL数据库也没有问题。以下是完整的错误日志：
com.microsoft.sqlserver.jdbc.SQLServerException: The query timeout value -1 is not valid.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:227)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1112)
at com.alibaba.druid.pool.vendor.MSSQLValidConnectionChecker.isValidConnection(MSSQLValidConnectionChecker.java:47)
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1304)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1585)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:854)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1221)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1217)