title: How do I close a java.sql.DataSource
body: <p>We have a system where data is partitioned by date.<br />
  So, for example, in SqlServer we have one database per month of data.  Each month partition uses a Jdbc driver Datasource wrapped in a C3P0 connection pool <code>DataSource</code>.</p>
  <p>After a period of time the date range of the partition becomes old enough that we want to offline it.  In that case we just remove the relevant month's <code>DataSource</code> from the available list.<br />
  However, ideally, when offlining I would like to &quot;close&quot; the <code>DataSource</code> so the pool relinquishes all connections to the DB.</p>
  <p><code>DataSource</code> has no close method for me to call so I'm not sure how to clean this up.</p>
  <p>Any suggestions?</p>