JavaBoy

Database table(Product)roductID(key), Name, basePrice, Description
I created an CMP EJB2.O Bean(Bean name: Product). When I wanted to define a finder method( findByName), useing (String name) as a only method parameter,using following EJB QL: SELECT OBJECT(p) FROM Product(p) WHERE p.name=?1, But I always got a error message as following:

"product.ejbgrpx": Could not parse EJB QL expression: SELECT OBJECT(p) FROM ProductBean AS p WHERE p.name=?1

Appreciate expert's help greatly

JavaBoy

Thx for ur reply.

I created a table with name "product".I used JBuilder to create a CMP EJB2.0 bean with name Product, which includes six filesroduct.java,ProductBean.java, ProductHome.java, ProductLocal.java, ProductLocalHome.java, ProductPK.java

When I wanted to define "finder" method for this bean, Jbuilder wanted me to write query for this method. I know I should use EJB QL, not SQL. After I inputed that sentenc, then make it, JBuilder report errors as I posted before.

I did not produce any code. I used JBuilder to create EJB directly. I did not understand ur meaning quite well, I am a beginner for EJB  .

JavaBoy

thx

JavaBoy

Hi, I changed abstractSchemaName to be ProductSN. Then, I wrote following:
SELECT OBJECT(p) FROM ProductSN AS p WHERE p.name=?1. I got same problem. I checked my ejb-jar.xml, I got "SELECT OBJECT(p) FROM ProductSN AS p WHERE p.name=?1", not "![CDATA [SELECT OBJECT(p) FROM ProductSN AS p WHERE p.name=?1]]". The I wrote following ejb ql sentence:"![CDATA [SELECT OBJECT(p) FROM ProductSN AS p WHERE p.name=?1]]". But I got same error. I don't know what happened? Pls provide help. Thanks a lot in advance.

Clone

Hi Frank,

I tried to write EJB QL as following again: SELECT OBJECT(p) FROM ProductSN p WHERE p.name=?1, it still did not work. Did u try JBuilder at home? What should I write about EJB QL? I already followed the instructions from Website.

JavaBoy

Done. Thx