Connection pool problem

Pavol Lackovič

Hi.

Pls help me with connection pool problem.

I start Jira and after some time raise active connection pool to maximum pool size value.

Then Jira is unusable and i have to restart service.

What is the problem?

My dbconfig:

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mssql</database-type>
  <schema-name>dbo</schema-name>
  <jdbc-datasource>
    <url>jdbc:jtds:sqlserver://XXX;instance=XXX</url>
    <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
    <username>XXX</username>
    <password>XXX</password>
    <pool-size>60</pool-size>
<pool-max-idle>15</pool-max-idle>
	<pool-min-size>10</pool-min-size>
	<pool-max-wait>5000</pool-max-wait>
	<pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>30</pool-remove-abandoned-timeout>
	<log-abandoned>true</log-abandoned>
  </jdbc-datasource>
</jira-database-config>

database monitor:

Thanks for help

Pavol Lackovič

we had problem with scripted fields:)

thanks for the answers