Revision 18592 trunk/extensions/extOracleSpatial/src/es/prodevelop/cit/gvsig/fmap/drivers/jdbc/oracle/OracleSpatialDriver.java

View differences:

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