Connection pooling issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Connection pooling issue

gareth.carter
Hi

Is anyone having issues with connection pooling in ofbiz? I have noticed on our systems (production, test and local) that after startup, 3 connections are created (for each db), stay in idle and are never reused. As the systems are used, connections are created and closed after use.

I tested this last night with latest trunk, postgres 9.3, jdbc 9.3-1101 and entityengine.xml set to use localpostgres/localpostolap/localposttenant with default settings (except db name!) and got the same behaviour

Can anyone verify the same behaviour with different databases?


This email is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error, please delete it and notify the sender.

Stannah Lift Holdings Ltd registered No. 686996, Stannah Management Services Ltd registered No. 2483693, Stannah Lift Services Ltd registered No. 1189799, Stannah Microlifts Ltd registered No. 964804, Stannah Lifts Ltd registered No. 1189836, Stannah Stairlifts Ltd registered No. 1401451.

All registered offices at Watt Close, East Portway, Andover, Hampshire, SP10 3SD, England.

All Registered in England and Wales.

This message has been scanned for malware by Websense. www.websense.com
Reply | Threaded
Open this post in threaded view
|

Re: Connection pooling issue

gareth.carter
For clarification, there are 2 issues here. First, connections are created on start and never reused or closed. Second, connection pooling does not seem to be working...