Re: Postgres JDBC3 driver compliance

Ian Howlett wrote:
> Hello,
>
> I wonder if someone can tell me how compliant the new (14 Jan 2003) Postgres
> JDBC 3 driver is with the JDBC 3 standard.
>

In general the jdbc spec is self documenting via the DatabaseMetaData
class. The spec requires methods in this class that detail which
functionality a database supports. You should also realize that being
compliant with the spec doesn't imply that all functionality is
supported. A fully compliant driver could implement vary little
functionality.

> In particular, does it support
> * Reusue of prepared statements by connection pools

What part of the jdbc spec are you talking about here? I am not aware
of any jdbc features on reusing prepared statements.

> * Retrieval of auto-generated keys

No. The currently is know way to do this in postgres. Until the
database itself adds this functionality the driver cannot implement it.

> * Ability to have multiple open ResultSet objects

This has always been supported.

>
> I can't seem to find any documentation on the state of the JDBC driver code.
> If anyone has any useful links etc then please let me know.

Contributions to improve the documentation are always welcome.

>
> Kind regards,
> Ian
>

thanks,
--Barry