Revision 13993

View differences:

branches/v10/extensions/extOracleSpatial/src/es/prodevelop/cit/gvsig/fmap/drivers/jdbc/oracle/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