Re: Update on new driver progress

From: Florent Guillaume <fg(at)nuxeo(dot)com>
To: Kevin Wooten <kdubb(at)me(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Update on new driver progress
Date: 2013-04-08 12:28:53
Message-ID: CAF-4BpN2v4Zcb9yOMVTJtXyjcO_Kn4tMzVtrg-2VcteVNeMBaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thanks for the update.

Florent

On Mon, Apr 8, 2013 at 12:54 PM, Kevin Wooten <kdubb(at)me(dot)com> wrote:
> Thought I'd give an update for those who are interested. Work has progressed nicely and I have been migrating the original project's unit tests to attempt to reach some level of compatibility between the implementations. Currently about 80% of the unit test have been migrated and only 6 the test are not passing. The failing or erring tests are mostly due to, as yet uncommitted to differences, in the way the drivers work; once permanent decisions are made the driver will be fixed to conform or the test will be updated. Up until now the focus has been on features and conformance but I will be departing from that for a bit to do some performance analysis and enhancement before adding any new features.
>
> Here is an outline of the major things…
>
> Location
> * https://github.com/kdubb/pgjdbc-ng
>
> Requirements
> * 9.0 Server (may need to be 9.2 right now as 9.0 and 9.1 have not been tested much at all)
> * Java 7 / JDBC 4.1
>
> Dependencies
> * Reduced external dependencies to Netty and Google Guava.
> * Maven build (mvn package) produces a jar with dependencies
>
> Notable Supported Features
> * UDT's through standard SQLData, SQLInput/SQLOutput and also Struct. This includes arrays and composites of UDT's ad infinitum
> * Custom type mappings - Connection.setTypeMap, ResultSet.getObject(idx, typeMap)
> * Pluggable serialization support (using java service mechanism and proprietary interfaces)
> * Binary format preference with Text mode fallback
> * All Database and Parameter meta data
> * Transactions / Savepoints
> * Blobs
>
> Notable Unsupported Features
> * Multiple Statements in a PreparedStatement (e.g ."SELECT ?; SELECT 2; SELECT ?"). This so far this has been conscious decision not to support this because it seems to give the illusion of preparation when the server in fact doesn't support preparing multiple statements. Multiple statements are allowed in regular Statements.
> * SSL; will be implemented very soon
> * Callable statements; will be implemented in the near future
> * Cursors; will be implemented sometime in the future
> * Updatable ResultSets; will be implemented sometime in the future
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc

--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Dunstan 2013-04-08 14:25:52 Re: Publish artifacts to Maven central
Previous Message Kevin Wooten 2013-04-08 10:54:37 Update on new driver progress