| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2012-04-22 09:33:04 | Re: Cannot pass null in Parameter in Query for ISNULL |
| Previous Message | Bernard | 2012-04-22 00:57:59 | Cannot pass null in Parameter in Query for ISNULL |