Re: Postgres JDBC3 driver compliance

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(at)postgresql(dot)org
>