Thank you for replying. I'm using Oracle9i. My problem is that whenever we tried to do a search based on a date field (ex. 1/27/2005). It works if the time was 00:00AM but it will not work if the time was 03:59AM. For testing purposes, we set up a dummy database table with a bunch of date fields (Date, TimeStamp). And for my EJB I tried to use java.sql.Timestamp, java.util.Date, java.lang.Long. When we tried to make a straight forward EJB-QL (select object(c) from TestDateSchema as c where c.tstampDate =?1) JBoss had problems parseing it. We also tried to see if it would work for dynamic queries but that didn't work either. Next, we thought it might work with JBoss-QL since it supports time information, so we changed the XDoclet tag from @ejb.finder => @jboss.query and this time it could not find the finder method. When we checked the ejb-jar.xml the finder method was empty and jbosscmp-jdbc.xml had the finder method.
For your database do you have two date fields for start and end date/time? Have you ever tried searching based on a single date field? Since we do our search based on one date field we tried doing: select object(c) from TestDateSchema as c where c.dummyDate between ?1 and ?2 where ?1 and ?2 is equal to 1/27/2005 00:00AM and 1/27/2005 23:59PM so we would get data for that date. Thanks for all your help. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3866652#3866652 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3866652 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
