This discussion is archived
0 Replies Latest reply: Jun 12, 2012 9:51 AM by 773957 RSS

OracleConnection.END_TO_END_CLIENTID_INDEX not working in OAS

773957 Newbie
Currently Being Moderated
Hi,
I am trying to get the web application user ID in a trigger for auditing purposes. ID is setup in the connection when it is retrieved as follows.

*String[] metrics = new String[OracleConnection.END_TO_END_STATE_INDEX_MAX];*
*metrics[OracleConnection.END_TO_END_CLIENTID_INDEX]='XXX' ;*

And is retrieved in the trigger as
SELECT sys_context('USERENV','CLIENT_IDENTIFIER') INTO usrId FROM DUAL;

This works fine in tomcat and weblogic. But not in OAS. Any ideas?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points