Servertec dbpools.ini
Content
Introduction
Release Notes
Features
FAQs
Requirements
Installation
Add-ons
How To
Change Log
Future Plans
Knowledge Base
Documentation
Conventions
Command Line
Administrator
Localization
Programming
Security
Performance
Deployment
Java API
Servlet API
CGI
SSI
Servlets
Config Files
acl.ini
aliases.ini
archives.ini
computers.ini
contexts.ini
country_codes.ini
dbpools.ini
groups.ini
hosts.ini
iws.ini
keystore.ini
locales.ini
logger.ini
messages.ini
mimetypes.ini
realms.ini
resources.ini
rights.ini
servlets.ini
session.ini
templates.ini
users.ini
workgroup.ini

Log Files
Classes
Directory Tree
Samples
Legal
Contact Us

 

dbpools.ini, contains Connection Pool definitions.

Syntax

name = driver=driver&url=url{&user=user_name}{&password=password}
&init_size=init_size&max_size=max_size&timeout=timeout{&key=value}...

driver the JDBC driver for the database.
init_size the number of connections to start off with when the server is started.

10 is the default value.

The initial size must be a value greater than 1.

key the id of any optional parameter used by the JDBC driver during the creation of the Connection Pool.
max_size the maximum number of connections to allow.

20 is the default value.

The value must be equal to or greater than the value for initial size.

name the name of the connection pool.
password any password associated with the specified user ID.

If not specified then null will be used.

timeout the maximum number of minutes that an inactive connection will remain open in the connection pool before it is closed.

30 minutes is the default value.

-1 is used to always keep the connection open in the pool while the server is running.

The number must be at least 1.

Setting this value too large or to -1 may result in database connection timeouts and setting this value to small may impact performance and memory requirements.

This parameter is ignored when Connection Pool Interval in Server, connection_pool_interval in iws.ini, is set to -1.

url the URL to the database.
user_name any user ID used to access the database.

If not specified then null will be used.

value the value of any optional parameter used by the JDBC driver during the creation of the Connection Pool.

Notes

Using connection Pools may improve a server's performance.

Changes made to configuration files will not be used until the server is restarted.

Example

iob = driver=sun.jdbc.odbc.JdbcOdbcDriver
&url=jdbc:odbc:iob
&init_size=10&max_size=20
 top of page
Copyright © 1998-2005 Servertec. All rights reserved.
Privacy Statement.
Last Modified: Sun Sep 04 14:56:49 EDT 2005