JDO75202: Syntax error unexpected token 'LIKE' URGENT PLEASE
Hi!
I am trying to deploy a cmp-bean that has the following select method defined in its ejb-jar.xml file as...
<ejb-ql> SELECT OBJECT(v) FROM TVia AS v, IN (v.tViaSt) AS st WHERE (st.dataInizio < ?4 OR st.dataInizio = ?4) AND (st.dataFine = ?4 OR st.dataFine > ?4 OR st.dataFine IS NULL) AND st.descrizione LIKE CONCAT(?1,'%') AND st.tTipoVia = ?2 AND v.tComune = ?3 ></ejb-ql>
when I try to deploy it I get the following error. Can someone help me here?
Sun application server 8.2 used
JDO75006: Invalid EJBQL query Bean: TVia Method: java.util.Collection findByDescrizioneAndTipoViaAndComuneAsRadiceSt(java.lang.String,it.deltadator.k ernel.ejb.ent.TTipoViaLocal,it.deltadator.kernel.ejb.ent.TComuneLocal,java.sql.D ate) EJBQL: SELECT OBJECT(v) FROM TVia AS v, IN (v.tViaSt) AS st WHERE (st.dataInizio < ?4 OR st.dataInizio = ?4) AND (st.dataFine = ?4 OR st.dataFine > ?4 OR st.dataFine IS NULL) AND st.descrizione LIKE CONCAT(?1,'%') AND st.tTipoVia = ?2 AND v.tComune = ?3 Error: column(188): JDO75202: Syntax error unexpected token 'LIKE'
Message was edited by:
__Taha__
Message was edited by:
__Taha__
