Hibernate Select - Criteria with a Date

[Chris Montgomery]

Hibernate appears to be using a 'fasttime' value?? for my date in its WHERE clause and doesn't return rows that it should from the database:

Here's a 50K foot view of my Doman and DAO objects along with the SQL output.
I'm using annotations for hibernate and have set the temporal type for my date objects to DATE (I've tried all three)

DOMAIN:

@Entity
@Table( name = "EVENT" )
public class Event extends HibernateDomain {
    @Id
    @GeneratedValue( strategy = GenerationType.AUTO )
    @Column( name = "EVENTID" )
    private Long eventId;
    @Column( name = "ORGID" )
    private Long orgId;
    @Column( name = "EVENTNAME" )
    private String eventName;
    @Column( name = "INSTRUCTIONS" )
    private String instructions;
    @Column( name = "STARTDT" )
    @Temporal( javax.persistence.TemporalType.DATE )
    private Date startDate;
    @Column( name = "ENDDT" )
    @Temporal( javax.persistence.TemporalType.DATE )
    private Date endDate;

    ...

    public Date getEndDate() {
        return endDate;
    }

    public void setEndDate( Date endDate ) {
        this.endDate = endDate;
    }

    public Date getStartDate() {
        return startDate;
    }

    public void setStartDate( Date startDate ) {
        this.startDate = startDate;
    }

    ...

}

DAO:

public List<Event> findAllByCriteria( EventSearchCriteria criteria ) {
        Criteria cri = getSession().createCriteria( Event.class );
        cri.add( Restrictions.eq( "status", Constants.ACTIVE ) );
        if ( criteria.getStartDate() != null ) {
            cri.add( Restrictions.ge( "startDate", criteria.getStartDate() ) );
        }

        if ( criteria.getEndDate() != null ) {
            cri.add( Restrictions.le( "endDate", criteria.getEndDate() ) );
        }

        return cri.list();
}

My variables output shows that the start and end date 'criterion' are pointing to the correct property name, but when it comes to the actual value, cdate is null and fasttTme is 1304139600000.

Unfortunately, my log4j.xml isn't responding to TRACE, so I am not able to see the actual parameters I'm hoping I'm still on the right track.

Here's what Hibernate has for a query:
select this_.EVENTID as EVENTID6_1_, this_.VERSION as VERSION6_1_, this_.ORGID as ORGID6_1_, this_.EVENTNAME as EVENTNAME6_1_, this_.STARTDT as STARTDT6_1_, this_.ENDDT as ENDDT6_1_ ... from EVENT this_ where this_.STATUS=? and this_.ORGID=? and this_.STARTDT>=? and this_.ENDDT<=?

when I use the values from fastTime values, the rows do not come back.
when I use the 'yyyy-MM-dd' equivalent of the fast time values, the query does work.

This is how I was able to confirm the equivalent from the fastTime:

Date testDate = new Date( 1304139600000L );
System.out.println( testDate );
--> OUTPUT: Sat Apr 30 00:00:00 CDT 2011

Hoping for a little nudge in the right direction.

Thanks!

[Arun Kumarr]

Just a thought. Can we not annotate and override the getter methods of dates to return values of desired type?

[Chris Montgomery]

Many apologies folks. False alarm. the dates weren't even the issue. it was a separate criteria that was the culprit.

For some reason I keep having to relearn the lesson of 'elimination'.
Start removing various factors to weed out the cause.