Revision 13993 branches/v10/extensions/extOracleSpatial/src/es/prodevelop/cit/gvsig/fmap/drivers/jdbc/oracle/OracleSpatialDriver.java
OracleSpatialDriver.java | ||
---|---|---|
168 | 168 |
// ------------------------------------------------ |
169 | 169 |
public static final String NAME = "Oracle Spatial Database Driver"; |
170 | 170 |
public static final int ID_COLUMN_INDEX = 1; |
171 |
public static final String ORACLE_GEOMETADATA_VIEW = "USER_SDO_GEOM_METADATA";
|
|
171 |
public static final String ORACLE_GEOMETADATA_VIEW = "ALL_SDO_GEOM_METADATA";
|
|
172 | 172 |
public static final String ORACLE_EPSG_TABLE_NAME = "ORA_EPSG"; |
173 | 173 |
public static final String ORACLE_EPSG_FILE_NAME = "ora_epsg.dbf"; |
174 | 174 |
public static final String DEFAULT_GEO_FIELD = "GEOMETRY"; |
... | ... | |
3757 | 3757 |
ResultSet rs = null; |
3758 | 3758 |
rs = getTableNamesFromTable(dbmd.getTables(catalog, ORACLE_GEO_SCHEMA, |
3759 | 3759 |
ORACLE_GEOMETADATA_VIEW, types), conn); |
3760 |
|
|
3760 |
// rs = dbmd.getTables(catalog, ORACLE_GEO_SCHEMA, |
|
3761 |
// ORACLE_GEOMETADATA_VIEW, types); |
|
3761 | 3762 |
TreeMap ret = new TreeMap(); |
3762 | 3763 |
|
3763 | 3764 |
while (rs.next()) { |
... | ... | |
3784 | 3785 |
String sql = "(" + "(select TABLE_NAME from USER_TABLES) " + |
3785 | 3786 |
"union (select VIEW_NAME from USER_VIEWS)) " + |
3786 | 3787 |
"intersect (select TABLE_NAME from " + tablename + ")"; |
3788 |
sql = "SELECT TABLE_NAME FROM " + tablename + ""; |
|
3787 | 3789 |
ResultSet rs = __st.executeQuery(sql); |
3788 | 3790 |
|
3789 | 3791 |
return rs; |
Also available in: Unified diff