Re: Postgresql JDBC driver compliance

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Kelvin SIN <ksin(at)students(dot)cs(dot)mu(dot)oz(dot)au>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Postgresql JDBC driver compliance
Date: 1998-08-05 17:30:56
Message-ID: Pine.LNX.3.96.980805182328.13326M-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Thu, 6 Aug 1998, Kelvin SIN wrote:

> Hi Peter,
>
> According to the JDBC documentation from java.sun.com, a JDBC driver is
> JDBC compliant if it is SQL 92 complaint and passes the JDBC compliance
> test. I think Postgresql is a subset of SQL92, but is it still JDBC
> compliant?

It isn't yet for two reasons:

1) CallableStatement is not implemented at all yet

2) I'm not sure if it would be compliant as we only support a subset of
SQL92.

> I am working in a client server project that connects to
> postgresql and I need to find out how many of the JDBC APIs can be used,
> especially the getCursor() method under the Connection class. Thanks.

Currently getCursor() simply returns the string passed to the Connection
by the setCursor() method.

I think that (in JDBC) cursors need looking into.

--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter T Mount 1998-08-05 17:45:12 Re: [INTERFACES] JDBC:postgresql and Symantec Visual Cafe
Previous Message Matthew Hagerty 1998-08-05 17:16:20 postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?