title: Can I use one pooled datasource for multiple databases with Spring/Hibernate/c3p0?
body: <p>Our application uses Spring/Hibernate for database access. We use multiple hibernate session factories (<code>hibernate3.LocalSessionFactoryBean</code>), because the data is in a number of separate databases. Each session factory is configured with a pooled datasource using c3p0 (<code>c3p0.ComboPooledDataSource</code>). </p>
  
  <p>As it happens, the databases all reside on the same db server. Our issue is that we end up with a number of db connection pools, all connecting into the same server. Is there any way of sharing one pooled datasource for access to multiple databases on the same server? Is it possible to configure the <code>jdbcUrl</code> at the session factory level, instead of at the datasource level? </p>
  
  <p>Or is this not a real issue in practice? Is it perfectly ok to have multiple db connection pools configured? </p>