Re: How to avoid SET application_name = ''

From: Fabio Caiut <caiut(at)hotmail(dot)com>
To: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: How to avoid SET application_name = ''
Date: 2015-11-26 16:35:07
Message-ID: SNT152-W545E1C5CB6F440EA44D661A5040@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, Vladimir, Thomas ... you're right.
The glassfish guys analyzed dumps and look in the glassfish sources, the problem is there. They told me pool calls setClientInfo for each query!!
Thank you for your help.
Caiut

> Date: Wed, 25 Nov 2015 19:54:56 +0300
> Subject: Re: [JDBC] How to avoid SET application_name = ''
> From: sitnikov(dot)vladimir(at)gmail(dot)com
> To: caiut(at)hotmail(dot)com
> CC: pgsql-jdbc(at)postgresql(dot)org
>
> As far as I can tell, there is no option to completely disable "set
> application_name" feature via property.
>
> Is SQL appears when client calls
> Connection#setClientInfo("ApplicationName", ...) or
> Connection#setClientInfo(Properties).
>
> It make sense to avoid setting the same application name again and
> again for the same connection.
> Can you please file an issue at https://github.com/pgjdbc/pgjdbc/issues?
>
> In the mean time, it would be good if you could capture thread dumps
> from the application (e.g. 100 dumps with 10 second intervals under
> typical load) and grep setClientInfo. That would point out the line in
> code that issues that excessive setClientInfo.
>
> Vladimir

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2015-11-26 17:02:10 Re: How to avoid SET application_name = ''
Previous Message Dave Cramer 2015-11-26 12:20:03 Re: Migration to Maven