# HG changeset patch
# User Babis Nikolaou <charnik@di.uoa.gr>
# 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<Entry<String, String>> 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<String, String> 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();