Oracle is funny that way. Different results may occur
for
b=null
and
b is null
In OraLogic, null is an unknown value, and hence is
never equal to anything.
--- "Rupp, Heiko" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I just encounter a different result from a finder
>
> Collection findFoo(String a, String b)
> "select object o from xxx where o.a=?1 and o.b=?2"
>
> with a="test" b=null
>
> hsql 1.7.1 with its driver does the expected thing
> and find a record ("test", null)
> while Oracle9i with its thin driver doesn't find the
> same record.
>
> Any hint here?
> This is with JBoss 3.2.1 and 3.2.3
>
> Thanks
> Heiko
>
>
> --
> Heiko W. Rupp EMail:
> [EMAIL PROTECTED]
> Senior Consultant Telefon: +49 711 222
> 992 - 900
> Cellent AG Finance Solutions Telefax: +49 711 222
> 992 - 999
> Calwer Str. 33 D-70173 Stuttgart
>
>
>
-------------------------------------------------------
> This SF.net email is sponsored by: IBM Linux
> Tutorials.
> Become an expert in LINUX or just sharpen your
> skills. Sign up for IBM's
> Free Linux Tutorials. Learn everything from the
> bash shell to sys admin.
> Click now!
> http://ads.osdn.com/?ad_id78&alloc_id371&op=click
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
>
https://lists.sourceforge.net/lists/listinfo/jboss-user
=====
Nicholas Whitehead
Home: (973) 377 9335
Cell: (201) 615 2716
[EMAIL PROTECTED]
Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
