connection-pool

Purpose

Creates a pooled connection pool from an anonymous unpooled data source.

Note:

If a datasource provides connection pooling facilities, you should use those in preference to the connection-pool element.

Contained by

Contains

Attributes

Attribute Description Type Default Options Use
keep-alive Controls whether the connections are kept alive by periodically querying the database. If this is true then the interval is specified by the poll-interval attribute. xs:boolean false    optional 
maximum The maximum number of connections allocated by the pool xs:int 5    optional 
poll-interval The interval in seconds between polling requests made on idle connections. This is only used if keep-alive is true. xs:int 10    optional 

Example

<jdbc-repository>
  <connection-pool maximum="20"
    poll-interval="3600000"
    keep-alive="false"></connection-pool>
    <anonymous-data-source user="mcs"password="mcs">
      <mcs-database host="myhost" port="1521" vendor="vendorName"
        source="mysource"/>
    </anonymous-data-source>
  </connection-pool>
</jdbc-repository>

Related topics