Re: Problem with setNull()

My apologies. The information that I was using was flawed. P6spy
incorrectly reported (or modified) what was sent and nulls werre
actually sent. I'm still investigating why the error exception was not
thrown however.

I will investigate and report on this further when I have adequate time.

On Fri, 2002-10-11 at 12:31, Barry Lind wrote:
> Robert,
>
> There isn't enough information here to debug this. Could you provide a
> test case that demonstrates the problem? Also information on what
> versions of the database/driver you are using would be helpful as well.
>
> thanks,
> --Barry
>
>
>
> Robert M. Zigweid wrote:
> > I consider this to be a reasonably major bug. Fortunatly this should be
> > quite easy to fix as well.
> >
> > AbstractJdbc1Statement ignores the SQL type, which is fine, but when
> > actually giving the information to the database, rather than passinga
> > NULL it's passing ''.
> >
> > In particular this doesn't work with the bigint type and an error
> > occurs.
> >
> > What is worse, is that no exception is thrown when this occurs. I have
> > yet to track this particular problem down.
> >
> > Regards,
> >
> >
> > Robert M. Zigweid
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)