[Opensource] min/max db connections?

[larry hamel]

thanks for the info!

FYI, I've used the poolman tools for db connection pooling before with success.  http://sourceforge.net/projects/poolman/  .  looks like they do object caching too nowadays.

larry

At 10:23 PM 7/10/2002, Michael Rimov wrote:
>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
>
>_______________________________________________
>Opensource mailing list
>Opensource at jcorporate.com
>http://mail.jcorporate.com/mailman/listinfo/opensource
>Archives: http://mail.jcorporate.com/pipermail/opensource/