Re: setObject on PGInterval throws "Unknown Type null" - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: setObject on PGInterval throws "Unknown Type null"
Date
Msg-id 41F6D3EC.5000103@opencloud.com
Whole thread Raw
In response to Re: setObject on PGInterval throws "Unknown Type null"  (Kris Jurka <books@ejurka.com>)
Responses Re: setObject on PGInterval throws "Unknown Type null"  (Kris Jurka <books@ejurka.com>)
Fix for changing parameter types with server prepared statements (was Re: setObject on PGInterval throws "Unknown Type null")  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Kris Jurka wrote:

> For non-null values we need the
> strong typing to ensure that we don't send data in a different format than
> the server expects, but this is not an issue with nulls.

What about when we prepare a statement with a null parameter, then later
use it with a non-null parameter? There is some protocol code needed
here to get the inferred types back.

We currently break in the case where parameter types change between
executions, but that's more easily fixable since we have all the
necessary information already available.

-O

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: setObject on PGInterval throws "Unknown Type null"
Next
From: Kris Jurka
Date:
Subject: Re: setObject on PGInterval throws "Unknown Type null"