Ords on weblogic with jdbc pool from wls

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.

     NOTE :

• 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
• http://docs.oracle.com/cd/E56351_01/doc.30/e56293/config_file.htm#BABHAJDE

     Why do you want ORDS to use the "Standard Web Logic Server JDBC Pools"?

Regards,

Kiran