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
-------------------------------------------------------
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
