Re: stringtype=unspecified problem - Mailing list pgsql-jdbc

From Chris Gamache
Subject Re: stringtype=unspecified problem
Date
Msg-id 9cc55f600702150612p72490c3by95f5998541cf9932@mail.gmail.com
Whole thread Raw
In response to Re: stringtype=unspecified problem  (Kris Jurka <books@ejurka.com>)
Responses Re: stringtype=unspecified problem
List pgsql-jdbc
On 2/14/07, Kris Jurka <books@ejurka.com> wrote:
> Here you're explicitly saying that it is a VARCHAR, not that you have a
> String that you're not sure what the real type is.  It would be possible
> to adjust setNull to check the stringtype setting and use Oid.UNSPECIFIED
> here, but I'm not sure that would be correct.

We've been batting this around in the office as well. I wish I knew
what the absolute correct behavior would be in this situation.

An observation that might be insightful is if I can figure out how

setString(1,null);

differs from

setNull(1,java.sql.Types.VARCHAR);

...

When connected using stringtype=unspecified it would seem to me that
the two should behave the same way. What do you think?

pgsql-jdbc by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Synthesize support for Statement.getGeneratedKeys()?
Next
From: Kris Jurka
Date:
Subject: Re: stringtype=unspecified problem