private ResultSet getColumnsResultSet(Table table) throws SQLException { ResultSet columnRs = null; if (table.getOwnerSynonymName() != null) { columnRs = getMetaData() .getColumns(getCatalog(), table.getOwnerSynonymName(), table.getSqlName(), null); } else { columnRs = getMetaData().getColumns(getCatalog(), getSchema(), table.getSqlName(), null); } return columnRs; }
private List<String> getTablePrimaryKeys(Table table) throws SQLException { // get the primary keys List primaryKeys = new LinkedList(); ResultSet primaryKeyRs = null; if (table.getOwnerSynonymName() != null) { primaryKeyRs = getMetaData() .getPrimaryKeys(getCatalog(), table.getOwnerSynonymName(), table.getSqlName()); } else { primaryKeyRs = getMetaData().getPrimaryKeys(getCatalog(), getSchema(), table.getSqlName()); } while (primaryKeyRs.next()) { String columnName = primaryKeyRs.getString("COLUMN_NAME"); GLogger.trace("primary key:" + columnName); primaryKeys.add(columnName); } primaryKeyRs.close(); return primaryKeys; }
private void retriveTableColumns(Table table) throws SQLException { GLogger.trace("-------setColumns(" + table.getSqlName() + ")"); List primaryKeys = getTablePrimaryKeys(table); table.setPrimaryKeyColumns(primaryKeys); // get the indices and unique columns List indices = new LinkedList(); // maps index names to a list of columns in the index Map uniqueIndices = new HashMap(); // maps column names to the index name. Map uniqueColumns = new HashMap(); ResultSet indexRs = null; try { if (table.getOwnerSynonymName() != null) { indexRs = getMetaData() .getIndexInfo( getCatalog(), table.getOwnerSynonymName(), table.getSqlName(), false, true); } else { indexRs = getMetaData().getIndexInfo(getCatalog(), getSchema(), table.getSqlName(), false, true); } while (indexRs.next()) { String columnName = indexRs.getString("COLUMN_NAME"); if (columnName != null) { GLogger.trace("index:" + columnName); indices.add(columnName); } // now look for unique columns String indexName = indexRs.getString("INDEX_NAME"); boolean nonUnique = indexRs.getBoolean("NON_UNIQUE"); if (!nonUnique && columnName != null && indexName != null) { List l = (List) uniqueColumns.get(indexName); if (l == null) { l = new ArrayList(); uniqueColumns.put(indexName, l); } l.add(columnName); uniqueIndices.put(columnName, indexName); GLogger.trace("unique:" + columnName + " (" + indexName + ")"); } } } catch (Throwable t) { // Bug #604761 Oracle getIndexInfo() needs major grants // http://sourceforge.net/tracker/index.php?func=detail&aid=604761&group_id=36044&atid=415990 } finally { dbHelper.close(indexRs, null); } List columns = getTableColumns(table, primaryKeys, indices, uniqueIndices, uniqueColumns); for (Iterator i = columns.iterator(); i.hasNext(); ) { Column column = (Column) i.next(); table.addColumn(column); } // In case none of the columns were primary keys, issue a warning. if (primaryKeys.size() == 0) { GLogger.warn( "WARNING: The JDBC driver didn't report any primary key columns in " + table.getSqlName()); } }