there is a platform for informix in ojb. you have to define it in the connection descriptor:
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="Hsqldb" <<<<<
jdbc-level="2.0"
driver="org.hsqldb.jdbcDriver"
protocol="jdbc"
subprotocol="hsqldb"
....but i do not know if the platform is correct :(
jakob
[EMAIL PROTECTED] wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
