SELECT OBJECT(r) FROM Role as r The 'as' is optional
-dain Dmitri Colebatch wrote: > I _think_ the ejbql should be something like > > SELECT r FROM Role AS r > > hth > dim > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 2:01 PM > Subject: [JBoss-user] Error compiling ejbql > > > >>Got error when deploy application. Can anyone help? >> >>10:33:21,317 INFO [RoleEJB] Table 'role_map' already exists >>10:33:21,337 WARN [ServiceController] Problem starting service >>jboss.j2ee:servi >>ce=EJB,jndiName=RoleRemoteHome >>org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested >>throwa >>ble: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "<EOF>" >>at lin >>e 1, column 18. >>Was expecting one of: >> "AS" ... >> <IDENTIFIER> ... >> ) >> at >> > > org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:46) > >>Definition in ejb-jar.xml >> >> <entity> >> <description>User Role Entity Bean</description> >> <ejb-name>RoleEJB</ejb-name> >> <home>occs.RoleRemoteHome</home> >> <remote>occs.RoleRemote</remote> >> <ejb-class>occs.RoleBean</ejb-class> >> <persistence-type>Container</persistence-type> >> <prim-key-class>java.lang.Integer</prim-key-class> >> <reentrant>False</reentrant> >> <cmp-version>2.x</cmp-version> >> <abstract-schema-name>Role</abstract-schema-name> >> <cmp-field> >> <field-name>roleID</field-name> >> </cmp-field> >> <cmp-field> >> <field-name>roleDesc</field-name> >> </cmp-field> >> <primkey-field>roleID</primkey-field> >> <query> >> <query-method> >> <method-name>findAll</method-name> >> <method-params /> >> </query-method> >> <result-type-mapping>Local</result-type-mapping> >> <ejb-ql>select * from Role</ejb-ql> >> </query> >> </entity> >> ------------------------------------------------------- This SF.NET email is sponsored by: AMD - Your access to the experts on Hammer Technology! Open Source & Linux Developers, register now for the AMD Developer Symposium. Code: EX8664 http://www.developwithamd.com/developerlab _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user