On 2/27/06, = Gianny Damour <gian= ny.damour@optusnet.com.au> wrote:

Hi Phani,

In a first step= , we will add support for standard EJBQL statements. The
current impl. i= s as follows:

* in the vendor specific deployment descriptor, a specific GBean is=
bound to the ENC. This looks like this:
    &nbs= p;      <gbean-ref>
   &nb= sp;           <ref-nam= e>cmp/QueryManager</ref-name>
            &nb= sp; <ref-type>ModuleCmpEngine</ref-type>
  &= nbsp;            <= ;gbean-locator>

<application>geronimo/daytrader-derby-jetty= /1.1-SNAPSHOT/car</application>
     &nbs= p;             = <module> daytrader-ejb-1.1-SNAPSHOT.jar</module>
    &n= bsp;            = ; <type>EJBModule</type>
     = ;            &n= bsp; <name>moduleCmpEngine</name>
    &n= bsp;          </gbean-locat= or>
           <= /gbean-ref>

* from the J2EE component having the above gbean-ref, we following<= br>snippet retrieves a QueryManager:
   QueryManagerLocator lo= cator =3D new QueryManagerLocator();
   QueryManager qm =3D lo= cator.locate("cmp/QueryManager");

* the QueryManager allows the creation of queries:
   = Query query =3D qm.createQuery("select H from HoldingEJB H where
H.= holdingID =3D ?", new Class[] {Integer.class});

* parameters ar= e then set:
   query.setParameter(0, new Integer(1));

* when the p= arameters have been set, the query is then executed and
return the resul= t as a single object or a list:
   Object result =3D query.get= SingleResult();
or
   List results =3D query.getResultList();

I am in t= he process of testing the impl.; meanwhile, if you think that
the above = can be improved, then let us know.

Thanks,
Gianny

Phan= i Madgula wrote:

> Hi Gianny,
>
> I just want to know more about this= feature.
>
> Is it something like AG providing an API for CMP = clients to execute
> EJBQL statements at runtime?.
>
> If= yes, what kind of queries we can execute? are query capabilities
> extended?
>
> For example, currently EJB-QL does not a= llow multiple expressions in
> SELECT class.
> That is, we can'= t have SELECT OBJECT(e), e.name < http://e.name> FROM
> ... like statements.
>
> wil= l dynamic query feature allow above statement?
>
> Thx
> = phani
>
>
>
> **
> **
> **
>
> **
>
>
>
>
> On 2/23/06, *Gianny Damour*= <gianny.damour@optusne= t.com.au
> <mailto: gianny.damour@optusnet.com.au>> wrote:
>
>  = ;   Hi Glaucio,
>
>     It is not= yet possible to create dynamic queries in Geronimo. This
> &nbs= p;   feature is currently being progressed and will be available = next
>     week.
>
>   &nb= sp; Thanks,
>     Gianny
>
> &nb= sp;   Glaucio Scheibel wrote:
>
>   &n= bsp; > Hi,
>     >
>   = ; > I am looking how to create dynamic queries in geronimo. Is thi= s
>     > possible? I didn't find any info abou= t this.
>     >
>    = ; > Thanks in advance
>     > Glaucio
&g= t;     >
>     >
>= ;
>
>