0 Replies Latest reply: Jun 12, 2012 11:51 AM by 773957 RSS

    OracleConnection.END_TO_END_CLIENTID_INDEX not working in OAS

    773957
      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?