Re: [OJB-developers] (no subject)

[Jakob B. <jbr...@ho...>]

hi oleg,

i pasted the statement into ms-access and there it works. this may be a
mysql issue.

jakob

----- Original Message -----
From: "Jakob Braeuchi" <jbr...@ho...>
To: "Oleg Nitz" <on...@uk...>
Cc: "Objectbridge Developers List (E-mail)"
<obj...@li...>
Sent: Wednesday, May 15, 2002 7:59 AM
Subject: [OJB-developers] (no subject)


> hi oleg,
>
> i have a problem with the new SqlStatement:
>
> [ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT DISTINCT
> A0.id,A0.idPerson,A0.nummer,A0.saldo FROM tabKonto A0 INNER JOIN
(tabPerson
> A1 INNER JOIN tabTelefon A2 ON A1.id=A2.idPerson) ON A0.idPerson=A1.id
WHERE
> A2.tel_nr LIKE ?
>
> this produces a syntax error in mysql : syntax error near (tabPerson A1
> INNER JOIN....
>
> the query i execute is the following:
>
> Query query;
> Criteria crit;
> crit = new Criteria();
> crit.addEqualTo("inhaber.telefone.nummer", "031%");
> query = new QueryByCriteria(Konto.class, crit, true);
> showResult(broker.getCollectionByQuery(query));
>
> jakob
>
> _______________________________________________________________
>
> Have big pipes? SourceForge.net is looking for download mirrors. We supply
> the hardware. You get the recognition. Email Us: ban...@so...
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
>