| From: | Ashvin Lad <akl98(at)doc(dot)ic(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Foreign Keys and getImportedKeys(..) |
| Date: | 2002-01-31 18:29:28 |
| Message-ID: | 3C598D08.7020608@doc.ic.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi All,
After getting a metadata object from a PostgreSQL connection, I can use
the getPrimaryKeys() method
to display a table's primary keys but I can't use the getImportedKeys()
method to get its foreign keys. Can anyone help?
This works:
ResultSet pksRS = dbmd.getPrimaryKeys(null, null, tableName);
while(pksRS.next())
{
... pksRS.getString("COLUMN_NAME");
}
But this does not:
ResultSet fksRS = dbmd.getImportedKeys(null, null, tableName);
while(fksRS.next())
{
... fksRS.getString("FKCOLUMN_NAME");
}
I get a NullPointerException because fksRS is null, but I don't know why.
This is not the case when I use MS SQL Server...it does work.
Is this because the JDBC driver provided with PostgreSQL doesn't support
this function?
Thanks,
Ash.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-01-31 19:24:41 | Re: Foreign Keys and getImportedKeys(..) |
| Previous Message | Barry Lind | 2002-01-31 17:39:28 | Re: getConnection() method of PreparedStatement |