EJB programming & troubleshooting: JBOSS-Oracle:configuring datasource use callerPrincipal as proxy

  1. Hi

    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 ?

    Cheers Tom

    Threaded Messages (3)

  2. I'm looking into this too[ Go to top ]


    I am looking into this too. I will post anything relevant that I find.
  3. Oracle's Proxy Connection[ Go to top ]

    Try this: http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/9i_jdbc/OCIMidAuthSample/Readme.html ... however, I am trying to figure out how to make it work with a datasource.
  4. Oracle's Proxy Connection[ Go to top ]

    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 ?

    Shoaib Akhtar