Re: Logging Abandoned Connection

2023-09-28 Thread Kean Erickson
Hi Chege, to my knowledge these flags are meant to work together, so the abandoned cinnections should be logged as they are removed. But I think setting the suspectTimeout flag will allow you to test how you want: https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html On Wed, Sep 27, 2023,

Re: Logging Abandoned Connection

2023-09-27 Thread chege
On Wed, 2023-09-27 at 11:32 -0700, Kean Erickson wrote: > Kean Hi Kean, Thanks for the response. Before removing abandoned connections I want to log the event.

Re: Logging Abandoned Connection

2023-09-27 Thread Kean Erickson
I believe you need a couple more properties for abandoned connections to be pruned: removeAbandoned="true" removeAbandonedTimeout="60" On Wed, Sep 27, 2023, 12:18 AM chege wrote: > Hi, > > I using tomee 8.0.14. I want to see which code is not closing > connections. I have set logAbandoned

Logging Abandoned Connection

2023-09-27 Thread chege
Hi, I using tomee 8.0.14. I want to see which code is not closing connections. I have set logAbandoned true in my datasource. However I don't see the any abandoned connection logged. DataSourceCreator tomcat JdbcDriver org.postgresql.Driver JdbcUrl