Bug in JPQL "SELECT NEW" regarding java.sql.Date type

Description

When using this query :

em.createQuery("Select New MYPACKAGE.Object(o.date)
from Object o");

While the used constructor is the following :

public Object(java.sql.Date date) {
super();
this.date= date;
}

An "Unable to locate appropriate constructor on class" error is caught.

Solved the issue locally by using a cast in the constructor while changing the entry type to java.util.Date :

public Object(java.util.Date date) {
super();
this.date = (java.sql.Date) date;
}

Environment

WampServer 2.4, Hibernate 3.6.0.Final

Activity

Show:
Steve Ebersole
October 27, 2015, 7:16 PM

This bug report does not indicate that the reported issue affects version 5.x. Versions prior to 5.x are no longer maintained. It would be a great help to the Hibernate team and community for someone to verify that the reported issue still affects version 5.x. If so, please add the 5.x version that you verified with to the list of affected-versions and attach the (preferably SSCCE) test case you used to do the verification to the report; from there the issues will be looked at during our triage meetings.

For details, see http://in.relation.to/2015/10/27/great-jira-cleanup-2015/

Steve Ebersole
October 28, 2015, 3:25 AM

As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.

Assignee

Unassigned

Reporter

Dante

Fix versions

None

backPortable

None

Suitable for new contributors

Yes, likely

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Minor
Configure