Yeah odd, Cayenne checks out a connection from a DataSource only for
the duration of an operation, and then returns it back. So are you
using Cayenne-provided DataSource (DriverDataSourceFactory in the
Modeler), and not JNDI, DBCP or some other container-provided one?
Can you take a thread dump of your application? ("kill -QUIT <pid>" on
UNIX) and see if anything is stuck on a DB operation?
Cheers,
Andrus
On Apr 15, 2010, at 8:57 PM, Joe Baldwin wrote:
Hi Michael,
min = 1
max = 10 (we changed this to 20 but then got the same error)
To my knowledge there are no long running transactions. Most are
product list fetches which should take less than a second each.
There is some content editing right now, so there are about 50-100
updates per day, (which again should take no more than 1 sec per
transaction)
I have been searching through my code, but can't find anything that
seems out of the ordinary.
Is there an object available to me that will report open connections?
Thanks,
Joe
On Apr 15, 2010, at 8:18 AM, Michael Gentry wrote:
The connections are stored and reused. What is your min/max setting?
Do you have any long-running transactions?
On Wed, Apr 14, 2010 at 11:34 PM, Joe Baldwin <[email protected]
> wrote:
Why would the DataContext be running out of connections in a web
app with only a small amount of traffic?
(I thought that a group of connections were stored (base on the
modeler specification), and then reused for each transaction.)
Joe
