The way that I would deal with this is by implementing a JDBC driver. I would
cheat with a java.lang.reflect.Proxy which really just passes everything to
the PostreSQL JDBC driver but parses the statements and removes the alias.
It should not be too hard. But since this is so specific to your situation I
do not think anyone is going to do it for you. I think that a
java.lang.reflect.Proxy is the way to go.
On Wednesday 21 September 2005 09:50 am, andres@sayago.info wrote:
> Hello again.
>
> I can't find the solution. I need to use PostgreSQL on JDeveloper using
> ADF. I get an error about "check sintaxis". The problem is that ADF use
> aliases for UPDATE statements, and PostgreSQL not (MySQL yes!!).
>
> Can you help me??
>
> Andrés Sáyago
> Bogotá D.C., Colombia
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings