Mantis - Quercus
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
2877 feature always 08-28-08 11:38 09-05-08 15:29
Reporter: emil Platform:  
Assigned To: nam OS:  
Priority: high OS Version:  
Status: closed Product Version: 3.2.1  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version: 3.2.1  
Summary: 0002877: Add option to disable database connection pooling
Description: Connection pooling causes problems for certain applications which do their own pooling/caching.
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:

Notes
(0003380)
nam   
09-03-08 23:47   
php/2023

Use <connection-pool> servlet setting. If the db spy log is enabled, you'll see connections being "destroyed" in log.

<web-app xmlns="http://caucho.com/ns/resin"> [^]
  <servlet-mapping url-pattern="*.php"
                   servlet-class="com.caucho.quercus.servlet.QuercusServlet">
    <init>
      <connection-pool>false</connection-pool>
    </init>
  </servlet-mapping>
</web-app>
(0003397)
nam   
09-05-08 15:29   
<connection-pool>false</connection-pool> disables the servlet connection pool. There is another connection pool and that one is per request. It is a feature of PHP and that is not disabled by this setting.

http://us.php.net/manual/en/function.mysql-connect.php [^]
If $new_link = true and if and only if <connection-pool> is disabled, then an absolutely new connection is made. Otherwise, an old connection may be reused.