Revision 18592
trunk/extensions/extOracleSpatial/src/es/prodevelop/cit/gvsig/fmap/drivers/jdbc/oracle/OracleSpatialDriver.java | ||
---|---|---|
4021 | 4021 |
|
4022 | 4022 |
private boolean allowsGeoQueries(Connection c, String _t, String gf, String _srid, int dims) { |
4023 | 4023 |
String p = getPointConstructor(dims, _srid); |
4024 |
String qry = "SELECT * FROM " + _t.toUpperCase() + " WHERE (ROWNUM = 1)"; |
|
4025 |
qry = "SELECT * FROM (" + qry + ") WHERE SDO_RELATE(" + "\"" + gf + "\", " + p + ", 'mask=TOUCH') = 'TRUE'"; |
|
4024 |
String qry = ""; |
|
4025 |
qry = "SELECT * FROM " + _t.toUpperCase() |
|
4026 |
+ " WHERE SDO_RELATE(" + "\"" + gf + "\", " + p + ", 'mask=TOUCH') = 'TRUE'" |
|
4027 |
+ " AND ROWNUM = 1"; |
|
4026 | 4028 |
|
4027 | 4029 |
try { |
4028 | 4030 |
Statement _st = c.createStatement(); |
Also available in: Unified diff