Hibernate - Parameter value [2011] was not matching type [java.lang.Integer]. How to solve?

Question

I am getting the message above even though the value I'm passing through an Integer to the named query. Can anyone explain why? Thanks

DAO Java Code

Calendar cal = Calendar.getInstance();
cal.setTime(interval.getStartDate());        
query.setParameter("academicYear", new Integer(cal.get(Calendar.YEAR)));

Query:

@NamedQuery(name = "StudentDemographics.findByMOEDEqual", query = "SELECT s.student FROM StudentDemographics s " +
            "WHERE :academicYear = s.academicYear " +
            "AND UPPER(s.MOED) like :MOED"),

Error: Parameter value [2011] was not matching type [java.lang.Integer]

Environment is Spring w Hibernate/JQL + SQL Server

What's the type of academicYear field in the StudentDemographics? — StanislavL
– StanislavL, Commented Jul 8, 2011 at 10:18

Heiner Reinhardt · Accepted Answer · 2012-01-24 22:25:17Z

3

I had a similar problem and could fix it this way:

I used long instead of int as a type for the respective field.

answered Jan 24, 2012 at 22:25

Heiner Reinhardt

1014 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate - Parameter value [2011] was not matching type [java.lang.Integer]. How to solve?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related