Hi, I have an application that runs on Weblogic 8.1, but i want to pass this application to JBoss, I almost finnish it, but there are some problems on the selects, I use ejb-ql. When I deploy the application JBoss don´t recognize the BETWEEN or the IN clause, how can I solved this problem.
this is some example query that is on the ejb-jar:
<![CDATA[Select Object(o) from ApasMovimientoPagoLiquidado o where o.tip_Identificacion = ?1 and o.num_Identificacion = ?2 and o.fec_Pago BETWEEN ?3 and ?4]]>
Can Anyone help me?, a by the way I'm using JBoss 3.2.1