Hi, I am developing an application based on EJB CMP2.0 Spec. I have a CMP BEAN with finder method as follows:- ================================================================= SELECT Object(b) FROM CartMaster as b where b.customerid = ?1 and b.status='active' and b.cartdate < CURRENT_TIMESTAMP(0)-interval '48 hours' =================================================================
I am using JBOSS4.0.3. But when I amdeploying bean over Server it gives me error like:- ==================================================================== 11:16:23,156 INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "CURRENT_TIMESTAMP" at line 1, column 102. Was expecting one of: <DATETIME_VALUED_PARAMETER> ... <DATETIME_VALUED_PATH> ... ==================================================================== What is wrong in above Query? How to correct it? Please help me. Thanx, Prash View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926472#3926472 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926472 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
