Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 58226 invoked from network); 21 Jan 2004 20:24:10 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 21 Jan 2004 20:24:10 -0000 Received: (qmail 95175 invoked by uid 500); 21 Jan 2004 20:23:59 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 95153 invoked by uid 500); 21 Jan 2004 20:23:59 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 95133 invoked from network); 21 Jan 2004 20:23:58 -0000 Received: from unknown (HELO hm61.locaweb.com.br) (200.213.197.161) by daedalus.apache.org with SMTP; 21 Jan 2004 20:23:58 -0000 Received: (qmail 497 invoked from network); 21 Jan 2004 20:23:57 -0000 Received: from hm20.locaweb.com.br (200.246.179.120) by hm61.locaweb.com.br with QMTP; 21 Jan 2004 20:23:57 -0000 Received: (qmail 16326 invoked from network); 21 Jan 2004 20:24:03 -0000 Received: from unknown (HELO osts) (leandro@ibnetwork.com.br@200.206.212.233) by hm20.locaweb.com.br with SMTP; 21 Jan 2004 20:24:03 -0000 Subject: Re: Aliases on MtoN queries not working anymore From: Leandro Rodrigo Saad Cruz To: OJB Developers List In-Reply-To: <26233.1074696046@www51.gmx.net> References: <1074611316.525.22.camel@zacarias> <26233.1074696046@www51.gmx.net> Content-Type: text/plain; charset=iso-8859-1 Organization: Inter Business Tecnologia e Seviços Message-Id: <1074716644.3134.11.camel@zacarias> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 21 Jan 2004 18:24:04 -0200 Content-Transfer-Encoding: 8bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Ok.. thanks Jakob On Wed, 2004-01-21 at 12:40, "Jakob Br�uchi" wrote: > hi leandro, > > the mn-prefetcher is quite new. and it never supported aliases ;) > i�m at the oop2004 in munich right now; so i�ll have a look at the problem > as soon as i�m at home again. > > jakob > > > > Hi all. I'm having some problems with mton queries because ojb is not > > creating a sql query using aliases anymore. > > > > Maybe the problem is in > > MtoNCollectionPrefetcher.buildMtoNImplementorQuery() > > > > Do you know if the alias generation was accidentally removed ? > > > > Example query(wrong) : SELECT DISTINCT PROJETO_ID,SERVICO_ID FROM > > SERVICO A0,SERVICO_PROJETO WHERE (SERVICO_PROJETO.PROJETO_ID IN ( '12' , > > '2' , '13' )) AND A0.SERVICO_ID = SERVICO_PROJETO.SERVICO_ID > > > > Causes my database to yeild with : > > org.apache.ojb.broker.PersistenceBrokerSQLException: > > java.sql.SQLException: ERROR: Column reference "servico_id" is > > ambiguous > > > > Because servico_id is present on both tables, servico and > > servico_projeto > > > > -- > > Leandro Rodrigo Saad Cruz > > IT - Inter Business Tecnologia e Servicos (IB) > > http://www.ibnetwork.com.br > > http://db.apache.org/ojb > > http://xingu.sourceforge.net > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org > > For additional commands, e-mail: ojb-dev-help@db.apache.org > > -- Leandro Rodrigo Saad Cruz IT - Inter Business Tecnologia e Servicos (IB) http://www.ibnetwork.com.br http://db.apache.org/ojb http://xingu.sourceforge.net --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org