Hi all !
I have an EJB 3 Entity bean which issues some queries. The Queries include some Date field in the WHERE clause
SELECT OBJECT(a) FROM TaskList AS a WHERE a.taskEndDate ='2004-09-01'
That's a JDBC error, not a Hibernate error. That's not Oracle's default date format. Try '01-SEP-04'.
Otherwise, make it a parameter and pass it in when building the query.