请看一下这个EJB SELECT错误是怎么回事呀？jb7+weblogic7.00+oracle9i环境。

[ltz]

有一数据表，字段:id(主键),name,addr。为其对应的cmp bean创建一find方法：findbyid（string id）；对应的slq为：SELECT OBJECT(c) FROM CustomersBean c WHERE c.id = ?1，但编译后产生如下错误：为何呢？


"MyEntityEJB.ejbgrpx": ERROR: Error from ejbc: Error while reading 'META-INF/weblogic-cmp-rdbms-jar.xml'. The error was:
"MyEntityEJB.ejbgrpx":
"MyEntityEJB.ejbgrpx": weblogic.ejb20.cmp.rdbms.finders.IllegalExpressionException:
"MyEntityEJB.ejbgrpx": While trying to process Query
"MyEntityEJB.ejbgrpx": Method Name: findMethod
"MyEntityEJB.ejbgrpx": Parameter Types: (java.lang.String)
"MyEntityEJB.ejbgrpx": EJB Query: SELECT OBJECT(c) FROM CustomersBean c WHERE c.id = ?1
"MyEntityEJB.ejbgrpx": )
"MyEntityEJB.ejbgrpx": Invalid Expression: Could not find an entity EJB for abstract schema name, 'CustomersBean', which is declared in a range variable declaration. Check to be sure that an EJB is defined in the ejb-jar.xml descriptor with this abstract schema name.
"MyEntityEJB.ejbgrpx": ERROR: ejbc found errors

[lijing725]

是不是你的配置文件ejb-jar.xml里的<abstract-schema-name>和weblogic-cmp-rdb
ms-jar.xml里的不一样

SELECT OBJECT(c) FROM CustomersBean c WHERE c.id = ?1里的CustomersBean应该是
是ejb-jar.xml里的那个<abstract-schema-name>

[zez]

错误很明显呀,是你的CustomersBean名字不对,或者是和数据库表不对应...
另外,你的id是String吗?数据库里是什么型 ?

[ltz]

谢谢