Revision 38077 branches/v2_0_0_prep/extensions/org.gvsig.oracle/src/org/gvsig/fmap/dal/store/oracle/OracleHelper.java
| OracleHelper.java | ||
|---|---|---|
| 197 | 197 |
return limit; |
| 198 | 198 |
} |
| 199 | 199 |
|
| 200 |
String _schema = (String) ((OracleStoreParameters) storeParams).getDynValue("schema");
|
|
| 201 |
|
|
| 200 | 202 |
StringBuilder strb = new StringBuilder(); |
| 201 | 203 |
strb.append("SELECT * FROM "
|
| 202 |
+ OracleValues.USER_ORACLE_GEOMETADATA_VIEW);
|
|
| 204 |
+ OracleValues.ALL_ORACLE_GEOMETADATA_VIEW);
|
|
| 203 | 205 |
strb.append(" WHERE "
|
| 204 | 206 |
+ OracleValues.USER_ORACLE_GEOMETADATA_VIEW_TABLE_NAME |
| 205 | 207 |
+ " = '" + storeParams.getTable() + "'"); |
| 206 | 208 |
strb.append(" AND "
|
| 207 | 209 |
+ OracleValues.USER_ORACLE_GEOMETADATA_VIEW_COLUMN_NAME |
| 208 | 210 |
+ " = '" + geometryAttrName + "'"); |
| 211 |
strb.append(" AND "
|
|
| 212 |
+ OracleValues.USER_ORACLE_GEOMETADATA_VIEW_OWNER |
|
| 213 |
+ " = '" + _schema + "'"); |
|
| 209 | 214 |
String sql = strb.toString(); |
| 210 | 215 |
|
| 211 | 216 |
ResultSet rs = null; |
| 212 | 217 |
Statement st = null; |
| 213 |
String schema = null; |
|
| 218 |
// String schema = null;
|
|
| 214 | 219 |
Connection conn = null; |
| 215 | 220 |
|
| 216 | 221 |
Envelope fullEnvelope = null; |
Also available in: Unified diff