You can set database connection pool parameters via your app-server.
Check the install guide:
9.3 Using Server-provided database and mail resources
There's a Tomcat example in 9.3; If you are not running on Tomcat
you'll have to consult your app server docs.
- Dave
On Thu, Jun 4, 2009 at 1:35 PM, Sarah Northway <sa...@threerings.net> wrote:
> Emmanouil Batsis (Manos) wrote:
>>
>> Sarah Northway wrote:
>>>
>>> We use Roller for a dozen small blogs, and are having an issue with it
>>> opening up nearly 500 MySQL connections and choking up our database server.
>>> Is this expected behavior?
>>>
>>> Is there a standard way to configure Roller to limit its db sessions to a
>>> more reasonable number?
>>
>> From what I remember you should be able to easily configure the max
>> connections etc. in roller-custom.properties. Check the installation manual
>> ;-)
>
> If it's in the installation guide I haven't been able to find it, which is
> why I'm asking here. :)
>
> You may be thinking of the "MaxActive" attribute which can appear in
> context.xml when connecting to a database through Tomcat, but we aren't
> doing that. The section on db configuration in roller.properties doesn't
> mention connections (we are using jdbc):
>
> #---------------------------------
> # Database configuration settings
> # Specify database configuration type of 'jndi' or 'jdbc'
> database.configurationType=jndi
> # For database configuration type 'jndi',this will be used
> database.jndi.name=jdbc/rollerdb
> # For database configuration type of 'jdbc', you MUST override these
> database.jdbc.driverClass=
> database.jdbc.connectionURL=
> database.jdbc.username=
> database.jdbc.password=
>
> Can anyone point me at the configuration property I'm looking for?
>
> - Sarah
>
