You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Janssen, Roger" <Ro...@ibanx.nl> on 2003/04/09 16:53:32 UTC

RE: rc2, possible bug, count throws nullpointerexceptoin when no records found

>hi roger,
>
>what does the query look like ?
>
>jakob
>

i do believe i have found the cause, ID is an integer field and the
generated query has the clause :  WHERE A0.ID >  '1' 
this should be : WHERE A0.ID >  1 

i did use an Integer value with the Criteria object, so that can not be the
root cause.

the trace is below:

1049899711390|15|0|statement|SELECT count(distinct A0.ID) FROM IBANX_PERMIT
A0 WHERE A0.ID >  ? |SELECT count(distinct A0.ID) FROM IBANX_PERMIT A0 WHERE
A0.ID >  '1' 
1049899711390|0|0|rollback||


roger janssen
iBanx


*************************************************************************
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to  whom it is
addressed.You should not copy, disclose or distribute this communication 
without the authority of iBanx bv. iBanx bv is neither liable for 
the proper and complete transmission of the information has been maintained
nor that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.