In master-datasources.xml (wso2is-5.0.0/repository/conf/datasources) you
can increase the database connection pool size by
increasing <maxActive>50</maxActive> property.
<datasource>
<name>WSO2_CARBON_DB</name>
<description>The datasource used for registry and user
manager</description>
<jndiConfig>
<name>jdbc/WSO2CarbonDB</name>
</jndiConfig>
<definition type="RDBMS">
<configuration>
<url>jdbc:h2:repository/database/WSO2CARBON_DB;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=60000</url>
<username>wso2carbon</username>
<password>wso2carbon</password>
<driverClassName>org.h2.Driver</driverClassName>
<maxActive>50</maxActive>
<maxWait>60000</maxWait>
<testOnBorrow>true</testOnBorrow>
<validationQuery>SELECT 1</validationQuery>
<validationInterval>30000</validationInterval>
</configuration>
</definition>
</datasource>
Hope this will help. Thanks.
On Mon, Jul 7, 2014 at 11:55 AM, Daya Attapattu <[email protected]> wrote:
> I am trying to run 400 users (400 threads on jmeter) on identity server.
> IS fails with the following message:
>
> ERROR {org.wso2.carbon.registry.core.dataaccess.TransactionManager} -
> Failed to start new registry transaction.
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data
> source rejected establishment of connection, message from server: "Too
> many connections"
>
> Is there any configuration parameter that I can use to facilitate a larger
> number of threads?
>
> Regards, Daya
>
> --
> Daya Atapattu
> WSO2 Inc.
> Phone: +94 77 047 4730, +1 203 484 7099
>
>
> _______________________________________________
> Dev mailing list
> [email protected]
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>
>
--
Prasad Tissera
Software Engineer.
Mobile : +94777223444
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
