贴什么呢?我把proxool的设置给你们看看吧<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>ricky</alias>
<driver-url>jdbc:oracle:thin:QXTERM/QXTERM@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=61.141.21.25)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=QXTERM)))</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="QXTERM"/>
<property name="password" value="QXTERM"/>
</driver-properties>
<maximum-connection-count>500</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>这个设置,你们看看有什么问题,每次都到了一定时间就完蛋了
<something-else-entirely>
<proxool>
<alias>ricky</alias>
<driver-url>jdbc:oracle:thin:QXTERM/QXTERM@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=61.141.21.25)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=QXTERM)))</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="QXTERM"/>
<property name="password" value="QXTERM"/>
</driver-properties>
<maximum-connection-count>500</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>这个设置,你们看看有什么问题,每次都到了一定时间就完蛋了
解决方案 »
- java中的分页是什么意思?
- 求问TomCat启动后输入localhost:8080出现错误代码:404 如何解决?
- struts2 文件上传 获得文件类型的问题
- Hiberante查询时间段的记录
- Action运行到一半不动了
- 继承MappingDispatchAction的类this.getServlet得到空?
- 谁有webwork2-spring.jar,发个给老弟,谢谢
- 求高手帮忙hibernate的问题
- 用Jbuilder2006+websphere6开发ejb,编译出错,请教!!(急)
- 如何订阅apache axis的邮件列表?
- STRUTS的 重定向
- 这种问题hibernate可以解决吗?
393890 [HouseKeeper] ERROR proxool.ricky - #0002 encountered errors during destruction: java.sql.SQLException: Io 异常: Connection reset by peer: socket write error
393890 [HouseKeeper] WARN proxool.ricky - #0002 was active for 314265 milliseconds and has been removed automaticaly. The Thread responsible was named 'http8080-Processor24'.
393906 [http8080-Processor22] ERROR util.Log - select: 执行sql语句失败。
java.sql.SQLException: 关闭的连接
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:560)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:485)
at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.logicalcobwebs.proxool.ProxyConnection.invoke(ProxyConnection.java:68)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$87d93c8b.prepareStatement(<generated>)
at com.kongzh.passport.util.SqlTool.select(SqlTool.java:59)
at com.kongzh.passport.database.TableBase.select(TableBase.java:96)
at com.kongzh.passport.database.Database.select(Database.java:67)
at com.kongzh.passport.action.GamemanageAction.execute(GamemanageAction.java:113)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:805)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:696)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
at java.lang.Thread.run(Thread.java:595)
其实,你的论点我之前也想过,也投诉过。CSDN就是以积分制度来引纳人气的,我在这里发的贴子,也是只有一半左右得到最正确的回复,很多都是提供思路的,不过后来想想,这也对,在解决问题的过程中,自己的确提高了分析能力,很多高手的JAVA知识不一定很渊博,但是他们能最快地找到问题的所在,这种能力就是这样煅炼出来的,DEBUG能力也是程序员素质的一部分,由于别人没有看过你所有的代码,也不知你的JDK版本,服务器版本等等,所以也很难给出详尽准确的答案。如果你想高手多,建议你到matrix或javaeye那里去,但是,如果在那里提了一些初级问题,大多没人理你的。还有,我来这里不是为了分数的,只是为了向比我高的人学习,还有力所能及地帮一下有困难的人。CSDN的分数,一但发了贴子,就算你不结贴分也不能退回,而且还会减你的信誉分,这种制度的确助长了一些人的灌水骗分的习惯。