[Hibernate-issues] [Hibernate-JIRA] Created: (HB-433) Allow to bind null parameters to the query

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-433


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-433
    Summary: Allow to bind null parameters to the query
       Type: Improvement

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.1 beta 1
             2.1 beta 2
             2.1 final
             2.1 beta 4
             2.1 beta 5

   Assignee: 
   Reporter: Giedrius Trumpickas

    Created: Wed, 29 Oct 2003 12:15 PM
    Updated: Wed, 29 Oct 2003 12:15 PM

Description:

SELECT p FROM Person AS p WHERE ((? is null) OR (p.firstname = ?)) AND ((? is null) OR (p.lastname = ?))

This query assumes that person can be searched by firstname, lastname or both. Right now hibernate throws NullPointerException when I'm trying to bind null parameter because it tries to guess parameter type and ...
Maybe in Hibernate we need to introduce NullType for scalar values ? 

Reason for such funcionality is to have dynamic searches from UI when user can enter bunch of search parameters and not all parameters are required.

PS:

I know that query above can be expressed by search criteria but this is just an example real query is more complicated and it can not be expressed with Criteria.


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira