[Geotools-commits] svn - r38641 - branches/2.7.x/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver

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

Author: aaime
Date: 2012-03-24 13:24:25 -0700 (Sat, 24 Mar 2012)
New Revision: 38641

Modified:
   branches/2.7.x/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java
Log:
[GEOT-4078] Selects all when retrieving an SRID, patch by Ken Bisland

Modified: branches/2.7.x/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java
===================================================================
--- branches/2.7.x/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java	2012-03-21 06:22:23 UTC (rev 38640)
+++ branches/2.7.x/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java	2012-03-24 20:24:25 UTC (rev 38641)
@@ -151,7 +151,7 @@
     public Integer getGeometrySRID(String schemaName, String tableName,
             String columnName, Connection cx) throws SQLException {
         
-        StringBuffer sql = new StringBuffer("SELECT ");
+        StringBuffer sql = new StringBuffer("SELECT TOP 1 ");
         encodeColumnName(columnName, sql);
         sql.append( ".STSrid");