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

Reply via email to