Re: query manipulation

[Dave Cramer <pg(at)fastcrypt(dot)com>]

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