CMP小问题，

[ema]

在jbuilder+weblogic+oracle下新建一cmp，
添加findAll方法，query 语句如下：
select a from CategoryESM as a
make时正常通过，
又添加了个
findByCategory方法，参数为String category,对应数据库中的CATEGORY列。query语句如下：
select a from CategoryESM as a where a.category=?1
make时却出现如下error：

"ElectronicShoppingMall.ejbgrpx": ERROR: Error from ejbc: Error while reading 'META-INF/weblogic-cmp-rdbms-jar.xml'. The error was:
"ElectronicShoppingMall.ejbgrpx":
"ElectronicShoppingMall.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"ElectronicShoppingMall.ejbgrpx": While trying to process Query
"ElectronicShoppingMall.ejbgrpx": Method Name: findMethod1
"ElectronicShoppingMall.ejbgrpx": Parameter Types: (java.lang.String)
"ElectronicShoppingMall.ejbgrpx": EJB Query: select a from CategoryESM as a where a.category=?1
"ElectronicShoppingMall.ejbgrpx": )
"ElectronicShoppingMall.ejbgrpx": Could not parse EJB QL expression: select a from CategoryESM as a where a.category=?1
"ElectronicShoppingMall.ejbgrpx": ERROR: ejbc found errors
错在哪里？


另外想问下实际开发中用bmp，cmp的多吗，
在sessionBean中连接数据库也差不多把。

[zzh9527]

你的EJB QL写的不对
select object(a) from CategoryESM a where a.category=?1

[pleonheart]

select Object(a) from CategoryESM a where a.category = ?1

[zeros]

同意楼上的！~

[zengjunhua]

同意

[ema]

没人回答，自顶个先。