Order by is currently not supported in EJB-QL. -dain
> -----Original Message----- > From: Frank Xia [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 18, 2002 9:35 AM > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-user] deploying CMP local entity bean, > NullPointerExce ption when it's invoked > > > Hi, > > I have successfully deployed a CMP entity bean but Jboss thrown a > NullPointerException when the bean is invoked. It looks like > the Finder > method definition in ejb-jar.xml is not quite right though it passes > container's checking during deployment. > > Any advice is greatly appreciated. > > Frank > > ============== > > [10:16:15,426,J2eeDeployer#Default] J2EE application: > file:/D:/java/jboss-3.0.0alpha/deploy/mapservice.jar is deployed. > [10:16:22,908,Default] CatalogBean:setSessionContext() > [10:16:22,908,Default] CatalogBean:ejbCreate() > [10:16:22,908,Default] CatalogBean:getAllServices() 1 > [10:16:22,988,Default] ServiceCatalogBean: > ServiceCatalogBean() ... a new > service bean created by EJB container > [10:16:23,198,Default] Did not find the UCL resource > com/esri/mo/res/Res_en.properties > [10:16:23,258,Default] Did not find the UCL resource > com/esri/mo/res/Res_en_US.properties > [10:16:23,408,Default] ServiceCatalogBean: setEntityContext() called. > [10:16:23,479,Default] java.lang.NullPointerException > [10:16:23,479,Default] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCFinderCommand.execute(JDBCF inderCommand.j > ava:87) > [10:16:23,479,Default] at > org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute > (JDBCFindEntit > iesCommand.java:1 > 79) > > =============== > > > ======= Part of the ejb-jar.xml ===== > <query> > <query-method> > <method-name>findByServiceName</method-name> > <method-params> > <method-param>java.lang.String</method-param> > </method-params> > </query-method> > <ejb-ql> > SELEcT OBJECT(a) > FROM ServiceCatalog a > WHERE a.ServiceName=?1 > </ejb-ql> > </query> > > <query> > <query-method> > <method-name>findAllServices</method-name> > <method-params> > </method-params> > </query-method> > <ejb-ql> > SELEcT OBJECT(a) > FROM ServiceCatalog a > WHERE a.ServiceName IS NOT NULL > ORDER BY ServiceName > </ejb-ql> > </query> > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
