seems to be that it is simply not possible.
Hi Christian B,
Christian B wrote:
IS there a way how ords.war can use the standard wls jdbc pools?
I don't think that ORDS uses the jdbc pools from the Supported Java EE Application Servers on which it is deployed.
If you keenly observe the ORDS startup log, you will see that it creates connection pools apex (APEX_PUBLIC_USER), apex_al (APEX_LISTENER), apex_rt (APEX_REST_PUBLIC_USER) and apex_pu (ORDS_PUBLIC_USER) according to the JDBC settings defined in "defaults.xml" of the ORDS configuration.
- The database users are specified in the bracket for which the JDBC connection pool is created.
- The connection pools will vary depending upon which users you have configured during ORDS installation.
For JDBC connection pool settings refer :
- Kris' blog: Apex Listener jdbc/security setup
- ORA-00001: Unique constraint violated: Installing Oracle XE, ORDS and Apex on CentOS - Part Four: Stress testing
Why do you want ORDS to use the "Standard Web Logic Server JDBC Pools"?
QUestion was mainly for managing and monitoring the pools.
at least i think in oracle enterprise manager it would be more easy to see them when they are std wls pools.