[OJB-developers] (no subject)

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

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