What is r? Should I define it before using? Could you give me an example?
-phu
Dain Sundstrom
<[EMAIL PROTECTED]> To:
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: [JBoss-user]
Error compiling ejbql
eforge.net
No Phone Info Available
09/18/2002 11:55 AM
Please respond to jboss-user
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
-------------------------------------------------------
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
