Re: Compliance? Plans? - Mailing list pgsql-jdbc

Per-Olof,

Thanks for the constructive feedback.

Let me try to answer your questions:

 > 1. How is the driver compliance tests carried out? The test harness from
 > sun?

The sun test harness has been run.  However the sun test harness is only
for jdbc2 + the enterprise extensions.  As far as I know there isn't a
test suite for plane jdbc2.  Little if any work has been done to support
the enterprise extensions to jdbc2, however a quite a bit of work has
gone into the vanilla jdbc2 stuff.  There is a list of non-compiance
issues at http://lab.applinet.nl/postgresql-jdbc

 >
 > 2. How often is compliance tests carried out?

Not that frequently since we know what the existing issues are and are
working to address them as contributors contribute fixes.

 >
 > 3. Is there a policy for those issues where postgres has limited backend
 > support for the jdbc API functions?
 >

If the server is lacking a feature, this would get added to the general
todo list for the server.  And when that feature is implemented in the
server, then it could be added to the jdbc client.

 > 4. Is there a development plan for the jdbc package, similar to that of
 > the server itself?
 >

Both the server and the jdbc driver have todo lists.  These are as much
of a development plan as exists.  Anyone who wants to contribute can
sign up to do a todo item.  Things get done as volunteers work on todo
items.


 >
 >
 > lastly, while I´m at it :-)
 >
 > Is there a known problem with the implementation of
 > java.sql.Blob.getBinaryStream() implmentation?
 >
 > I get the size of the blob with length() and its correct
 >
 > While reading the Stream I get returncode -1 immediatly
 >
 > server is 7.1.3  jdbc built on jdk 1.3 on linux. Same error appears on
 > win2000 (using the same driver)

I don't know of any bugs in this code.  Do you have a test case you
could submit for someone on the list to look at?

thanks,
--Barry





Per-Olof Norén wrote:

> Hi again all,
>
>
>
> First off, I´d like to declare that my intention is not to be a pain in
> the B** :-)
>
>
>
> Working on customer´s campuses equipped with laptop and a viennaSQL (a
> pure java sql client) i have had
>
> the need for many different drivers for different dbmses. The effort
> involved getting a working jdbc driver
>
> for the dbms at hand has varied; from extremely easy to almost impossible.
>
> As I´m currently promoting postgreSQL as an Orcacle alternative, I have
> been working in parallell with both
>
> drivers and the driver´s compliance to the api differs, which has really
> been a hazzle.
>
>
>
> My questions to the people actively developing the driver is:
>
>
>
> 1. How is the driver compliance tests carried out? The test harness from
> sun?
>
> 2. How often is compliance tests carried out?
>
> 3. Is there a policy for those issues where postgres has limited backend
> support for the jdbc API functions?
>
> 4. Is there a development plan for the jdbc package, similar to that of
> the server itself?
>
>
>
> lastly, while I´m at it :-)
>
> Is there a known problem with the implementation of
> java.sql.Blob.getBinaryStream() implmentation?
>
> I get the size of the blob with length() and its correct
>
> While reading the Stream I get returncode -1 immediatly
>
> server is 7.1.3  jdbc built on jdk 1.3 on linux. Same error appears on
> win2000 (using the same driver)
>
>
>
> Regards,
>
> Per-Olof Norén
>
> Stockholm, Sweden
>