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