SQL & PL/SQL

Hi!

Works for us. Strange that you don't get an exception. What does your ROLE_ONE look like?

Sascha

AFAIK conn.openProxySession() can fail silently(so you will get standard connection instead of proxy).

Also, because of connection pooling, always check if you already have proxy connection(and if so, close this connection) before opening new proxy connection.

So your code should look like this:

public void prepareSession (Session session){  
myTransactionImpl myTrans = (myTransactionImpl)this.getDBTransaction(); 
      OracleConnection conn = hzpcTrans.getConnection(); 
      String currentUser = ADFContext.getCurrent().getSecurityContext().getUserName(); 

      java.util.Properties prop = new java.util.Properties(); 
      prop.put(OracleConnection.PROXY_USER_NAME, currentUser); 
      try { 
if(conn.isProxySession()){
            conn.close(OracleConnection.PROXY_SESSION);
        }
            conn.openProxySession(OracleConnection.PROXYTYPE_USER_NAME, prop); 

if(!conn.isProxySession()){
            throw SomeException();
        }

            DatabaseMetaData meta = conn.getMetaData();             
            System.out.println("the user currently on the session is " + meta.getUserName()); 
        } 
.catch......... 
}

I'm not sure why you need custom connection factory(maybe you introduced some error there? )

You can retrieve OracleConnection like this:

PreparedStatement statement =  this.getDBTransaction().createPreparedStatement("commit", 1);
OracleConnection conn = (OracleConnection)statement.getConnection();

And don't forget to call super.prepareSession(session); 

Dario

Already replied in your duplicate JDBC forum thread

https://community.oracle.com/thread/3570631