con = getConnection();
DatabaseMetaData dbMD = con.getMetaData();
Table A = DBSchemaHelper.getTable(dbMD, aTableName);
assertEquals(1, A.getColumnsNumber());
Column aId = A.getColumn("ID");
aId.assertTypeNotNull(Types.INTEGER, true);
Table B = DBSchemaHelper.getTable(dbMD, bTableName);
assertEquals(1, B.getColumnsNumber());
Column bId = B.getColumn("ID");
bId.assertTypeNotNull(Types.INTEGER, true);
Table AB = DBSchemaHelper.getTable(dbMD, abTableName);
assertEquals(AB.getColumnsNumber(), 2);
Column aFk = AB.getColumn(aTableName);
aFk.assertTypeNotNull(Types.INTEGER, true);
Column bFk = AB.getColumn(bTableName);
bFk.assertTypeNotNull(Types.INTEGER, true);
}
finally
{
DBSchemaHelper.safeClose(con);
}