From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | "'Ashvin Lad'" <akl98(at)doc(dot)ic(dot)ac(dot)uk>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Foreign Keys and getImportedKeys(..) |
Date: | 2002-01-31 19:24:41 |
Message-ID: | 041401c1aa8c$eeb18800$c201a8c0@inspiron |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
You can get this functionality out of the new driver. It can be found at
http://jdbc.postgresql.org
Dave
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Ashvin Lad
Sent: Thursday, January 31, 2002 1:29 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Foreign Keys and getImportedKeys(..)
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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Amanda K. Martino | 2002-01-31 19:40:36 | No suitable driver found exception |
Previous Message | Ashvin Lad | 2002-01-31 18:29:28 | Foreign Keys and getImportedKeys(..) |