From: <svn...@os...> - 2012-03-24 20:27:11
|
Author: aaime Date: 2012-03-24 13:27:03 -0700 (Sat, 24 Mar 2012) New Revision: 38642 Modified: trunk/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: trunk/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java =================================================================== --- trunk/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java 2012-03-24 20:24:25 UTC (rev 38641) +++ trunk/modules/plugin/jdbc/jdbc-sqlserver/src/main/java/org/geotools/data/sqlserver/SQLServerDialect.java 2012-03-24 20:27:03 UTC (rev 38642) @@ -152,7 +152,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(null, columnName, sql); sql.append( ".STSrid"); |