精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
---|---|
作者 | 正文 |
发表时间:2010-07-07
Spring3 下使用proxool做连接池的时候出现异常 ERROR 2010-07-06 12:27:10,328 [org.logicalcobwebs.proxool.ProxoolDriver] [Problem] 原因: org.springframework.web.context.ContextLoaderListener 加载先于proxool
解决办法:将proxool 也改成listener加载并先于spring 由于proxool 还没有listener的实现,所以自己写了一个以listener方式加载proxool 的实现的补丁proxool-listenerCfg.jar
下载补丁修改web.xml
<servlet> <servlet-name>ServletConfigurator</servlet-name> <servlet-class> org.logicalcobwebs.proxool.configuration.ServletConfigurator </servlet-class> <init-param> <param-name>xmlFile</param-name> <param-value>WEB-INF/proxool.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> 改为: <context-param> <param-name>proxoolConfigLocation</param-name> <param-value>WEB-INF/proxool.xml</param-value> </context-param> <listener> <listener-class>org.logicalcobwebs.proxool.configuration.ListenerConfigurator</listener-class> </listener> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener>
声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |
发表时间:2010-07-28
为什么我把你的jar加入后..会出现IO异常啊??
|
|
返回顶楼 | |
发表时间:2010-08-02
最后修改:2010-08-02
360913 [HouseKeeper] WARN proxool.DbPool - #0002 was active for 357640 milliseconds and has been removed automaticaly. The Thread responsible was named 'main'.
430792 [ajp-10405-2] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08003 430792 [ajp-10405-2] ERROR util.JDBCExceptionReporter - No operations allowed after connection closed. org.springframework.dao.DataAccessResourceFailureException: could not execute query; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute query 大牛知道这个是什么错吗?引用的是你的jar文件,加载成功了,但是总是报这个错! |
|
返回顶楼 | |
发表时间:2010-08-04
lian 写道 360913 [HouseKeeper] WARN proxool.DbPool - #0002 was active for 357640 milliseconds and has been removed automaticaly. The Thread responsible was named 'main'.
430792 [ajp-10405-2] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08003 430792 [ajp-10405-2] ERROR util.JDBCExceptionReporter - No operations allowed after connection closed. org.springframework.dao.DataAccessResourceFailureException: could not execute query; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute query 大牛知道这个是什么错吗?引用的是你的jar文件,加载成功了,但是总是报这个错! proxool.xml配置是否正确 <?xml version="1.0" encoding="UTF-8"?> <proxool-config> <proxool> <alias>phs</alias> <driver-url>jdbc:db2://192.168.12.22:50000/PHSDB</driver-url> <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class> <driver-properties> <property name="user" value="phs" /> <property name="password" value="phs6yhn7ujm" /> </driver-properties> <house-keeping-sleep-time>90000</house-keeping-sleep-time> <maximum-new-connections>100</maximum-new-connections> <maximum-active-time>4000</maximum-active-time> <prototype-count>5</prototype-count> <maximum-connection-count>10</maximum-connection-count> <minimum-connection-count>5</minimum-connection-count> </proxool> </proxool-config> |
|
返回顶楼 | |
发表时间:2011-04-03
我在访问数据库的时候还是出现这个问题啊!
Attempt to refer to a unregistered pool by its alias 'xxx' 我真无语了! |
|
返回顶楼 | |
浏览 10253 次