-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Wouter,
On 5/9/2009 5:46 AM, Wouter D'Haeseleer wrote:
> This means, no connections available anymore.
>
> And when I look at the connections itself in oracle I see that the
> following connection is using more then 200 sessions !
I think Chuck is right: you're leaking connections.
> <Resource auth="Container"
> ...
I would highly recommend adding these two attributes to your <Resource>:
logAbaodoned="true"
removeAbandoned="true"
removeAbandonedTimeout="30" (# of seconds to wait before considering
a connection "abandoned". Adjust to
fit your needs)
While you're at it, maybe you want to set:
validationQuery="SELECT 1 FROM DUAL"
(or something else appropriate to test your connections)
> For me this is really strange since this connections says maxActive=10
I always recommend setting maxActive="1" in development. You'll find
connection leaks REALLY quick!
I'll take this opportunity to plug my own blog entry regarding proper
JDBC resource management:
http://blog.christopherschultz.net/?p=68
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkoIm4YACgkQ9CaO5/Lv0PDFcgCeMcq1tf6zJM2LL50BvFfclJ/j
/eQAoISCn7x1AoIxcLz32NY1XT1ZkrlT
=4iKb
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
