websphere 7 连接池不释放

gzz_gzz 2012-11-16 11:05:06

同样的程序我在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

...全文