Re: Trouble with NULL

Hi Hoanui,

= NULL and IS NULL are not the same thing :) Don't you see that you are
using completely different SQL statements in the java example and in
the query above it? You should always use the IS NULL version when you
want to see if something is null, comparing to NULL doesn't work.

Also, the parameterIndex in the PreparedStatement.set() methods below
should be numbered from 1. 0 is out of range.

Tom.

On Mon, May 06, 2002 at 04:55:55AM -0400, Hoanui Morangie wrote:
> Hi,
>
> could anybody help me please with the following problem: I am using Postgres 7.2 on Mandrake Linux 8.2 with JDK 1.4. My table:
>
>
> create table data
> (
> id text primary key,
> ...
> variant_id text null,
> ...
> );
>
>
> Query: select * from data where variant_id is null;
> works fine - selects one row.
>
> In my java code:
>
>
> ...
> String query = "select * from data where variant_id = ?";
> ...
> PreparedStatement pstmt = con.PrepareStatement(query);
> if (parameter == null)
> {
> pstmt.setNull(0, java.sql.Types.VARCHAR);
> }
> else
> {
> pstmt.setObject(0, parameter);
> }
> ...
>
>
> It works if the parameter is not null. If the parameter is null query returns no row (should return one). What's wrong?
>
> Thank you
>
> Hoanui
>
> ------------------------------------------------
> Join Excite! - http://www.excite.com
> The most personalized portal on the Web!

--
Thomas O'Dowd. - Nooping - http://nooper.com
tom(at)nooper(dot)com - Testing - http://nooper.co.jp/labs