[Opensource] min/max db connections?

[Michael Rimov]

At 11:20 AM 7/10/2002 -0700, you wrote:
>sorry if these are dumb questions:
>
>expresso-config.xml has a <jdbc> tag which contains connection-pool 
>information.  however, this tag doesn't seem to have min/max settings for 
>the number of connections, though these limits are mentioned in the 
>edg.pdf doc pg. 14 (see <jdbc> attribute list quoted at bottom).

There are no min settings.  The Setup table can be used to specify the 
maximum number of connections.



>meanwhile, the unused <data-sources> tag in struts-config.xml does have 
>min/max attributes, but expresso doesn't use this, right?

Correct.


>** how can I control the DB connection pool min/max number of connections?

Can't control the min.... Use the setup table to control the max.


>** what are the defaults? (I ran into a problem that after 3 days of no 
>hits, my DB connection pool could not instantiate a connection.)

5 connections.

Taking a cursory glance at the source code, I can't seem to find where the 
connection timeout is considered when bringing up a new conneciton.  You 
CAN use connection testing, but that tests each and every time you grab a 
connection and I'd rather have a long-unused connection timeout.  I think 
you've found a bug there.


                                                         -Mike