Re: [DBCP] Possible to get query strings from datasource?

On 5/4/2018 6:15 PM, Shawn Heisey wrote: > The implementation looks clean to me, but I need something bad to happen > before I will know if it's actually working. I added a background thread that periodically logs pool stats.  At first, I never got it to line up with any actual database usage,

Re: [DBCP] Possible to get query strings from datasource?

On 5/4/2018 4:49 PM, Martin Gainty wrote: > MG>have a chat with your DBA on BasicDataSource validationQuery > MG>if this was Oracle it would be something like select 1 from DUAL This has me chuckling.   Let me put on my DBA hat (which doesn't fit all that well)... The server is MySQL.  I set the

Re: [DBCP] Possible to get query strings from datasource?

MG>pls see below From: Shawn Heisey Sent: Friday, May 4, 2018 3:16 PM To: user@commons.apache.org Subject: Re: [DBCP] Possible to get query strings from datasource? On 5/4/2018 10:38 AM, Phil Steitz wrote: > The only thing close to this

Re: [DBCP] Possible to get query strings from datasource?

On 5/4/18 12:16 PM, Shawn Heisey wrote: > On 5/4/2018 10:38 AM, Phil Steitz wrote: >> The only thing close to this that you can do now is if you have >> prepared statement pooling enabled, then via the JMX instrumentation >> of commons pool you can see the output of statement.toString().   >> See

Re: [DBCP] Possible to get query strings from datasource?

On 5/4/2018 10:38 AM, Phil Steitz wrote: > The only thing close to this that you can do now is if you have > prepared statement pooling enabled, then via the JMX instrumentation > of commons pool you can see the output of statement.toString().   > See listAllObjects in GenericObjectPoolMXBean. 

Re: [DBCP] Possible to get query strings from datasource?

On 5/4/18 12:49 AM, Shawn Heisey wrote: > Using dbcp 2.2.0 with pool 2.5.0. > > If the only object I have access to is BasicDataSource, is it > possible to obtain the SQL queries being executed by active > connections in the pool right now?  If so, how would I go about > doing that? > > At the

[collections] Question on the signature of the Transformed Predicate Transformer

Hi, I was trying to use the transformed predicate: Javadoc: Creates a predicate that transforms the input object before passing it to the predicate.

[DBCP] Possible to get query strings from datasource?

Using dbcp 2.2.0 with pool 2.5.0. If the only object I have access to is BasicDataSource, is it possible to obtain the SQL queries being executed by active connections in the pool right now?  If so, how would I go about doing that? At the moment I'm not using PreparedStatement, but I have

Re: [exec] Executed command can't open file argument

On 3 May 2018 at 22:35, Mark Trolley wrote: > On Thu, May 3, 2018 at 4:34 PM, sebb wrote: >> On 3 May 2018 at 17:18, Mark Trolley wrote: >> It may be that quotes are being added to the parameter - I assume the >> file name does not