将数据库dbcp连接池改为c3p0连接池(草稿,别点)-白红宇

将数据库dbcp连接池改为c3p0连接池(草稿,别点)

阅读量：6692 次

发布时间：2019-06-25

本文共 50113 字，大约阅读时间需要 167 分钟。

D:\Develop\apache-tomcat-7.0.52\bin\catalina.bat run

[2017-12-26 02:31:29,174] Artifact pers:war exploded: Server is not connected. Deploy is not available.

Using CATALINA_BASE: "C:\Users\Administrator\.IntelliJIdea2017.1\system\tomcat\Unnamed_pers_2"

Using CATALINA_HOME: "D:\Develop\apache-tomcat-7.0.52"

Using CATALINA_TMPDIR: "D:\Develop\apache-tomcat-7.0.52\temp"

Using JRE_HOME: "D:\Develop\java\jdk1.8.0_112"

Using CLASSPATH: "D:\Develop\apache-tomcat-7.0.52\bin\bootstrap.jar;D:\Develop\apache-tomcat-7.0.52\bin\tomcat-juli.jar"

十二月 26, 2017 2:31:30 下午 org.apache.catalina.core.AprLifecycleListener init

信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\Develop\java\jdk1.8.0_112\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;D:\Develop\apache-maven-3.5.0\bin;D:\Develop\oracle11g\product\11.2.0\dbhome_1\bin;D:\Develop\java\jdk1.8.0_112\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Develop\mysql5.5\bin;D:\Develop\apache-cxf-3.2.1\bin;D:\Develop\TortoiseSVN\bin;.

十二月 26, 2017 2:31:30 下午 org.apache.coyote.AbstractProtocol init

信息: Initializing ProtocolHandler ["http-bio-8080"]

十二月 26, 2017 2:31:30 下午 org.apache.coyote.AbstractProtocol init

信息: Initializing ProtocolHandler ["ajp-bio-8009"]

十二月 26, 2017 2:31:30 下午 org.apache.catalina.startup.Catalina load

信息: Initialization processed in 521 ms

十二月 26, 2017 2:31:30 下午 org.apache.catalina.core.StandardService startInternal

信息: Starting service Catalina

十二月 26, 2017 2:31:30 下午 org.apache.catalina.core.StandardEngine startInternal

信息: Starting Servlet Engine: Apache Tomcat/7.0.52

十二月 26, 2017 2:31:30 下午 org.apache.coyote.AbstractProtocol start

信息: Starting ProtocolHandler ["http-bio-8080"]

十二月 26, 2017 2:31:30 下午 org.apache.coyote.AbstractProtocol start

信息: Starting ProtocolHandler ["ajp-bio-8009"]

十二月 26, 2017 2:31:30 下午 org.apache.catalina.startup.Catalina start

信息: Server startup in 88 ms

Connected to server

[2017-12-26 02:31:30,863] Artifact pers:war exploded: Artifact is being deployed, please wait...

十二月 26, 2017 2:31:31 下午 org.apache.catalina.loader.WebappClassLoader validateJarFile

信息: validateJarFile(E:\IDEA\pers\target\pers\WEB-INF\lib\javaee-api-7.0.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class

十二月 26, 2017 2:31:31 下午 org.apache.catalina.deploy.WebXml setVersion

警告: Unknown version string [3.1]. Default version will be used.

14:31:34,772 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]

14:31:34,772 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]

14:31:34,773 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/E:/IDEA/pers/target/pers/WEB-INF/classes/logback.xml]

14:31:34,848 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]

14:31:34,853 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT]

14:31:34,862 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property

14:31:34,905 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to INFO

14:31:34,905 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [STDOUT] to Logger[ROOT]

14:31:34,906 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.

14:31:34,907 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@2cba1055 - Registering current configuration as safe fallback point

14:31:34,740 |-INFO in ch.qos.logback.classic.servlet.LogbackServletContainerInitializer@688253b1 - Adding an instance of class ch.qos.logback.classic.servlet.LogbackServletContextListener to the current web-app

log4j:WARN No appenders could be found for logger (org.springframework.web.context.support.StandardServletEnvironment).

log4j:WARN Please initialize the log4j system properly.

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

[2017-12-26 02:31:37,475] Artifact pers:war exploded: Artifact is deployed successfully

[2017-12-26 02:31:37,475] Artifact pers:war exploded: Deploy took 6,612 milliseconds

十二月 26, 2017 2:31:40 下午 org.apache.catalina.startup.HostConfig deployDirectory

信息: Deploying web application directory D:\Develop\apache-tomcat-7.0.52\webapps\manager

14:31:49.241 [http-bio-8080-exec-7] INFO c.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited

14:31:50.192 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:50.229 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:50.761 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:51.291 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:51.827 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:52.362 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:52.904 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:53.437 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:53.976 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:54.514 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:55.059 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:55.585 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:56.126 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:56.671 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:57.211 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:57.758 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:58.296 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

D:\Develop\apache-tomcat-7.0.52\bin\catalina.bat stop

Using CATALINA_BASE: "C:\Users\Administrator\.IntelliJIdea2017.1\system\tomcat\Unnamed_pers_2"

Using CATALINA_HOME: "D:\Develop\apache-tomcat-7.0.52"

Using CATALINA_TMPDIR: "D:\Develop\apache-tomcat-7.0.52\temp"

Using JRE_HOME: "D:\Develop\java\jdk1.8.0_112"

Using CLASSPATH: "D:\Develop\apache-tomcat-7.0.52\bin\bootstrap.jar;D:\Develop\apache-tomcat-7.0.52\bin\tomcat-juli.jar"

14:31:58.822 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

十二月 26, 2017 2:31:59 下午 org.apache.catalina.core.StandardServer await

信息: A valid shutdown command was received via the shutdown port. Stopping the Server instance.

十二月 26, 2017 2:31:59 下午 org.apache.coyote.AbstractProtocol pause

信息: Pausing ProtocolHandler ["http-bio-8080"]

十二月 26, 2017 2:31:59 下午 org.apache.coyote.AbstractProtocol pause

信息: Pausing ProtocolHandler ["ajp-bio-8009"]

十二月 26, 2017 2:31:59 下午 org.apache.catalina.core.StandardService stopInternal

信息: Stopping service Catalina

十二月 26, 2017 2:31:59 下午 org.apache.catalina.core.StandardWrapper unload

信息: Waiting for 1 instance(s) to be deallocated for Servlet [SpringMVC]

14:31:59.356 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:31:59.885 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

十二月 26, 2017 2:32:00 下午 org.apache.catalina.core.StandardWrapper unload

信息: Waiting for 1 instance(s) to be deallocated for Servlet [SpringMVC]

14:32:00.416 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

14:32:00.946 [Druid-ConnectionPool-Create-1649034518] ERROR c.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:sqlserver://172.16.5.133:1433;DatabaseName=ppms, errorCode 0, state null

com.microsoft.sqlserver.jdbc.SQLServerException: 查询超时值 -1 无效。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.setQueryTimeout(SQLServerStatement.java:1061)

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$CreateConnectionThread.run(DruidDataSource.java:2450)

十二月 26, 2017 2:32:01 下午 org.apache.catalina.core.StandardWrapper unload

信息: Waiting for 1 instance(s) to be deallocated for Servlet [SpringMVC]

14:32:01.274 [localhost-startStop-2] INFO c.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed

14:32:01,292 |-INFO in ch.qos.logback.classic.servlet.LogbackServletContextListener@29f34d0d - About to stop ch.qos.logback.classic.LoggerContext [default]

十二月 26, 2017 2:32:01 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

严重: The web application [/pers] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

十二月 26, 2017 2:32:01 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

严重: The web application [/pers] registered the JDBC driver [com.microsoft.sqlserver.jdbc.SQLServerDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

十二月 26, 2017 2:32:01 下午 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

严重: The web application [/pers] is still processing a request that has yet to finish. This is very likely to create a memory leak. You can control the time allowed for requests to finish by using the unloadDelay attribute of the standard Context implementation.

十二月 26, 2017 2:32:01 下午 org.apache.catalina.loader.WebappClassLoader loadClass

信息: Illegal access: this web application instance has been stopped already. Could not load com.alibaba.druid.pool.DruidDataSourceCustomizer. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.

java.lang.IllegalStateException

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1610)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:348)

at com.sun.beans.finder.ClassFinder.findClass(ClassFinder.java:103)

at java.beans.Introspector.findCustomizerClass(Introspector.java:1301)

at java.beans.Introspector.getTargetBeanDescriptor(Introspector.java:1295)

at java.beans.Introspector.getBeanInfo(Introspector.java:425)

at java.beans.Introspector.getBeanInfo(Introspector.java:173)

at org.springframework.beans.CachedIntrospectionResults.<init>(CachedIntrospectionResults.java:279)

at org.springframework.beans.CachedIntrospectionResults.forClass(CachedIntrospectionResults.java:189)

at org.springframework.beans.BeanWrapperImpl.getCachedIntrospectionResults(BeanWrapperImpl.java:173)

at org.springframework.beans.BeanWrapperImpl.getLocalPropertyHandler(BeanWrapperImpl.java:226)

at org.springframework.beans.BeanWrapperImpl.getLocalPropertyHandler(BeanWrapperImpl.java:63)

at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:413)

at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:283)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:95)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1462)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1237)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:552)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1492)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1237)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:552)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)

at org.springframework.context.event.AbstractApplicationEventMulticaster.retrieveApplicationListeners(AbstractApplicationEventMulticaster.java:228)

at org.springframework.context.event.AbstractApplicationEventMulticaster.getApplicationListeners(AbstractApplicationEventMulticaster.java:185)

at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:127)

at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:383)

at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:337)

at org.springframework.web.servlet.FrameworkServlet.publishRequestHandledEvent(FrameworkServlet.java:1073)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

十二月 26, 2017 2:32:01 下午 org.apache.coyote.AbstractProtocol stop

信息: Stopping ProtocolHandler ["http-bio-8080"]

十二月 26, 2017 2:32:01 下午 org.apache.coyote.AbstractProtocol stop

信息: Stopping ProtocolHandler ["ajp-bio-8009"]

十二月 26, 2017 2:32:01 下午 org.apache.catalina.loader.WebappClassLoader loadClass

java.lang.IllegalStateException

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1610)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1569)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:348)

at com.sun.beans.finder.ClassFinder.findClass(ClassFinder.java:67)

at com.sun.beans.finder.ClassFinder.findClass(ClassFinder.java:110)