Ok, looks like hsql is just convenient here while oracle does the "right" thing here as described in the ejb standard in 11.2.9 "two null values are not considered equal ..."
*sigh* > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Rupp, Heiko > Sent: Tuesday, December 09, 2003 6:52 PM > To: JBoss Users (E-Mail) > Subject: [JBoss-user] Jdbc difference oracle <-> hsql > > > 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=ick > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- 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
