aspose file tools
The moose likes JDBC and Relational Databases and the fly likes foreign keys Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "foreign keys" Watch "foreign keys" New topic
Author

foreign keys

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
Hi,
I am using DatabaseMetaData.getImportedKeys() to get the foreign keys of a table. I am using sybase and the jdbc driver provided by it. My problem is this method is not returning the foreign keys for some tables. But it is working fine if I change the driver to odbc driver and use the jdbc-odbc bridge.What could be the reason for these differences? I think this is the best way to get the foreign keys. Can anyone help me out of this??
Thanx in advance,
shankar.

 
Don't get me started about those stupid light bulbs.
 
subject: foreign keys