Hi all
(BI'm trying to use JBoss Dynamic-QL
(B
(BBut When I submit the following Dynamic-QL,
(BI get the following consol error msgs.
(B
(B---ConsolErrorMessages---
(BERROR [EntityContainer] Starting failed
(Borg.jboss.deployment.DeploymentException: Error compiling
(BEJB-QL statement ''; - nested throwable:
(B(org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not
(Bfound)
(B
(B
(B
(Bin jbosscmp-jdbc.xml tell JBoss that this method is
(Bdynamic. So, ejb-qlvalue is empty in the ejb-jar.xml.
(B
(Breference is 117/207Page of ejbwJboss.eBook.pdf
(Bhttp://www.univ-orleans.fr/SCIENCES/INFO/RESSOURCES/modules/sir/ejbwJboss.eBook.pdf
(B
(B
(B---ejb-jar.xml---
(Bquery
(Bdescription![CDATA[]]/description
(Bquery-method
(Bmethod-nameejbSelectScreeningAbleNumFromUserResponseNum/method-name
(Bmethod-params
(Bmethod-paramjava.lang.String/method-param
(Bmethod-paramjava.lang.Object[]/method-param
(B/method-params
(B/query-method
(Bejb-ql/ejb-ql
(B/query
(B
(B
(B---jbosscmp-jdbc.xml---
(Bquery
(Bquery-method
(Bmethod-nameejbSelectScreeningAbleNumFromUserResponseNum/method-name
(Bmethod-params
(Bmethod-paramjava.lang.String/method-param
(Bmethod-paramjava.lang.Object[]/method-param
(B/method-params
(B/query-method
(Bdynamic-ql/
(B/query
(B
(B
(B---CMP Xdoclet (ClassLevel)---
(B* @jboss.query
(B* dynamic = "true"
(B* signature = "int
(BejbSelectScreeningAbleNumFromUserResponseNum(java.lang.String
(BjbossQL, java.lang.Object[] arguments)"
(B--------
(B
(B---CMP Xdoclet (MethodLevel)---
(B/**
(B */
(Bpublic abstract int
(BejbSelectScreeningAbleNumFromUserResponseNum(String
(BjbossQL, java.lang.Object[] arguments) throws
(BFinderException;
(B/**
(B * @ejb.home-method
(B */
(Bpublic int ejbHomeGetScreeningAbleNumFromUserResponseNum()
(Bthrows FinderException
(B{
(BStringBuffer jbossQL = new StringBuffer();
(BjbossQL.append("SELECT count(distinct ur.monitorID) FROM
(BUserResponse As ur where ur.responseData = '0123'");
(Bjava.lang.Object[] args = null;
(Breturn
(BejbSelectScreeningAbleNumFromUserResponseNum(jbossQL.toString(),
(Bargs);
(B}
(B--------
(B
(Bjboss-4.0.0DR3
(B
(B
(BDoes anyone recognize what the problem could be here?
(B
(BAny help is appreciated.
(B
(B
(Bmasaru
(B
(B
(B
(B---
(BThis SF.Net email is sponsored by Sleepycat Software
(BLearn developer strategies Cisco, Motorola, Ericsson Lucent use to
(Bdeliver higher performing products faster, at low TCO.
(Bhttp://www.sleepycat.com/telcomwpreg.php?From=osdnemail3
(B___
(BJBoss-user mailing list
(B[EMAIL PROTECTED]
(Bhttps://lists.sourceforge.net/lists/listinfo/jboss-user
