Thread: DatabaseMetadata

DatabaseMetadata

From
Tiago Antao
Date:
Hi!

I am doing a project that involves the use of the DatabaseMetadata,
namely I need Foreign keys...
A few things that I have found:
1. PgSQL does not have FK meta-data available for foreign keys as they
are implemented with triggers
2. Accordingly the driver cannot supply meta-data (check eg,
DatabaseMetadata.getImportedKeys), which is correct, but...
3. getImportedKeys always returns a null, which very easely breaks any
JDBC code, as is very far way from what is expected
4. I think the best solution would be to return an empty ResultSet, or
at least raise a SQL Exception (I would favour the first).
5. I could volunteer to try to implement better return for these type of
functions (it seems to be easy), if you agree with my solution just say
and I will try to implement it.

I am stuck with Oracle because of this...

Best regards,
Tiago
PS - I have 7.1.3 source







_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Re: DatabaseMetadata

From
Justin Clift
Date:
Hi Tiago,

You should try the PostreSQL 7.2 JDBC driver, as it has support for
DatabaseMetadata and is backwards compatible with PG 7.1.3.

http://jdbc.postgresql.org

:-)

Regards and best wishes,

Justin Clift


Tiago Antao wrote:
>
> Hi!
>
> I am doing a project that involves the use of the DatabaseMetadata,
> namely I need Foreign keys...
> A few things that I have found:
> 1. PgSQL does not have FK meta-data available for foreign keys as they
> are implemented with triggers
> 2. Accordingly the driver cannot supply meta-data (check eg,
> DatabaseMetadata.getImportedKeys), which is correct, but...
> 3. getImportedKeys always returns a null, which very easely breaks any
> JDBC code, as is very far way from what is expected
> 4. I think the best solution would be to return an empty ResultSet, or
> at least raise a SQL Exception (I would favour the first).
> 5. I could volunteer to try to implement better return for these type of
> functions (it seems to be easy), if you agree with my solution just say
> and I will try to implement it.
>
> I am stuck with Oracle because of this...
>
> Best regards,
> Tiago
> PS - I have 7.1.3 source
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi