Hi,

I'm having a problem using EJB-QL.

I have the following simple sentence  in my ejb-jar.xml, but it doesn't
deploy.
<query>
        <query-method>
        <method-name>findByDocB</method-name>
           <method-params>
              <method-param>java.lang.String</method-param>
                <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <ejb-ql>
         <![CDATA[SELECT OBJECT(obj) FROM EjbDocBean AS obj
         WHERE obj.docRegFol = ?1
         AND obj.docNum = ?2]]>
        </ejb-ql>
</query>

I'm having the following error:

2002-11-25 22:45:13,456 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.EjbDocBean.findByDocB]
EJB-QL: 
                           SELECT OBJECT(obj) FROM EjbDocBean AS obj
                                      WHERE obj.docTip = ?1
                                        AND obj.docNum = ?2

                         
2002-11-25 22:45:13,596 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.parentTraceEnabled=true
2002-11-25 22:45:13,596 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2002-11-25 22:45:13,596 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2002-11-25 22:45:13,612 ERROR [org.jboss.ejb.EjbModule] Starting failed
org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested
throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered
"obj.docTip" at line 3, column 49.
Was expecting one of:
    "NOT" ...
    "(" ...
    <COLLECTION_VALUED_PATH> ...
    <STRING_VALUED_PATH> ...
    "CONCAT" ...
    "SUBSTRING" ...
    <BOOLEAN_VALUED_PATH> ...
    <DATETIME_VALUED_PATH> ...
    <ENTITY_VALUED_PATH> ...
    <IDENTIFICATION_VARIABLE> ...
    <NUMERIC_VALUED_PATH> ...
    "LENGTH" ...
    "LOCATE" ...
    "ABS" ...
    "SQRT" ...
    "+" ...
    "-" ...
    <INTEGER_LITERAL> ...
    <FLOATING_POINT_LITERAL> ...
    <NUMERIC_VALUED_PARAMETER> ...
    )


I can't understand why it happens.

What I really wanted is something more robust than this (I wanted that one
of these parameters were a Class (using dependent-value-class) But with
This simple example, it didin't work, imagine with a more difficult one.

Does anyone know how to solve this?I'm using jboss3.0.0

Thanks,
Tania


-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T 
handheld. Power & Color in a compact size! 
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to