Connection Pool Exhausted

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

jhagstrand
Posts: 22
Joined: Thu Apr 17, 2008 8:38 pm

Connection Pool Exhausted

Post by jhagstrand » Sun Apr 19, 2009 5:13 pm

Hi,

I'm loading 500,000 records into OpenEMM using SOAP addSubscriber and setBinding.

When I start up my loader program it inserts about 20,000 records per hour. Then it gradually runs slower and slower until after 10 hours it can only insert two or three records per minute. Then finally any attempt to insert gets the "Cannot get a connection, pool exhausted" error message. We restart OpenEMM to recover.

I have seen these forum posts:
http://www.openemm.org/forums/viewtopic ... properties
http://www.openemm.org/forums/viewtopic.php?p=2296

In emm.properties I have
jdbc.maxCount=30

I have changed my loader program so it now it inserts a maximum 4000 records at one time. This runs in about 10 minutes, and I start this job with cron once each hour. This is working. The performance is not slowing down like before.

Can you tell me what is going on with the connection pool, and how can I tune it?
Thank you
John

gsantosh
Posts: 5
Joined: Tue Apr 20, 2010 12:39 pm

Required code for addSubscriber method.

Post by gsantosh » Thu Apr 22, 2010 7:34 am

Hii,
Can you please send me the code for addSubscriber.Please help me out.

Post Reply