This week's book giveaway is in the Testing forum. We're giving away four copies of The Way of the Web Tester: A Beginner's Guide to Automating Tests and have Jonathan Rasmusson on-line! See this thread for details.
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
posted 15 years ago
I found the answer the minute I posted it. <pre> SELECT @@ c FROM Category c WHERE (c.name = ?1) </pre>