Обсуждение: Postgres JDBC3 driver compliance

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 particular, does it support
* Reusue of prepared statements by connection pools
* Retrieval of auto-generated keys
* Ability to have multiple open ResultSet objects

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.

Kind regards,
Ian

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

See http://jxdbcon.sourceforge.net/


Barry Lind wrote:
>
>
> 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
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>