Re: JDBC, prepared queries, and partitioning - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC, prepared queries, and partitioning
Date
Msg-id 47B4326D.3080907@opencloud.com
Whole thread Raw
In response to Re: JDBC, prepared queries, and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: JDBC, prepared queries, and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-jdbc
Simon Riggs wrote:

> Why not just fold in parameters if option is set and can continue to use
> normal V3 route, just with zero parameters? Any JDBC calls that want to
> inspect parameters can throw an exception when the option is set. So
> JDBC thinks there were parameters, yet Postgres server thinks there were
> no parameters.

Well, yes, that's essentially how our protocol-level abstraction works -
the main driver deals in terms of abstracted Query and ParameterList
objects, and the protocol layer maps those to something the server
understands. This is how we support the v2 and v3 protocols in the same
driver. I was suggesting a third protocol path ("v3simple" or something)
that did pretty much what you described .. but I fear you are
underestimating the work needed to implement it.

If you want to put together a patch, though, I'm happy to take a look at it.

-O


pgsql-jdbc by date:

Previous
From: Tomisław Kityński
Date:
Subject: SMALLINT vs short or... int?
Next
From: Oliver Jowett
Date:
Subject: Re: SMALLINT vs short or... int?