You probably solved this problem by now but did you try prefixing your field names
with the object so it would look like
o.productID = ID.


"Paul" wrote:
>
>
>
>I am new in EJB. I am facing a problem when I am trying to deploying
>a cmp bean.
>I am using Weblogic8.1 and deplying ejb by using WeblogicBuilder8.1.
>I have attached the ejb package.
>The .xml files are automatically generated by Weblogic Builder.
>I have created a connection pool and a data source, which are working
>fine.
>I have browsed & selected the datasource name, table name.
>The database is created by Microsoft Access and using JdbcOdbcDriver.
>
>During "Validate Descriptor" 6 errors are thrown from 6 finder methods.
>Here is one of them :
>Query: EJB Name: CMPProductBean Method name: findAllProducts Parameter
>Types:
>() SELECT OBJECT(o) FROM CMPProductBean AS o WHERE =>> productID = ID
>NOT NULL
>Error encountered while compiling EJB QL IS [NOT] NULL, EJB QL compilation
>encountered
>error. [EJB:013080] Problem, the path expression/identifier 'productID'
>starts
>with an identifier: 'productID'. The identifier 'productID', which can
>be either
>a range of identifier or a collection member identifier, is required
>to be declared
>in the FROM clause of its query or in the FROM clause of a parent query.
>'productID'
>is not defined in the FROM clause of either its query or in amy parent
>query.
>Action, rewrite the query paying attention to the usage of 'productID'.
>
>Others are identical
>
>The querys are like that
>
>findAllProducts() --> SELECT OBJECT(o) FROM CMPProductBean AS o WHERE
>productID
>IS NOT NULL
>findByBasePrice(double) --> SELECT OBJECT(o) FROM CMPProductBean AS o
>WHERE basePrice
>= ?1
>findByDescription(String --> SELECT OBJECT(o) FROM CMPProductBean AS
>o WHERE description
>= ?1
>findByName(String) --> SELECT OBJECT(o) FROM CMPProductBean AS o WHERE
>name =
>?1
>findCheapProducts(double) --> SELECT OBJECT(o) FROM CMPProductBean AS
>o WHERE
>basePrice < ?1
>findExpensiveProducts(double) --> SELECT OBJECT(o) FROM CMPProductBean
>AS o WHERE
>basePrice > ?1
>
>Can anyone help me to deply the bean successfully?