Re: query manipulation

Randall,

Yeah, you would have to wrap the jdbc driver with a proxy driver.
It's not that hard to write one.

Dave
On 19-Mar-07, at 4:19 PM, Randall Smith wrote:

> I'm trying to find a way to manipulate some poorly written queries
> in which I don't have access to the application source.  I can't do
> it at the Postgresql server, so I'm thinking of attacking it at the
> jdbc driver.
>
> I was thinking of a wrapper that would look at and alter the SQL
> before it went to the server.  Anyone know of something like this?
> Specifically, I'm trying to drop "FOR UPDATE column name" off of
> some queries.  They were written for Oracle, but Postgresql uses
> "FOR UPDATE table name".  I'm not a Java programmer, but I won't
> let that stop me if it is required.
>
> Randall
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate
>