Hi all I'm trying to use JBoss Dynamic-QL But When I submit the following Dynamic-QL, I get the following consol error msgs. ---ConsolErrorMessages--- ERROR [EntityContainer] Starting failed org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found) ------------------------ in jbosscmp-jdbc.xml tell JBoss that this method is dynamic. So, <ejb-ql>value is empty in the ejb-jar.xml. reference is 117/207Page of ejbwJboss.eBook.pdf http://www.univ-orleans.fr/SCIENCES/INFO/RESSOURCES/modules/sir/ejbwJboss.eBook.pdf ---ejb-jar.xml--- <query> <description><![CDATA[]]></description> <query-method> <method-name>ejbSelectScreeningAbleNumFromUserResponseNum</method-name> <method-params> <method-param>java.lang.String</method-param> <method-param>java.lang.Object[]</method-param> </method-params> </query-method> <ejb-ql></ejb-ql> </query> ------------------------ ---jbosscmp-jdbc.xml--- <query> <query-method> <method-name>ejbSelectScreeningAbleNumFromUserResponseNum</method-name> <method-params> <method-param>java.lang.String</method-param> <method-param>java.lang.Object[]</method-param> </method-params> </query-method> <dynamic-ql/> </query> ------------------------ ---CMP Xdoclet (ClassLevel)--- * @jboss.query * dynamic = "true" * signature = "int ejbSelectScreeningAbleNumFromUserResponseNum(java.lang.String jbossQL, java.lang.Object[] arguments)" ------------------------ ---CMP Xdoclet (MethodLevel)--- /** */ public abstract int ejbSelectScreeningAbleNumFromUserResponseNum(String jbossQL, java.lang.Object[] arguments) throws FinderException; /** * @ejb.home-method */ public int ejbHomeGetScreeningAbleNumFromUserResponseNum() throws FinderException { StringBuffer jbossQL = new StringBuffer(); jbossQL.append("SELECT count(distinct ur.monitorID) FROM UserResponse As ur where ur.responseData = '0123'"); java.lang.Object[] args = null; return ejbSelectScreeningAbleNumFromUserResponseNum(jbossQL.toString(), args); } ------------------------ jboss-4.0.0DR3 Does anyone recognize what the problem could be here? Any help is appreciated. masaru ------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
