How to set maximum number of jdbc-connection to datasource

[suhov_vb]

We use JasperReports Server Community Edition (v. 5.2). We use jdbc source in our reports. I noticed that JasperServer opens maximum 5 connections to the source and next attempts to open a connection wait for connection release. I'd like to increase that limit. I tried to follow next document:

http://community.jaspersoft.com/wiki/how-tune-number-connections-server-database-pool

But changes to context.xml (and restart tomcat) didn't affect on the number of opening connections.

Please help us to set it.

[hozawa]

JasperReports Server uses jdbc pooling. You just need to increase the number of jdbc connections used in a pool.

[suhov_vb]

You just need to increase the number of jdbc connections used in a pool.

But how to do it? I tried to control it via maxActive parameter of the Resource element in the /etc/tomcat6/Catalina/localhost/jasperserver.xml and /META-INF/context.xml in JasperServer install dir. Both didn't work.

[suhov_vb]

I solved the problem. There are 2 possible answers:

1. Change DataSource pool size parameter (second argument) of dataSourceObjectPoolFactory bean constructor in /jasperserver/WEB-INF/applicationContext.xml file (default is 5):

    <bean id="dataSourceObjectPoolFactory" class="org.apache.commons.pool.impl.GenericObjectPoolFactory">
        <constructor-arg type="org.apache.commons.pool.PoolableObjectFactory"><null/></constructor-arg>
        <constructor-arg type="int" value="15"/>
    </bean>

Reload application after saving changes.

2. Use JNDI source instead of JDBC source and set JNDI connection following JasperReports Server Admin Guide or Appache Tomcat documentation: http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html