EJB Applications Return NULL When Accessing a Database Proxy User
(Doc ID 793213.1)
Last updated on JULY 06, 2021
Oracle Containers for J2EE - Version 10.1.3.3.0 and later Information in this document applies to any platform.
J2EE Application is accessing Oracle Database Server via a connection obtained from a proxy data source. Fom this application, the SQL query select sys_context('userenv','proxy_user') from dual returns NULL value. However, the expected value is 'proxy_user' as the proxy data source/connection pool is configured with the "proxy_user" user.
Here is the output of the test program:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!