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
