Hi,

I'm trying to run a search using the Restrictions class on an Oracle 9i database.

I'm creating 2 timestamps for start and end dates and creating Restrictions in the search Criteria in the form of

searchCriteria.
add(Restriction.ge(startStamp));
add(Restriction.ge(endStamp));

This however gives me a ClassCastException

Caused by: java.lang.ClassCastException: java.sql.Timestamp

at com.bt.orsim.services.BusinessMessageManager.getBusinessMessagesByFilter(BusinessMessageManager.java:409)

Please is there anyone who can help me with this problem? I am able to provide more information if required however my project is highly sensitive.

Thanks

Hi all,

No bother, I've fixed the problem.

It was coming from a dynamically loaded HashMap of the type

HasMap <String><Object> map;

what happened was i forgot to typecast the timestamp back to type timestamp in the Restrictions.

ie
...Restriction.ge("key", (Timestamp)timestampObject);

This fixed the problem.