[Middlegen-user] Error connection to oracle database.

[Diego Llorente]

Hello. I've found a solution to the problem

The problem it's that we don't close the resultset exportedKeyRs in
markFksToUnwantedTables method of class MiddlegenPopulator

the code may be as follows:

private void markFksToUnwantedTables() throws MiddlegenException {
ResultSet tableRs = null;
try {
tableRs = getMetaData().getTables(_catalog, _schema, null, _types);
while (tableRs.next()) {
String tableName = tableRs.getString("TABLE_NAME");
String tableType = tableRs.getString("TABLE_TYPE");
// ignore the views, they don't have foreign key relationships
if (("TABLE".equals(tableType) &&
!_middlegen.containsTable(tableName)) ||
("SYNONYM".equals(tableType) && isOracle())) {
String ownerSinonimo = null;
if ("SYNONYM".equals(tableType) && isOracle()) {
ownerSinonimo = getSynonymOwner(tableName);
}
ResultSet exportedKeyRs = null;
if (ownerSinonimo != null) {
exportedKeyRs = getMetaData().getExportedKeys(_catalog,
ownerSinonimo, tableName);
}
else {
exportedKeyRs = getMetaData().getExportedKeys(_catalog,
_schema, tableName);
}
while (exportedKeyRs.next()) {
String fkTableName =
exportedKeyRs.getString("FKTABLE_NAME");
String fkColumnName =
exportedKeyRs.getString("FKCOLUMN_NAME");
// Mark the fk field as an fk anyway. This will be useful
for column sorting for example
if (_middlegen.containsTable(fkTableName)) {
DbTable fkTable = _middlegen.getTable(fkTableName);
DbColumn fkColumn =
(DbColumn)fkTable.getColumn(fkColumnName);
fkColumn.setFk(true);
}
}
exportedKeyRs.close();//this is the change
}
}
} catch (SQLException e) {
// schemaRs and catalogRs are only used for error reporting if we
get an exception
String databaseStructure = getDatabaseStructure();
_log.error(e.getMessage(), e);
throw new MiddlegenException("Couldn't get list of tables from
database. Probably a JDBC driver problem." + databaseStructure);
} finally {
try {
tableRs.close();
} catch (Exception ignore) {
}
}
}