# HG changeset patch # User Babis Nikolaou # Date 1442944595 -10800 # Node ID c18b84e14117dd06cdad38136d27016ed4774295 # Parent 1f52e999af3e217c9365652159f6813493312c54 some additions for reporting the application name from the postgres connection url (does not work yet) diff -r 1f52e999af3e -r c18b84e14117 postgis/src/main/java/org/openrdf/sail/postgis/PostGISSqlStore.java --- a/postgis/src/main/java/org/openrdf/sail/postgis/PostGISSqlStore.java Tue Sep 22 20:13:47 2015 +0300 +++ b/postgis/src/main/java/org/openrdf/sail/postgis/PostGISSqlStore.java Tue Sep 22 20:56:35 2015 +0300 @@ -104,8 +104,11 @@ url.append(databaseName); Iterator> iter; iter = getProperties().entrySet().iterator(); + + // append application name for identifying connection in `pg_stat_activity' table + url.append("?application_name=strabon"); if (iter.hasNext()) { - url.append("?"); + url.append("&"); } while (iter.hasNext()) { Entry e = iter.next(); diff -r 1f52e999af3e -r c18b84e14117 runtime/src/main/java/eu/earthobservatory/runtime/postgis/Strabon.java --- a/runtime/src/main/java/eu/earthobservatory/runtime/postgis/Strabon.java Tue Sep 22 20:13:47 2015 +0300 +++ b/runtime/src/main/java/eu/earthobservatory/runtime/postgis/Strabon.java Tue Sep 22 20:56:35 2015 +0300 @@ -55,7 +55,7 @@ logger.info("[Strabon] Cleaning..."); Class.forName("org.postgresql.Driver"); url = "jdbc:postgresql://" + serverName + ":" + port + "/" - + databaseName + "?user=" + user + "&password=" + password + "&application_name=Strabon"; + + databaseName + "?user=" + user + "&password=" + password + "&application_name=strabon"; Connection conn = DriverManager.getConnection(url); java.sql.Statement st = conn.createStatement(); st.execute("DROP TABLE IF EXISTS locked;"); @@ -95,7 +95,7 @@ try { logger.info("[Strabon] Checking for locks..."); Class.forName("org.postgresql.Driver"); - url = "jdbc:postgresql://" + serverName + ":" + port + "/" + databaseName + "?user=" + user + "&password=" + password + "&application_name=Strabon"; + url = "jdbc:postgresql://" + serverName + ":" + port + "/" + databaseName + "?user=" + user + "&password=" + password + "&application_name=strabon"; conn = DriverManager.getConnection(url); st = conn.createStatement();