[DDLUTILS-239] NullPointerException in JdbcModelReader.readTable (fix included)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0
• Component/s: Core (No specific database)
• Environment: Oracle 9i with nested tables
• Assignee: Thomas Dudziak
• Reporter: Dave Lindsey
• Created: 04/Feb/09 02:26
• Updated: 04/Feb/09 02:26

Description

JdbcModelReader

protected Table readTable(DatabaseMetaDataWrapper metaData, Map values) throws SQLException

for (Iterator it = primaryKeys.iterator(); it.hasNext()

{ table.findColumn((String)it.next(), true).setPrimaryKey(true); }

This happens on Oracle 9i, but it could happen with other dbs.
There are inner tables which have no columns, but do have a PKs defined.

findColumn() returns null and the code tries to set a value on it

To get past this:

for (Iterator it = primaryKeys.iterator(); it.hasNext() {
String pk = (String)it.next();
Column col = table.findColumn(pk, true);
if(col == null)

{continue;}

col.setPrimaryKey(true);
// table.findColumn((String)it.next(), true).setPrimaryKey(true);
}

I'm not sure what a this means for the the xml output.
IMO, a comment should be added to xml output stating what was skipped.

Thanks, Dave