[Geotools-commits] svn - r33386 - trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc

[<svn...@os...>]

Author: mcr
Date: 2009-06-29 05:38:16 -0400 (Mon, 29 Jun 2009)
New Revision: 33386

Modified:
   trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc/JDBCAccessPostGis.java
Log:
postgis falls back to extent function if st_extent does not exist, 2.6.x


Modified: trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc/JDBCAccessPostGis.java
===================================================================
--- trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc/JDBCAccessPostGis.java	2009-06-29 09:37:29 UTC (rev 33385)
+++ trunk/modules/plugin/imagemosaic-jdbc/src/main/java/org/geotools/gce/imagemosaic/jdbc/JDBCAccessPostGis.java	2009-06-29 09:38:16 UTC (rev 33386)
@@ -61,15 +61,48 @@
 		initStatementStrings(config);
 	}
 
+	
 	/**
+	 * @return the postigs function name for calculating extents, 
+	 * newer versions offer 'st_extent'
+	 * older versions provide 'extent', which is depricated
+	 */
+	private String getExtentFunctionName() {
+            String extentFunctionName="st_extent";
+            Connection con=null;
+            ResultSet rs = null;
+            PreparedStatement ps = null;
+            try {
+                con = dataSource.getConnection();
+                ps = con.prepareStatement("select proname  from pg_proc where proname='"+extentFunctionName+"'");
+                rs = ps.executeQuery();
+            
+                if (rs.next()==false) { 
+                    extentFunctionName="extent";
+                    LOGGER.info("Using depricated postgis function 'extent' instead of 'st_extent'");
+                }               
+            } catch (SQLException ex) {
+                LOGGER.log(Level.WARNING, "could not verify existence of postgis function 'st_extent', falling back to depricated 'extent'");
+                extentFunctionName="extent";
+            }
+            finally {
+                try { if (rs!=null) rs.close(); } catch (SQLException ex) {};
+                try { if (ps!=null) ps.close(); } catch (SQLException ex) {};
+                try { if (con!=null) ps.close(); } catch (SQLException ex) {};
+                    
+            }
+	    return extentFunctionName;
+	}
+	
+	/**
 	 * Initialize needed sql statement strings
 	 * 
 	 * @param config
 	 */
 	private void initStatementStrings(Config config) {
-		final String geomAttr = config.getGeomAttributeNameInSpatialTable();
-		extentSelect = "select st_extent(" + geomAttr + ") from {0}";
-
+		final String geomAttr = config.getGeomAttributeNameInSpatialTable();					        
+		extentSelect = "select "+getExtentFunctionName()+"(" + geomAttr + ") from {0}";
+		
 		// ////////////
 		final String spatialSelectClause = "select s."
 				+ config.getKeyAttributeNameInSpatialTable() + ","