Re: PreparedStatement - Dirk Hillbrecht - com.mysql.lists.java

8 messages in com.mysql.lists.javaRe: PreparedStatement

From	Sent On	Attachments
Mike Smith	22 Jun 2001 10:57
Neelesh	23 Jun 2001 05:32
Mike Smith	25 Jun 2001 08:04
Igor Fedulov	25 Jun 2001 09:30
mmat...@thematthews.org	25 Jun 2001 11:10
Igor Fedulov	25 Jun 2001 11:34
Dirk Hillbrecht	25 Jun 2001 11:47
Piero Tintori	26 Jun 2001 09:11

Subject:	Re: PreparedStatement
From:	Dirk Hillbrecht (dh...@chitec.de)
Date:	06/25/2001 11:47:14 AM
List:	com.mysql.lists.java

Hi all,

well above will return me nothing cuz "a2=null" have to be "a2 is null".

This is an issue with parameterized statements in general. [...]

Is that really a problem? I remember that earlier I always used the test "where xy=null" without any problems in MySQL. Then, we started to port our application to work on MySQL _and_ Oracle and on that occasion, I had to change the statement into "where xy is null", because Oracle couldn't parse and work with the first alternative.

Today, I always use the "is null" version. And as I use PreparedStatements only for exchanging BLOBs, _that_ very problem never occured for me.