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
|
