commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <dirk.verbe...@pandora.be>
Subject Re: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing
Date Thu, 06 May 2004 17:30:55 GMT
DBCP version? (1.0, 1.1, nightly)

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: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message