Problem with setNull()

Поиск
Список
Период
Сортировка
Искать

Problem with setNull()

От:
"Robert M. Zigweid" <rzigweid@securesoftware.com>
Дата:
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

Re: Problem with setNull()

От:
"Robert M. Zigweid" <rzigweid@securesoftware.com>
Дата:
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)

Re: Problem with setNull()

От:
Barry Lind <barry@xythos.com>
Дата:
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
>
FAQ