SEO

#1 (**permalink**) 04-15-2008, 11:38 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

gsql-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:
> > 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
>

---------------------------(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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: Help !! Postgres on JDeveloper+ADF