HI raj, may I ask you what db server are you using? bye daniele rizzi
-----Messaggio originale----- Da: raj [mailto:[EMAIL PROTECTED] Inviato: mercoledi 5 maggio 2004 7.54 A: Jakarta Commons Users List Oggetto: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing 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]
