Normally you should get a SQLException even when the pool is empty. Can you post your frmTestConnectionPool.jsp?
-- Dirk
raj wrote:
Hello, We have been using jakarta pool implementation with JRUN for past 6 months and worked fine until last week. Started giving this error.
Works fine for couple of hours and starts crashing and had to restart JRUN every time.
Explanation from our admin --> Load on database causing delay in getting connection from connection pool which is becoming stale after trying to get connection for long time. I did not like this explanation as nothing changed and started suddenly. ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR YOUR TIME.
These are the parameters for connection pool GenericObjectPool connectionPool = new
GenericObjectPool(null);
ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory(connectURI,null);
new
PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
// set up pool options
connectionPool.setTestOnBorrow(true);
connectionPool.setTestOnReturn(true);
connectionPool.setMaxActive(50);
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
PoolingDataSource dataSource = new PoolingDataSource(connectionPool);
--> This is stacktrace from the JSP -->
05/04/2004 06:03:06 PM /temp/frmTestConnectionPool.jsp Error 0 Testing 05/04/2004 06:03:06 PM /temp/frmTestConnectionPool.jsp Error 0 Testing 2 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Error 0 java.lang.NullPointerException
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 com.nokia.support.DBConnection.<init>(DBConnection.java:349)
----->
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.ThreadPool.run(ThreadPool.java:272)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp Information 0 allaire.jrun.WorkerThread.run(WorkerThread.java:75)
05/04/2004 06:03:06 PM /temp/frmTestConnectionPool.jsp Error 0 Testing 7
THANKS very much-- RAJ
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
