Revision 15524 trunk/extensions/extOracleSpatial/src/es/prodevelop/cit/gvsig/fmap/drivers/jdbc/oracle/OracleSpatialDriver.java
| OracleSpatialDriver.java | ||
|---|---|---|
| 2842 | 2842 |
*/ |
| 2843 | 2843 |
public static String getMetadataUpdateSql(String schema, String tName, String ora_srid, |
| 2844 | 2844 |
Rectangle2D bbox, int dim, boolean withsrid) {
|
| 2845 |
|
|
| 2845 | 2846 |
String[] dim_name = new String[dim]; |
| 2846 | 2847 |
double tolerance = 0.5; |
| 2847 | 2848 |
|
| ... | ... | |
| 2861 | 2862 |
} |
| 2862 | 2863 |
} |
| 2863 | 2864 |
} |
| 2864 |
|
|
| 2865 |
|
|
| 2866 |
double minx = bbox.getMinX(); |
|
| 2867 |
double miny = bbox.getMinY(); |
|
| 2868 |
double maxx = bbox.getMaxX(); |
|
| 2869 |
double maxy = bbox.getMaxY(); |
|
| 2870 |
|
|
| 2865 | 2871 |
String resp = "INSERT INTO " + ORACLE_GEOMETADATA_VIEW + " " + |
| 2866 | 2872 |
" ( OWNER, TABLE_NAME, COLUMN_NAME, DIMINFO, SRID ) " + " VALUES ("
|
| 2867 | 2873 |
+ "'" + schema + "', " |
| 2868 | 2874 |
+ "'" + tName + "', " |
| 2869 | 2875 |
+ "'" + DEFAULT_GEO_FIELD + "', " + |
| 2870 | 2876 |
"MDSYS.SDO_DIM_ARRAY( " + "MDSYS.SDO_DIM_ELEMENT ('" + dim_name[0] + "', " +
|
| 2871 |
bbox.getMinX() + ", " + bbox.getMaxX() + ", " + tolerance + " ), " +
|
|
| 2872 |
"MDSYS.SDO_DIM_ELEMENT ('" + dim_name[1] + "', " + bbox.getMinY() + ", " +
|
|
| 2873 |
bbox.getMaxY() + ", " + tolerance + " ))";
|
|
| 2877 |
minx + ", " + maxx + ", " + tolerance + " ), " +
|
|
| 2878 |
"MDSYS.SDO_DIM_ELEMENT ('" + dim_name[1] + "', " + miny + ", " +
|
|
| 2879 |
maxy + ", " + tolerance + " ))";
|
|
| 2874 | 2880 |
|
| 2875 | 2881 |
if (dim > 2) {
|
| 2876 | 2882 |
resp = resp.substring(0, resp.length() - 1) + ","; |
Also available in: Unified diff