Hi,
I have a dynamic finder which looks like this (in one case):

SELECT DISTINCT OBJECT(eo)
FROM EmoveOrder eo, IN (eo.emoveOrderLine) as eol
WHERE eol.estDeliveryDate BETWEEN '01.06.2002' AND '01.10.2003'

Dates are in DD.MM.YYYY -format. It translates into following sql-query
(from Toad's SGA trace):

SELECT DISTINCT wl0.sap_purch_order_no, wl0.buyer, wl0.buyer_phone,
wl0.company_code, wl0.contract_no, wl0.order_date,
wl0.purch_group, wl0.supplier, wl0.supplier_email,
wl0.supplierno
FROM emove_order wl0, emove_order_line wl1
WHERE ( (wl1.est_delivery_date >= '01.06.2002')
AND (wl1.est_delivery_date <= '01.10.2003')
)
AND wl0.sap_purch_order_no = wl1.sap_purch_order_no

My problem is that when running the EJB-QL I get 2 exceptions:
java.sql.SQLException: ORA-01843: not a valid month

but when running the generated sql-query in Toad it runs perfectly, no
errors whatsoever.

thanks for your help,
Jari Rantala