private DataType readDataType(com.healthmarketscience.jackcess.Column originalColumn) throws SQLException { return factory.createDataType(originalColumn.getSQLType()); } }
@Override protected Schema getMainSchema() throws MetaModelException { Schema schema = new Schema(_file.getName()); Database db = getDatabase(); for (com.healthmarketscience.jackcess.Table mdbTable : db) { Table table = new Table(mdbTable.getName(), TableType.TABLE, schema); try { int i = 0; for (com.healthmarketscience.jackcess.Column mdbColumn : mdbTable .getColumns()) { ColumnType columnType = ColumnType .convertColumnType(mdbColumn.getSQLType()); Column column = new Column(mdbColumn.getName(), columnType, table, i, null); column.setColumnSize((int) mdbColumn.getLength()); column.setNativeType(mdbColumn.getType().name()); table.addColumn(column); i++; } schema.addTable(table); } catch (Exception e) { throw new MetaModelException(e); } } return schema; }
@Override protected Schema getMainSchema() throws MetaModelException { MutableSchema schema = new MutableSchema(_file.getName()); Database db = getDatabase(); for (com.healthmarketscience.jackcess.Table mdbTable : db) { final MutableTable table = new MutableTable(mdbTable.getName(), TableType.TABLE, schema); try { int i = 0; for (com.healthmarketscience.jackcess.Column mdbColumn : mdbTable.getColumns()) { final ColumnType columnType = ColumnType.convertColumnType(mdbColumn.getSQLType()); final MutableColumn column = new MutableColumn(mdbColumn.getName(), columnType, table, i, null); column.setColumnSize((int) mdbColumn.getLength()); column.setNativeType(mdbColumn.getType().name()); table.addColumn(column); i++; } final Index primaryKeyIndex = mdbTable.getPrimaryKeyIndex(); final List<ColumnDescriptor> columnDescriptors = primaryKeyIndex.getColumns(); for (ColumnDescriptor columnDescriptor : columnDescriptors) { final String name = columnDescriptor.getColumn().getName(); final MutableColumn column = (MutableColumn) table.getColumnByName(name); column.setPrimaryKey(true); } schema.addTable(table); } catch (Exception e) { throw new MetaModelException(e); } } return schema; }