I have an app with a CachedRowSetImpl that reads from a MySQL database (using "com.mysql.jdbc.Driver")
I'm passing the RowSet a prepared statement that looks like this:
...and then setting the parameter with setString, setInt, etc... I'm using the LIKE operater to allow me to enter the '%' wildcard into the parameter.
The only place where its falling down is when I try to select NULL fields. Using setNULL does not work as MySQL treats NULL differently from other databases. The usual way to execute a clause on NULL is
...but using the 'LIKE' or '=' operators fails when used with NULL under MySQL.
So is there any way I can put a WHERE clause on a column with a NULL value using a PreparedStatement like I have above?