Revision 43734
| trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/SRSSolverBase.java | ||
|---|---|---|
| 77 | 77 |
String sql = "select srid, auth_name, auth_srid from spatial_ref_sys where auth_name/auth_srid is '"+applicationAbbrev+"'."; |
| 78 | 78 |
try {
|
| 79 | 79 |
String[] s = applicationAbbrev.split(":");
|
| 80 |
sql = "select srid, auth_name, auth_srid from spatial_ref_sys where auth_name = '" + s[0] +"' and auth_srid = '"+s[1]+"' ";
|
|
| 80 |
sql = "select srid, auth_name, auth_srid from spatial_ref_sys where upper(auth_name) = upper('" + s[0] +"') and auth_srid = "+s[1]+" ";
|
|
| 81 | 81 |
Statement st = connection.createStatement(); |
| 82 | 82 |
ResultSet rs = JDBCUtils.executeQuery(st, sql); |
| 83 | 83 |
if ( rs.next() ) {
|
Also available in: Unified diff