Skip site navigation (1) Skip section navigation (2)

Cannot pass null in Parameter in Query for ISNULL

From: Bernard <bht237(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Cannot pass null in Parameter in Query for ISNULL
Date: 2012-04-22 04:50:12
Message-ID: of37p7pknemd5rl4vmr0rnfm772h81pfo9@4ax.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

We have a driver issue with postgresl that doesn't exist with other
databases.

It happens with Java JPA implementations when a very simple query is
executed like:

SELECT a FROM Author a WHERE :lastName IS NULL OR LOWER(a.lastName) =
:lastName

See
http://en.wikipedia.org/wiki/Java_Persistence_Query_Language#Examples

:lastName is a parameter, and the null check is on the parameter so
there shouldn't be a problem with this at all.

Maciek has suggested a solution for this driver issue at
http://archives.postgresql.org/pgsql-jdbc/2011-12/msg00017.php

I wonder when this could be resolved? Apparently there is a related
back-end issue.

I have a few JUnit test for this so please ask.

Kind Regards,

Bernard



pgsql-jdbc by date

Next:From: Dave CramerDate: 2012-04-22 09:33:04
Subject: Re: Cannot pass null in Parameter in Query for ISNULL
Previous:From: BernardDate: 2012-04-22 00:57:59
Subject: Cannot pass null in Parameter in Query for ISNULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group