Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS max limit causing internal server error

p.belangerJun 2 2014 — edited Aug 10 2014

Hi,

Tomcat server with ORDS, encountered Internal Server Error several times in one day.  It looks like once we reached the max limit of 10 (based on what's in the configuration file), we started to get the internal server error.  Is there a way to fine tune the max limit?

From the catalina log

02-Jun-2014 15:42:20.975 SEVERE [tomcat-http--50] oracle.dbtools.common.config.db.DatabaseConfig$DatabaseFactory.apply Could not get connection from pool:apex error:

Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use

From the config file

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

<properties>

<comment>Saved on Tue May 27 15:10:12 GMT-08:00 2014</comment>

<entry key="cache.caching">false</entry>

<entry key="cache.directory">/tmp/apex/cache</entry>

<entry key="cache.duration">days</entry>

<entry key="cache.expiration">7</entry>

<entry key="cache.maxEntries">500</entry>

<entry key="cache.monitorInterval">60</entry>

<entry key="cache.procedureNameList"/>

<entry key="cache.type">lru</entry>

<entry key="debug.debugger">false</entry>

<entry key="debug.printDebugToScreen">false</entry>

<entry key="error.keepErrorMessages">true</entry>

<entry key="error.maxEntries">50</entry>

<entry key="jdbc.DriverType">thin</entry>

<entry key="jdbc.InactivityTimeout">1800</entry>

<entry key="jdbc.InitialLimit">3</entry>

<entry key="jdbc.MaxConnectionReuseCount">1000</entry>

<entry key="jdbc.MaxLimit">10</entry>

<entry key="jdbc.MaxStatementsLimit">10</entry>

<entry key="jdbc.MinLimit">1</entry>

<entry key="jdbc.statementTimeout">900</entry>

<entry key="log.logging">false</entry>

<entry key="log.maxEntries">50</entry>

<entry key="misc.compress"/>

<entry key="misc.defaultPage">apex</entry>

<entry key="security.disableDefaultExclusionList">false</entry>

<entry key="security.maxEntries">2000</entry>

</properties>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2014
Added on Jun 2 2014
3 comments
11,184 views