I'm trying to configure JBoss 3.2.3 with Oracle 10g.
What I need it to do is to get JBoss to associate the JBoss authenticated user with any queries passed through to Oracle and I want JBoss to continue to pool connections.
Apparently Oracle allows a JDBC connection (session) to act as proxy for other JDBC connections that allows 'Scott2' to act as 'Scott' but be recorded as 'Scott2' in Oracle but authenticated with Oracle as 'Scott'.
Does anyone know how to do it ?
I know there is a way to do it with get database authentication happening with JBoss login configuration but how does that affect connection caching and how do you configure the connection to use the authenticated principal ?
I am looking into this too. I will post anything relevant that I find.
We are facing the same problem and want to use Oracle Proxy Connection in JBoss. I think without JBoss managing the pool it is not possible to participate in ongoing JTA transaction by EJB CMT. Is not is so ?