So, OJB don't support Informix ? Is there any way that OJB builds SQL that Informix support ? Are there somebody that is working with Informix and OJB ?
thanks. ----- Mensaje Original ----- De: Jakob Braeuchi <[EMAIL PROTECTED]> Fecha: Miercoles, Marzo 10, 2004 7:29 pm Asunto: Re: Inner Join and Informix > hi ? > > looks like informix does not like the sql92 syntax for joining. > > btw. p6spy is better suited to log the sqls. > > jakob > > > [EMAIL PROTECTED] wrote: > > > Hi, > > I'm building an application with Informix 7.25 and RedHat 9.0 > > I have 2 tables : ventas and articulos, and I need make a > ReportQuery > > that execute a similar SQL to "select sum(ventas) from ventas > inner > > join articulos on ventas.idarticulo = articulos.id group by > > ventas.idarticulo". > > > > I see in the log4j that the SQL is correct, but Informix fire a > "Syntax > > Error" Exception. The correct syntax for Informix is similar to > "select > > sum(ventas) from ventas, articulos where ventas.idarticulo = > > articulos.id" > > > > > > Any idea ? > > > > Thanks. > > > > > > > > > > ----------------------------------------------------------------- > ---- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > ------------------------------------------------------------------- > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
