• Post Reply Bookmark Topic Watch Topic
  • New Topic

Jakarta Connection Pooling

 
Nithya Natarajan
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using Jakarta's connection pooling mechanism.

The DB Config properties file looks like this:
rmstkt=com.nordstrom.sis.sfjdataservices.SfjOracleDataSource
rmstktpool.databasename=rtkdb
rmstktpool.password=XXXXXXX
rmstktpool.servername=rtk02
rmstktpool.user=rtkusr
rmstktpool.drivertype=thin
rmstktpool.portnumber=1521
rmstktpool.transisolation=2
rmstktpool.maxactiveconnections=28
rmstktpool.maxidleconnections=20
rmstktpool.maxwaittime=1000
rmstktpool.readonly=true
rmstktpool.timebetweenevicrunsmillis=1800000
rmstktpool.numtestsperevicrun=20
rmstktpool.minevicidletimemillis=1800000
rmstktpool.validationquery=select 1 from dual
rmstktpool.testonborrow=false
rmstktpool.testonreturn=false
rmstktpool=com.nordstrom.sis.sfjdataservices.SfjPoolDataSource

During the peak load testing of my application, I got an error from the SfjPoolDataSource object:
08/24/2004 15:47:16 [EROR] [mssreticket ] x0319t32 [T RBThreadPool-1::thread-26] StartupHelperBean [ com.nordstrom.mss.reticketing.helper.StartupHelperBean :: generateStores() [Message] Failure in generateStores(). Exception:com.nordstrom.sis.sfjdataservices.DataServicesException: [com.nordstrom.sis.sfjdataservices.JdbcServices::getConnection ] [com.nordstrom.sis.sfjdataservices.SfjPoolDataSource::getConnection ] Could not retrieve connection info from pool

Anyone has any idea why would this happen? I have conn.close() statement in the finally block.

Please Help!!!

Thanks
Nithya
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!