BUG #15125: Cant set ApplicationName in Java...
The following bug has been logged on the website:
Bug reference: 15125
Logged by: Ezequiel Post
Email address: ezekii.post@gmail.com
PostgreSQL version: 9.6.8
Operating system: Debian Jessie
Description:
Hello, I'm trying to set ApplicationName via JDBC driver, but the
application_name never changes.
Code:
@Override
@Transactional
public Connection getConnection() throws SQLException {
Properties props = new Properties();
props.put("user", "postgres");
props.put("password", "admin");
props.put("ApplicationName", "wtha");
Connection connection =
DriverManager.getConnection("jdbc:postgresql://localhost:5433/TESTE",
props);
connection.setClientInfo("ApplicationName", "wth");
return connection;
}
Tried with ?ApplicationName=any, but don't work too..
Any help would be appreciate, thanks!
On Wed, Mar 21, 2018 at 4:31 PM, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 15125
Logged by: Ezequiel Post
Email address: ezekii.post@gmail.com
PostgreSQL version: 9.6.8
Operating system: Debian Jessie
Description:Hello, I'm trying to set ApplicationName via JDBC driver, but the
application_name never changes.
Code:
@Override
@Transactional
public Connection getConnection() throws SQLException {
Properties props = new Properties();
props.put("user", "postgres");
props.put("password", "admin");
props.put("ApplicationName", "wtha");
Connection connection =
DriverManager.getConnection("jdbc:postgresql://localhost:5433/TESTE",
props);
connection.setClientInfo("ApplicationName", "wth");
return connection;
}Tried with ?ApplicationName=any, but don't work too..
Any help would be appreciate, thanks!
I can't offer much assistance on the issue itself, but have you tried
emailing the pgsql-jdbc mailing list?
https://www.postgresql.org/list/pgsql-jdbc/
https://www.postgresql.org/list/
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
Hello Keith, sorry, it was my mistake. is not the application_name of the
whole postgresql server that changes, just the application_name of the
requested connection. after putting a breakpoint just after
"setClientInfo", i could see running the query " "select pid,
application_name from pg_stat_activity" that the application_name of the
connection was right. Sorry again!
Em qui, 22 de mar de 2018 às 13:41, Keith Fiske <keith.fiske@crunchydata.com>
escreveu:
Show quoted text
On Wed, Mar 21, 2018 at 4:31 PM, PG Bug reporting form <
noreply@postgresql.org> wrote:The following bug has been logged on the website:
Bug reference: 15125
Logged by: Ezequiel Post
Email address: ezekii.post@gmail.com
PostgreSQL version: 9.6.8
Operating system: Debian Jessie
Description:Hello, I'm trying to set ApplicationName via JDBC driver, but the
application_name never changes.
Code:
@Override
@Transactional
public Connection getConnection() throws SQLException {
Properties props = new Properties();
props.put("user", "postgres");
props.put("password", "admin");
props.put("ApplicationName", "wtha");
Connection connection =
DriverManager.getConnection("jdbc:postgresql://localhost:5433/TESTE",
props);
connection.setClientInfo("ApplicationName", "wth");
return connection;
}Tried with ?ApplicationName=any, but don't work too..
Any help would be appreciate, thanks!I can't offer much assistance on the issue itself, but have you tried
emailing the pgsql-jdbc mailing list?https://www.postgresql.org/list/pgsql-jdbc/
https://www.postgresql.org/list/--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com