Use JBossQL, EJBQL does not support LIKE ?1 Regards, Adrian
On Mon, 2003-09-01 at 21:38, Edgar Silva wrote: > Hi Friends.... > > I've declaring this ejbQL in my FinderMethod: > > SELECT OBJECT(u) FROM Usuarios u WHERE u.nome LIKE '?1%' > > > In ejb-jar.xml I wrote this configuration to this finder: > > <query> > <query-method> > <method-name>findByNomeAprox</method-name> > <method-params> > <method-param>java.lang.String</method-param> > </method-params> > </query-method> > <ejb-ql>SELECT OBJECT(u) FROM Usuarios u WHERE u.nome LIKE > '?1%'</ejb-ql> > </query> > > > When I get the Finder result into a Collection, this collection always is > empty. > When I execute FindAll (SELECT OBJECT(O) FROM Usuarios AS O) everything > works fine... > > Somebody can see something wrong in my declarations (ejbql or ejb-jar.xml)? > Any Idea ? > > Have other way To Do it similar? > > Since now...Thanks in Adv. > > > ps - Following the my complete Entity Declaration: > > <entity> > <display-name>Usuarios</display-name> > <ejb-name>Usuarios</ejb-name> > <local-home>com.argos.ejb.le.usuarios.UsuariosHome</local-home> > <local>com.argos.ejb.le.usuarios.Usuarios</local> > <ejb-class>com.argos.ejb.le.usuarios.UsuariosBean</ejb-class> > <persistence-type>Container</persistence-type> > <prim-key-class>java.lang.Integer</prim-key-class> > <reentrant>False</reentrant> > <cmp-version>2.x</cmp-version> > <abstract-schema-name>Usuarios</abstract-schema-name> > <cmp-field> > <field-name>usuarioPk</field-name> > </cmp-field> > <cmp-field> > <field-name>nome</field-name> > </cmp-field> > <cmp-field> > <field-name>email</field-name> > </cmp-field> > <cmp-field> > <field-name>depto</field-name> > </cmp-field> > <cmp-field> > <field-name>telefone</field-name> > </cmp-field> > <cmp-field> > <field-name>ramal</field-name> > </cmp-field> > <primkey-field>usuarioPk</primkey-field> > <query> > <query-method> > <method-name>findByNomeAprox</method-name> > <method-params> > <method-param>java.lang.String</method-param> > </method-params> > </query-method> > <ejb-ql>SELECT OBJECT(u) FROM Usuarios u WHERE u.nome LIKE > '?1%'</ejb-ql> > </query> > <query> > <query-method> > <method-name>findAll</method-name> > <method-params /> > </query-method> > <ejb-ql>SELECT OBJECT(obj) FROM Usuarios as obj</ejb-ql> > </query> > </entity> > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
