|
Home > Archive > PostgreSQL JDBC > September 2005 > Help !! Postgres on JDeveloper+ADF
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help !! Postgres on JDeveloper+ADF
|
|
| andres@sayago.info 2005-09-21, 1:26 pm |
| 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
| |
| Mike Warnecke 2005-09-21, 1:26 pm |
| On Wed, 2005-21-09 at 08:50 -0600, 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??
As said before, you need to write a JDBC driver that will remove the
aliases from updates, and then send the rewritten query to postgresql.
--
Mike Warnecke <mike@audiowarehouse.ca>
Audio Warehouse
| |
| Craig Servin 2005-09-21, 1:26 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Nicolaus.Bauman@wellsfargo.com 2005-09-21, 8:24 pm |
| Can I add to this that if someone decides to scratch with this idea, that they remap SYSDATE to CURRENT_DATE, too? Probably worthwhile to get a list of "Oracle Annoyances" before starting this project.
Nicolaus Bauman
Developer: TIR - SPS
* 612.667.2170
* 612.232.7120
This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you
have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Craig Servin
> Sent: Wednesday, September 21, 2005 12:23 PM
> To: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] Help !! Postgres on JDeveloper+ADF
>
>
> 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:
> JDeveloper using
> that ADF use
> broadcast)---------------------------
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
|
|
|
|