Re: query manipulation

Would this be a good tool to use here or would it create unnecessary work?

http://jakarta.apache.org/commons/dbutils/apidocs/org/apache/commons/dbutils/ProxyFactory.html

public java.sql.PreparedStatement
createPreparedStatement(java.lang.reflect.InvocationHandler handler)

Randall

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
>