Modify sql statements generated by JDBC

What is the simplest way to intercept and modify sql statements generated by jdbc driver? There is something like P6Spy. According to information from google, an open source framework to support applications that intercept and optionally modify database statements. But last re开发者_StackOverflow社区lease of the software was back in 2003, website is down, there is no wiki, tutorials etc. Are there any other options?

Thx for help

What database?

I recall Oracle added something in version 10 to allow you to patch/rewrite SQL in code you couldn't change.