Can't get foreign key using JAVA DatabaseMetaData

Question

i want get foreign key using java DatabaseMetaData and tried.
but i got just foreign key referring pk column and couldn't get referring unique column.
i tried using getCrossReference(), getImportedKeys() pattern and same result.

here is my code and DB is Oracle11g.

    ResultSet rset = databaseMetaData.getImportedKeys(null, dbName, tableName);

    while(rset.next()){
      String column_name = rset.getString("FKCOLUMN_NAME");
      String pk_table = rset.getString("PKTABLE_NAME");
      String pk_column = rset.getString("PKCOLUMN_NAME");
      String constraint_name = rset.getString("FK_NAME");

      System.out.println(column_name + " ==> " + pk_column + "(TBL:" + pk_table + ")(CN:" + constraint_name + ")");
    }
    rset.close();

the table has two foreign keys (one is referring pk column, another is referring unique column) but i got just one log.
is there any mistakes ?
thanks.

@bellabax : thank you bellabax. i tried and got same result. — user3273956, Feb 06 '14 at 04:27
now, i think whether it is just for foreign key for PK but i can't find description about that. : — user3273956, Feb 06 '14 at 04:27

score 0 · Answer 1 · answered Oct 23 '18 at 08:51

to get referring unique column you have to use PKCOLUMN_NAME in the getString

 rset.getString("PKCOLUMN_NAME");

here are the complite code :

ResultSet rset = databaseMetaData.getImportedKeys(null, dbName, tableName);

while(rset.next()){
    String column_name = rset.getString("FKCOLUMN_NAME");
    String pk_table = rset.getString("PKTABLE_NAME");
    String pk_column = rset.getString("PKCOLUMN_NAME");
    String constraint_name = rset.getString("PKCOLUMN_NAME");      
    System.out.println("  "+column_name+" reference to "+ pk_table+"("+constraint_name+")");             
}
rset.close();

Can't get foreign key using JAVA DatabaseMetaData

1 Answers1