From: Jeremy B. <jb...@us...> - 2003-05-24 14:44:36
|
You need single quotes: a.typecode = '2' > -----Original Message----- > From: jbo...@li... > [mailto:jbo...@li...]On Behalf Of Ramrakhiani, > Vikas > Sent: Saturday, May 24, 2003 1:41 AM > To: 'jbo...@li...' > Subject: [JBoss-user] Help me with EJB QL Error > > > Hi, > > I am trying to write a where clause query in EJB QL, > <query> > <query-method> > <method-name>findAllFieldsWithTypeCode</method-name> > > <method-params><method-param>java.lang.String</method-param></meth > od-params> > > </query-method> > <ejb-ql> > <![CDATA[SELECT OBJECT (a) FROM FieldData AS a WHERE > (a.typecode = "2")]]> > </ejb-ql> > </query> > > Wherever I deploy the application I get following error:- > 14:07:30,107 INFO [EntityContainer] Starting > 14:07:30,362 ERROR [EntityContainer] Starting failed > org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement > 'SELECT OBJECT (a) FROM FieldData AS a WHERE (a.typecode = "2")'; - nested > throwable: (org.jboss.ejb.plugins.cmp.ejbql.UnknownPathException: Unknown > terminal field: at line 1, column 55. Encountered: "typecode" > after: "a.") > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuer > y.java:46) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery > (JDBCComma > ndFactory.java:53) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryMan > ager.java: > 218) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager( > JDBCStoreM > anager.java:505) > at > org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreMan > ager.java: > 410) > at > org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceMa > nager.java > :170) > at > org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339) > at > org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192) > at sun.reflect.GeneratedMethodAccessor242.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAc > cessorImpl > .java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedM > BeanDispat > cher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > at > org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceCont > roller.jav > a:966) > > What is cause of this error ? > > thanks for your help, > vikas. > > > ------------------------------------------------------- > This SF.net email is sponsored by: ObjectStore. > If flattening out C++ or Java code to make your application fit in a > relational database is painful, don't do it! Check out ObjectStore. > Now part of Progress Software. http://www.objectstore.net/sourceforge > _______________________________________________ > JBoss-user mailing list > JBo...@li... > https://lists.sourceforge.net/lists/listinfo/jboss-user |