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

Reply via email to