• Post Reply Bookmark Topic Watch Topic
  • New Topic

Small trouble in EJB-QL  RSS feed

 
Ingi Gauti
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Small trouble here, I'm trying to do a litle EJB-QL, I'm using J2EE 1.3 FD 2 (using tomcat, cloudscape and the Java Application Deployment Tool that comes with J2EE) I use the Java Application Deployment Tool to verify my code and deploy the ejb
this is my EJB-QL code (method findByName(String parm))
<pre>
SELECT Object(c) FROM Category c WHERE (c.name = ?1)
</pre>
The Abstract Schema Name is Category as is my Remote Interface
The error I get is
<pre>
Error while generating SQL. Encountered "Object" at line 1, column 8.
Was expecting one of: "@@"... "IdentificationVar"...
...
<pre>
This a simple EJB-QL, so someone should be able to help me
best regards
 
Ingi Gauti
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found the answer the minute I posted it.
<pre>
SELECT @@ c FROM Category c WHERE (c.name = ?1)
</pre>
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!