Re: setUseServerPrepare & typecasts - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: setUseServerPrepare & typecasts
Date
Msg-id 1037270254.5146.66.camel@inspiron.cramers
Whole thread Raw
In response to Re: setUseServerPrepare & typecasts  (Felipe Schnack <felipes@ritterdosreis.br>)
List pgsql-jdbc
Well, in postgres it certainly isn't necessary, however I would suspect
that one of the vendors that was involved in creating the spec required
it.

Dave
On Thu, 2002-11-14 at 04:59, Felipe Schnack wrote:
>   I never understood why I have to specify a data type when setting a
> column to NULL in jdbc's PreparedStatement.setNull() method. Someone can
> explain to me?
>
> On Wed, 2002-11-13 at 23:57, Aaron Mulder wrote:
> > On Wed, 13 Nov 2002, Scott Lamb wrote:
> > > Ahh, but the JDBC 3.0 specification does. Section 13.2.2.3 says "if a
> > > Java null is passed to any of the setter methods that take a Java
> > > object, the parameter will be set to JDBC NULL". So it should work.
> >
> >     Oops, you're right.  I had it in my head that you _had_ to use
> > setNull, but I see that's not really required.
> >
> > Aaron
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
--
Dave Cramer <Dave@micro-automation.net>


pgsql-jdbc by date:

Previous
From: Felipe Schnack
Date:
Subject: Re: setUseServerPrepare & typecasts
Next
From: Barry Lind
Date:
Subject: Re: setUseServerPrepare & typecasts