title: C3P0Connection properties
body: <p>Following is the my configuration file for <code>C3p0</code> connection pool. But after some time on starting my application all the connections are reaching to max connections i.e 200 and sitting in idle after that there are no connections are being used by application and if I hit my application URL from browser it is says that service temp unavailable.</p>
  
  <p>My application is client-socket connection application, on opening the connection from client I am doing the data insertions and updations on DB.</p>
  
  <pre><code>&lt;bean id="datasource" class="com.mchange.v2.c3p0.ComboPooledDataSource"&gt;
          &lt;property name="driverClass" value="org.postgresql.Driver" /&gt;
          &lt;property name="jdbcUrl"
              value="jdbc:postgresql://localhost/dbname" /&gt;
          &lt;property name="user" value="developer" /&gt;
          &lt;property name="password" value="developerPassword" /&gt;
          &lt;!-- &lt;property name="initialPoolSize" value="20"/&gt; --&gt;
          &lt;property name="minPoolSize" value="2" /&gt;
          &lt;property name="maxPoolSize" value="200" /&gt;
          &lt;property name="maxIdleTime" value="1" /&gt;
          &lt;property name="maxAdministrativeTaskTime" value="900" /&gt;
          &lt;property name="maxIdleTimeExcessConnections" value="2" /&gt;
          &lt;!-- &lt;property name="checkoutTimeout" value="300"/&gt; --&gt;
          &lt;!-- &lt;property name="maxStatements" value="500"/&gt; --&gt;
          &lt;property name="testConnectionOnCheckin" value="true" /&gt;
          &lt;property name="maxConnectionAge" value="60" /&gt;
          &lt;property name="unreturnedConnectionTimeout" value="1000" /&gt;
          &lt;property name="debugUnreturnedConnectionStackTraces" value="true" /&gt;
      &lt;/bean&gt;
  </code></pre>