public void refreshColumns(DatabaseMetaData metaData) throws SQLException { columns.clear(); ResultSet rs = null; try { rs = metaData.getColumns(catalog, schema, name, null); while (rs.next()) { Column column = new Column(); columns.add(column); column.setOwner(this); column.setName(rs.getString("COLUMN_NAME")); column.setDataType(rs.getInt("DATA_TYPE")); column.setTypeName(rs.getString("TYPE_NAME")); column.setSize(rs.getInt("COLUMN_SIZE")); column.setDecimalDigits(rs.getInt("DECIMAL_DIGITS")); column.setRadix(rs.getInt("NUM_PREC_RADIX")); column.setNullable(rs.getInt("NULLABLE")); column.setRemarks(rs.getString("REMARKS")); column.setDefaultValue(rs.getString("COLUMN_DEF")); column.setCharOctetLength(rs.getInt("CHAR_OCTET_LENGTH")); column.setOrdinalPosition(rs.getInt("ORDINAL_POSITION")); } } catch (SQLException sqle) { throw sqle; } finally { try { rs.close(); } catch (Exception ex) { } } }
int inSize = graph.incomingSize(vertex); if (outSize != 0 || (outSize == 0 && inSize == 0)) { Column pkColumn = new Column(); pkColumn.setName(table.getName() + "_ID"); pkColumn.setTypeName("INTEGER"); pkColumn.setNullable(DatabaseMetaData.columnNoNulls); table.addColumn(pkColumn); PrimaryKey pk = new PrimaryKey(pkColumn); Column fkColumn = new Column(); fkColumn.setName(pkColumnName + fkColumnSuffix); fkColumn.setTypeName("INTEGER"); fkColumn.setNullable(DatabaseMetaData.columnNoNulls); table.addColumn(fkColumn); if (outSize == 0) {
for (Iterator<Column> i = columns.iterator(); i.hasNext();) { Column c = i.next(); out.print(" " + c.getName() + " " + c.getTypeName()); if (c.getNullable() == DatabaseMetaData.columnNoNulls) out.print(" NOT NULL"); if (i.hasNext())