Re: setUseServerPrepare & typecasts

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: setUseServerPrepare & typecasts
Date: 2002-11-14 09:59:43
Message-ID: 1037267984.1520.0.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--

Felipe Schnack
Analista de Sistemas
felipes(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893

Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303328

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-11-14 10:37:34 Re: setUseServerPrepare & typecasts
Previous Message Aaron Mulder 2002-11-14 01:57:27 Re: setUseServerPrepare & typecasts