Hibernate Version 3.2

i am using MySql and i want to save "java.sql.Timestamp". How can i read all elements with criteria or hql, if for example the year must be "2006" ?

you can use the "year(...)" function in both HQL and Criteria.

in HQL:

session.createQuery("from Foo where year(_date) = :y").setParameter("y", 2006).list();

in Criteria API:

...
add(Restrictions.sqlRestriction("year(_date) = ?", 2006, Hibernate.INTEGER)
...

see more in
http://www.hibernate.org/hib_docs/v3/re ... teria.html
http://www.hibernate.org/hib_docs/v3/re ... ryhql.html

regards, Ivan

Thank you for your answer. Sorry, but it doesnt work. My java.sql.Timestamp is for example: "2006,10,14,15,34,00"

when i try to execute this query:



if get an java.lang.ClassCastException . Any idea whats wrong?

2 things:

what are the commas in your timestamp? or is that only a special format (is this Oct 14, 2006, 15:34 ?

why do you convert the year param to String? String.valueOf(year)? The query expects an integer, maybe that's a reason of the classcast exception. If I understand year is an integer (2006), you should leave it as is:



anyway what is the stacktrace?

ivan

That with the year must be an error, there are dots.

I have to convert it to a String, because setParameter doesnt accept an integer.

well, it accepts in my code...
try with Integer.valueOf(year)

ivan