JPA hibernae date between query issue
In my application am using JPA entity manager to persist data/fetch data.

    em.executeQuery("select * from file_calender_mapping where start_date between :start and :end");

em.setParameter("start",startDate)//startDate is an date object

em.setParameter("end",endDate)//endDate is an date object

List<FileCalenderMapping> fmlist=em.execute();




The proble is just like this,

    "select * from file_calender_mapping where start_date between start and end"


when am passing some date as start= "2011-08-03 05:08:00",and end="2011-08-04 06:08:00"
then the mysql return one row having the start time ="2011-08-03 05:30:00",its good,But 
when my application executing such query it dose not returning any row.Actually what i have seen that my application returning value for two different date,but not for same date different time,thats the main problem.
One another thing is my "start" field for Table "file_calender_mapping" datatype is "timestamp".

So what i was thinking that ther may be some problem on JPA/Hibernate
JPA hibernae date between query issue
===

In my application am using JPA entity manager to persist data/fetch data.

    em.executeQuery("select * from file_calender_mapping where start_date between :start and :end");

em.setParameter("start",startDate)//startDate is an date object

em.setParameter("end",endDate)//endDate is an date object

List<FileCalenderMapping> fmlist=em.execute();




The proble is just like this,

    "select * from file_calender_mapping where start_date between start and end"


when am passing some date as start= "2011-08-03 05:08:00",and end="2011-08-04 06:08:00"
then the mysql return one row having the start time ="2011-08-03 05:30:00",its good,But 
when my application executing such query it dose not returning any row.Actually what i have seen that my application returning value for two different date,but not for same date different time,thats the main problem.
One another thing is my "start" field for Table "file_calender_mapping" datatype is "timestamp".

So what i was thinking that ther may be some problem on JPA/Hibernate