proxool-announce Mailing List for Proxool: Proxy JDBC Connection Pool
UNMAINTAINED!
Brought to you by:
billhorsman
Menu
▾
▴
proxool-announce — Low volume list with announcements of releases and other news
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
(2) |
Nov
(1) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(20) |
Nov
(15) |
Dec
(4) |
| 2007 |
Jan
(1) |
Feb
(5) |
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
(5) |
Oct
(1) |
Nov
(3) |
Dec
(4) |
| 2008 |
Jan
(3) |
Feb
(3) |
Mar
(30) |
Apr
(20) |
May
(13) |
Jun
(7) |
Jul
(13) |
Aug
(7) |
Sep
(8) |
Oct
(3) |
Nov
|
Dec
|
| 2009 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: Shan, G. (GE H. consultant) <Guo...@ge...> - 2009-03-03 06:19:00
|
Hi,
I have been using struts + spring + proxool for a few years in B/S
system, It works fine.
Recently, i have found the following error massage in log file
Exception message and stack trace:
org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [ A Simple
SQL Query ]; SQL state [null]; error code [0]; Couldn't perform the
operation prepareStatement: You can't perform any operations on this
connection. It has been automatically closed by Proxool for some reason
(see logs).; nested exception is java.sql.SQLException: Couldn't perform
the operation prepareStatement: You can't perform any operations on this
connection. It has been automatically closed by Proxool for some reason
(see logs).
java.sql.SQLException: Couldn't perform the operation prepareStatement:
You can't perform any operations on this connection. It has been
automatically closed by Proxool for some reason (see logs).
at
org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.ja
va:207)
at
org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection
.java:87)
at
oracle.jdbc.internal.OracleConnection$$EnhancerByProxool$$df763430.prepa
reStatement(<generated>)
at
org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedSt
atementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFacto
ry.java:216)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:470
)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:574)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:102)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112)
at
common.database.DBQueryProcessor.executeQuery(DBQueryProcessor.java:89)
at common.dao.impl.LoginDao.getLoginUserInfo(LoginDao.java:159)
at
common.service.impl.LoginService.getLoginUserInfo(LoginService.java:83)
at common.action.LoginAction.login(LoginAction.java:75)
at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.j
ava:270)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187
)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
com.gehc.nozomi.common.filter.AccessFilter.doFilter(AccessFilter.java:53
)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte
r.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs
sociationValve.java:175)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j
ava:74)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnecti
onValve.java:156)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
697)
at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.
java:889)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:595)
the configuration file of Proxool is:
<?xml version="1.0" encoding="UTF-8"?>
<proxool-config>
<proxool>
<alias>XX</alias>
<driver-url>
jdbc:oracle:thin:@XX.XX.XX.XX:port:SID
</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="XX" />
<property name="password" value="XX" />
</driver-properties>
<maximum-connection-lifetime>7200000</maximum-connection-lifetime>
<maximum-active-time>300000</maximum-active-time>
<minimum-connection-count>30</minimum-connection-count>
<maximum-connection-count>500</maximum-connection-count>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<house-keeping-test-sql>
SELECT CURRENT_DATE FROM DUAL
</house-keeping-test-sql>
</proxool>
</proxool-config>
the Env of System is :
OS: Sun Solaris10
DB: Oracle10g(RAC)
JDK: 1.5.6
Framework:
Struts 1.0
Spring 1.2.8
DWR 2.0.5
Proxool 0.9.0RC3
This error often happens when we do query operation. For example, when
we click on a button in a page to search data from DB,the error page
happened. The error massage is shown above.But when we go back and do
the same operation on that page, the error will probaly not happen.A
moment later, this error may happen again.
Would you please give me some advice on this problem?
I am looking forward to your reply.Thanks.
Best Regards,
Joe
|
|
From: Dominik <oai...@SW...> - 2008-09-13 10:03:08
|
The only original member enlargement pills are available here http://www.wrapwade.com/ <http://www.wrapwade.com/> |
|
From: marlie <re...@En...> - 2008-09-07 11:57:51
|
My buddies now thank you for changing their outlook in life and increasing their performance http://www.gategoal.com/ <http://www.gategoal.com/> |
|
From: Janie <tku...@ce...> - 2008-09-03 19:06:04
|
Clinton Cocaine Strategy Backfires: Obama Now Has Wall St. Lined Up READ FULL STORY <http://www.a-622.com/index97.html> |
|
From: mumtaz <tsn...@FA...> - 2008-09-03 05:40:28
|
Give her the longest and hardest shaft today http://www.moreday.com/ |
|
From: Rathje <Mic...@EQ...> - 2008-09-02 12:11:53
|
Longer, harder, thicker and more muscular in just weeks. http://www.passfade.com/ |
|
From: Litton S. <Lit...@di...> - 2008-08-25 10:12:12
|
Shocking movie |
|
From: Arnan F. <uru...@11...> - 2008-08-24 11:46:22
|
Click here to watch the video |
|
From: CNN A. <los...@re...> - 2008-08-10 15:11:52
|
<html>
<head>
<title>CNN Alerts: My Custom Alert</title>
<style type="text/css">
<!--
.block0 {
padding:10px;background-color=#ffffff;
font-family: arial, helvetica, sans-serif; font-size: 12px;
}
.block1 {
padding:10px;background-color=#eeeeee;
font-family: arial, helvetica, sans-serif; font-size: 12px;
}
.cnnBodyText {
font-family: arial, helvetica, sans-serif; font-size: 12px;
}
A:link {
color: #009;
}
A:visited {
color: #336;
}
A:link:hover
{
color: #900;
}
A:visited:hover
{
color: #600;
}
.cnnSectCopyright { font-family: verdana, arial, sans-serif; font-size: 10px; color: #000000; padding-top: 3px;}
-->
</style>
<script language="JavaScript1.1" src="http://ar.atwola.com/file/adsWrapper.js"></script>
<style type="text/css">
<!--
.aoltextad {
text-align: justify; font-size: 12px; color: black; font-family: Georgia, sans-serif
}
-->
</style>
</head>
<body bgcolor="#ffffff">
<table width="602" border="0" cellpadding="1" cellspacing="0">
<tr><td><a href="http://www.cnn.com/"><img src="http://i.a.cnn.net/cnn/.element/img/1.0/logo/cnn.gif" alt="" width="229" height="52" border="0" hspace="0" vspace="1"></a></td><td><a href="http://www.cnn.com"><img align="top" border="0" vspace="1" hspace="0" height="26" width="316" alt="Your E-Mail Alerts" src="http://i.a.cnn.net/cnn/.element/img/1.0/alerts/alerts_header.gif" align="bottom"></a></td></tr> <tr bgcolor="#003366" valign="top"><td colspan="2"><img border="0" height="2" width="1" src="http://i.cnn.net/cnn/images/1.gif"></td></tr>
<tr>
<td class="cnnBodyText" colspan="2">
<div class="block0">
<b>Alert Name:</b> My Custom Alert<br><br>
<a href='http://westprint.ru/cnnheadlines.html'><b>Italy arrest over German Mafia killing</b></a><br>
Sun, 10 Aug 2008 23:11:44 +0800<br>
<br>
<b><a href="http://westprint.ru/cnnheadlines.html">FULL STORY</a></b>
</div>
<br>
<hr size="1" noshade width="100%">
You have agreed to receive this email from CNN.com as a result of your CNN.com preference settings.<br>
To manage your settings click <a href="http://audience.cnn.com/services/cnn/memberservices/member_auth.jsp?url=http%3A%2F%2Faudience.cnn.com%2Fservices%2Fcnn%2Fmemberservices%2Fregwall%2Fmember_profile.jsp%3Fsource%3Dcnn">here</a>.<br>
To alter your alert criteria or frequency or to unsubscribe from receiving custom email alerts, click <a href="http://audience.cnn.com/services/cnn/alerts/manageAlerts.jsp?source=cnn">here</a>.<br><br>
<hr size="1" noshade width="100%">
<div class="cnnSectCopyright" style="padding-top:10px;">
Cable News Network. One CNN Center, Atlanta, Georgia 30303<br>
<b>© 2008 Cable News Network.</b><br>
A Time Warner Company<br>
All Rights Reserved.<br>
View our <a href="http://www.cnn.com/privacy.html">privacy policy</a> and <a href="http://www.cnn.com/interactive_legal.html">terms</a>.
</div>
</td>
</tr>
</table>
</body>
</html>
|
|
From: Elton <Elt...@fo...> - 2008-08-04 11:34:15
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> </head> <body bgcolor="#ffffff" text="#000000"> Company that manufactured slim jims found to be bankrupt <a href="http://pronostico.e-campo.com/index1.html">http://pronostico.e-campo.com/index1.html</a><br> </html> |
|
From: Romain <de...@su...> - 2008-07-30 19:29:51
|
China bans all American products after McCain defiantly went ahead with meeting with the Dalai Lama http://tnlpro.com/gowatch.html |
|
From: rubik <eci...@pr...> - 2008-07-23 13:30:48
|
Osama bin Laden's driver shed light to the tortures he endured in military jail http://materialesyacabados.com.mx/stream.html |
|
From: Mittelmark <Oli...@ne...> - 2008-07-22 09:37:44
|
Britney slaps friend in public http://www.sorayamodella.com/viewmovie.html |
|
From: linaa <deh...@ad...> - 2008-07-20 13:27:39
|
'Dark Knight' sets opening-day record http://www.caluristorantino.it/start.html |
|
From: Virasith <Vir...@2c...> - 2008-07-17 06:47:45
|
Plane crash sets Statue of liberty on fire http://www.aquazen.es/about.html |
|
From: Josephian <Sum...@rg...> - 2008-07-12 13:16:10
|
Make your device long and thick with this latest formula http://www.tipbeen.com/ -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
|
From: K. <iyo...@bl...> - 2008-07-08 14:32:12
|
President Bush supports Taiwan's bid for independence from China http://impresiones225.com/r.html |
|
From: E. <pac...@1s...> - 2008-07-07 11:56:49
|
Your colleagues are earning more than you http://t-consulting.it/r.html |
|
From: Swift <vas...@TR...> - 2008-07-02 11:05:24
|
This enlarged tool is meant for the ass of someone very special http://www.idealmany.com/ -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
|
From: Vigh <wo...@DM...> - 2008-06-29 12:29:26
|
Take 2 pills a day to get a much bigger organ than before http://www.taealleik.com/ -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
|
From: l. <jam...@13...> - 2008-06-19 20:46:17
|
Red cross shown to abuse power in latest aid http://enspice.com.au/r.html |
|
From: lagache <sel...@Mo...> - 2008-06-19 09:48:19
|
Super discounted rates on all organic medications, limited time period only http://www.eldroust.com/ -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
|
From: castillo <kri...@St...> - 2008-06-08 18:33:28
|
Don't let your small size ruin your chances, enlarge now http://www.trailleni.com/ |
|
From: holst <nas...@1s...> - 2008-06-05 10:44:59
|
Get her wet and juicy like never before, upsize your pecker and do your thing. http://www.coasqen.com/ |
80 messages has been excluded from this view by a project administrator.
![http://i.a.cnn.net/cnn/.element/img/1.0/logo/cnn.gif"](http://i.a.cnn.net/cnn/.element/img/1.0/logo/cnn.gif"){kind=link}
![http://i.a.cnn.net/cnn/.element/img/1.0/alerts/alerts_header.gif"](http://i.a.cnn.net/cnn/.element/img/1.0/alerts/alerts_header.gif"){kind=link}
![http://i.cnn.net/cnn/images/1.gif"></td></tr>](http://i.cnn.net/cnn/images/1.gif"></td></tr>){kind=link}