websphere 7 连接池不释放
同样的程序我在tomcat和jetty上用测试程序,10线程重复200次都没有问题,可是在websphere7上跑几下连接就满了,感觉像连接池里的链接没有释放,我用的是hibernate,JNDI,在tomcat上就能够自动释放链接。下面websphere抛的异常。高手帮忙分析一下,是什么原因,was上要有什么特殊配置吗?另外我程序用的语句全是把session交给给hibernate管理得,并没有自己支获取session.[12-11-17 10:46:03:015 CST] 00000017 SystemOut O 2012-11-17 10:46:03,015 [LogUnit.java:48][INFO]:写入系统日志------
[12-11-17 10:46:03:484 CST] 00000015 servlet I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [ntvps_webapp_war] [/ntvps_webapp] [/WEB-INF/jsp/showError.jsp]: 初始化成功。
[12-11-17 10:46:40:406 CST] 00000014 FreePool E J2CA0045E: 对资源 jdbc/ntvpswebapp 调用方法 createOrWaitForConnection 时,没有可用的连接。
[12-11-17 10:46:40:406 CST] 00000014 SystemOut O 2012-11-17 10:46:40,406 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:46:40:406 CST] 00000014 SystemOut O 2012-11-17 10:46:40,406 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:46:40:406 CST] 00000014 SystemOut O 2012-11-17 10:46:40,406 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:46:40:406 CST] 00000014 SystemOut O 2012-11-17 10:46:40,406 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:47:37:484 CST] 0000001e FreePool E J2CA0045E: 对资源 jdbc/ntvpswebapp 调用方法 createOrWaitForConnection 时,没有可用的连接。
[12-11-17 10:47:37:484 CST] 0000001e SystemOut O 2012-11-17 10:47:37,484 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:47:37:484 CST] 0000001e SystemOut O 2012-11-17 10:47:37,484 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:47:37:484 CST] 0000001e SystemOut O 2012-11-17 10:47:37,484 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:47:37:484 CST] 0000001e SystemOut O 2012-11-17 10:47:37,484 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:47:40:140 CST] 0000001a FreePool E J2CA0045E: 对资源 jdbc/ntvpswebapp 调用方法 createOrWaitForConnection 时,没有可用的连接。
[12-11-17 10:47:40:140 CST] 0000001a SystemOut O 2012-11-17 10:47:40,140 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:47:40:140 CST] 0000001a SystemOut O 2012-11-17 10:47:40,140 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:47:40:140 CST] 0000001a SystemOut O 2012-11-17 10:47:40,140 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:47:40:140 CST] 0000001a SystemOut O 2012-11-17 10:47:40,140 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:47:47:125 CST] 0000001b FreePool E J2CA0045E: 对资源 jdbc/ntvpswebapp 调用方法 createOrWaitForConnection 时,没有可用的连接。
[12-11-17 10:47:47:125 CST] 0000001b SystemOut O 2012-11-17 10:47:47,125 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:47:47:125 CST] 0000001b SystemOut O 2012-11-17 10:47:47,125 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:47:47:125 CST] 0000001b SystemOut O 2012-11-17 10:47:47,125 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:47:47:125 CST] 0000001b SystemOut O 2012-11-17 10:47:47,125 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:48:17:781 CST] 0000001f FreePool E J2CA0045E: 对资源 jdbc/ntvpswebapp 调用方法 createOrWaitForConnection 时,没有可用的连接。
[12-11-17 10:48:17:781 CST] 0000001f SystemOut O 2012-11-17 10:48:17,781 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:48:17:781 CST] 0000001f SystemOut O 2012-11-17 10:48:17,781 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:48:17:781 CST] 0000001f SystemOut O 2012-11-17 10:48:17,781 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:48:17:781 CST] 0000001f SystemOut O 2012-11-17 10:48:17,781 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:48:29:609 CST] 00000019 FreePool E J2CA0045E: 对资源 jdbc/ntvpswebapp 调用方法 createOrWaitForConnection 时,没有可用的连接。
[12-11-17 10:48:29:609 CST] 00000019 SystemOut O 2012-11-17 10:48:29,609 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:48:29:609 CST] 00000019 SystemOut O 2012-11-17 10:48:29,609 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
[12-11-17 10:48:29:609 CST] 00000019 SystemOut O 2012-11-17 10:48:29,609 [JDBCExceptionReporter.java:100][WARN]:SQL Error: 0, SQLState: null
[12-11-17 10:48:29:609 CST] 00000019 SystemOut O 2012-11-17 10:48:29,609 [JDBCExceptionReporter.java:101][ERROR]:Connection not available, Timed out waiting for 180000
--------------------编程问答-------------------- 没有人理我。哎
--------------------编程问答-------------------- 朋友,你这问题解决了吗
补充:Java , Web 开发