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@postgresql.org
> > 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)