When you close() a proxied connection, the connection is returned to the pool but it's not retrievable, a small note buried somewhere in the docs suggests. You need to close the proxy session first.

See http://download.oracle.com/docs/cd/E118 ... e10589.pdf -- page 10-5

Try something like:

Oracle's documentation on this is somewhat squirrelly.

Hi, just want to express my interest in this topic, which seems to interest a lot of people.

Anyone else get this to work using C3P0? I am trying to get Oracle Proxy Auth to work within Grails. I think I have all the hooks set up, *however*, when inside getConnection() (using similar code to what was posted in this thread), it doesn't seem to return to my code after the call to super.getConnection().

Therefore, I am unable to do what I really want, which is to set that returned connection up as a proxied connection. Anyone else have this problem?