Обсуждение: 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?
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:
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?