Hello,
provided taht you have your mapping.xml correctly defined and
that in openejb-jar.xml you have written your query correctly,
there shouldn't be any problems
in your case, your query in openejb-jar.xmll would be
SELECT o FROM org.customer o WHERE o.scustid= $1
so what are the problems that you are finding?
regards
marco
On 10/23/05, Bruce Snyder <[EMAIL PROTECTED]> wrote:
>
> > Rajesh Puri wrote:
> >
> > I have table like customer and the corresponding CMP
> > bean name is org.customer(with persistent field
> > scustid).
> >
> > Now, setting up openejb-jar.xml
> > for findbycustid method
> > will I say:
> > select o from customer o where custid = $1
> > or
> > select o from org.customer o where scustid= = $1
>
> Actually the OQL for that would be:
>
> select o from org.customer o where o.custid = $1
>
> > I see that openejb deploy does not know what tables I
> > have using CMP so the default OQL are being generated
> > with table names as CMP bean names.
>
> Please post an example of this, Rajesh so I can take a look at it.
>
> Bruce
> --
> perl -e 'print
> unpack("u30","D0G)[EMAIL PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
> );'
>
> The Castor Project
> http://www.castor.org/
>
> Apache Geronimo
> http://geronimo.apache.org/
>
