commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "daniele rizzi" <daniele.ri...@essellesse.net>
Subject R: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing
Date Wed, 05 May 2004 07:37:58 GMT

HI raj,
may I ask you what db server are you using?

bye
daniele rizzi


-----Messaggio originale-----
Da: raj [mailto:rajshiri@yahoo.com]
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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org

Mime
View raw message