Menu

#4 Duplicate Column Names

open
nobody
None
5
2001-04-19
2001-04-19
Anonymous
No

When importing a table from a database that has
duplicate tables in different schemas, the table
definition tab contains duplicate columns (same table
definition in different schemas).

The Fix:

In the MetaImporter.java file in the
public Table getTable(String tableName) method
replace the result set line
//rs = md.getColumns(getCatalog(), null,
tableName, null);

with this (added getSchema() in the second parameter)

rs = md.getColumns(getCatalog(), getSchema(),
tableName, null);

p.s. I was using the oracle jdbc driver
(classes12_01.zip)

Discussion


Log in to post a comment.

MongoDB Logo MongoDB