Weblogic 12c datasource is failing to connect with Proxy Authentication Set up
Hi All,
I am having a global datasource problem when I try to configure it for Proxy Authentication.
I have created the following users :
CREATE USER proxytest IDENTIFIED BY proxytest;
/
GRANT CONNECT TO proxytest;
/
2. Create a user and give necessary permission
CREATE USER PROXYSVC IDENTIFIED BY test;
ALTER USER PROXYSVC GRANT CONNECT THROUGH proxytest
/
GRANT CREATE SESSION TO PROXYSVC
/
Now I create a generic datasource with driver set to oracle.jdbc.xa.client.OracleXADataSource;
"Oracle Proxy Session" is set to true.
"Use Database Credential" is set to "true"
Next I save the configuration and re-start the weblogic servers. When the server comes up, I try to test the datasource connection, I get the following error