hi a b ?,
here are samples for IN:
Collection values = new Vector();
values.add(new Integer(1));
values.add(new Integer(2));
values.add(new Integer(3));
values.add(new Integer(44));
query = odmg.newOQLQuery();
query.create("select persons from brj.ojb.Person where id in($1)");
query.bind(values);
or:
query = odmg.newOQLQuery();
query.create("select persons from brj.ojb.Person where id in(1,2,3,44)");
and here is one that uses a join:
query = odmg.newOQLQuery();
query.create("select persons from brj.ojb.Person where persons.konti.saldo >
1000");
hth
jakob
----- Original Message -----
From: "a b" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 24, 2002 9:52 PM
Subject: HELP NEEDED: OQL JOIN QUERY?
> hi, i have sth like
> String oqlQuery = "select e from e in " +
> One.class.getName() + ", c in " +
> Two.class.getName() +
> " where e.field1 = c.field2";
> query.create(oqlQuery);
> and I get a , can any1 tell me what's going on or
> what's the right syntax for an oql join query. I do
> have all the stuff in the repository
> line 1: unexpected token: in
> java.lang.NullPointerException
> at
> org.apache.ojb.odmg.oql.OQLQueryImpl.create(OQLQueryImpl.java:236)
> at
> org.apache.ojb.odmg.oql.OQLQueryImpl.create(OQLQueryImpl.java:207)
> at
> org.apache.ojb.mytest.UCJoinTest.apply(UCJoinLogin.java:41)
> at
> org.apache.ojb.mytest.Application.run(Application.java:134)
> at
> org.apache.ojb.mytest.Application.main(Application.java:90)
>
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
