Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting the Date using Hibernate Criteria API

803221Oct 5 2010 — edited Oct 5 2010
I am trying to retrieve the records from a table using criteria API for a particular date. Following is the info regarding the db table, configuration and code. My concern is that I could not able to read the records when the date is passed.

Appreciate if some help me out what's wrong with my approach.

DB table

CREATE TABLE `ws_access` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL,
`ws_id` bigint(20) NOT NULL,
`date_accessed` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

Hibernate Configuration

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="abc.hibernate.entity">
<class name="abc.hibernate.entity.WsAccess" table="ws_access">
<id name="id" column="id">
<generator class="assigned"/>
</id>
<property name="userKey" column="user_id"/>
<property name="workSheetKey" column="ws_id"/>
<property name="dateAccessed" column="date_accessed"/>
</class>

</hibernate-mapping>

Code

public List<WsAccess> getInfo(long userid, long worksheetId) {
List<WsAccess> data = null;
Session session = HibernateUtil.getSessionFactory().openSession();
try {
Criteria criteria = session.createCriteria(WsAccess.class);
criteria.add(Restrictions.eq("userKey", new Long(userid)));
criteria.add(Restrictions.eq("workSheetKey", new Long(worksheetId)));

try {
DateFormat format = new SimpleDateFormat("MM/dd/yyyy");
String curdate = format.format(new Date());
Date date = (Date)format.parse(curdate);
criteria.add(Restrictions.eq("dateAccessed", date));
} catch (ParseException e) {

}

data = criteria.list();

}
finally {
if(session != null) {
session.close();
}
}
return data;
}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2010
Added on Oct 5 2010
2 comments
4,012 views