I'm only guessing, but is JBoss generating ... o.b = null ...
? If so, this is invalid SQL. The correct syntax is ... o.b is null ... Maybe the MySQL accepts this (many SQL servers do), but Oracle doesn't? Just a guess. -- Danny Yates -----Original Message----- From: Rupp, Heiko [mailto:[EMAIL PROTECTED] Sent: 09 December 2003 17:52 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=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to external clients any opinions or advice contained in this internet e-mail are subject to the terms and conditions expressed in any applicable governing terms of business or client engagement letter issued by the pertinent Bank of America group entity. If this email originates from the U.K. please note that Bank of America, N.A., London Branch, Banc of America Securities Limited and Banc of America Futures Incorporated are regulated by the Financial Services Authority. ------------------------------------------------------- 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
