[DDLUTILS-229] writedatatofile Ant task not using the database model and retrieves all db objects ignoring the schema pattern

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0
• Fix Version/s: 1.1
• Component/s: Ant Tasks
• Environment: Windows/Linux
• Assignee: Thomas Dudziak
• Reporter: Madhu Krishna
• Created: 30/Oct/08 15:34
• Updated: 05/Nov/08 20:34
• Resolved: 05/Nov/08 20:34

Description

The database model <database> specified with schema pattern <databaseToDdl> is never used in <writedatatofile> Ant task code.
Instead, the whole database is read again ignoring the vital parameters like schemapattern as below. (WriteDataToFileCommand.java - Line 88)

getDataIO().writeDataToXML(getPlatform(),
new FileOutputStream(_outputFile), _encoding);

This creates many problems in Oracle db by retrieving all user objects.

Suggested Fix: The database model should be passed invoking the right method as shown below
~~~~~~~~~~~~
public void execute(DatabaseTaskBase task, Database model) throws BuildException
{
try

{ //getDataIO().setDetermineSchema(_determineSchema); //getDataIO().setSchemaPattern(task.getPlatformConfiguration().getSchemaPattern()); getDataIO().writeDataToXML(getPlatform(), model, new FileOutputStream(_outputFile), _encoding); _log.info("Written data XML to file" + _outputFile.getAbsolutePath()); }

catch (Exception ex)

{ handleException(ex, ex.getMessage()); }

}