title: how to manage connections to dynamically created databases
body: <p>I need to manage connections to multiple databases in my web app. following are facts regarding the current implementation:</p>
  
  <p>1- I use Tomcat</p>
  
  <p>2- databases are created dynamically at runtime ( i am using mysql)</p>
  
  <p>without a doubt, having a connection pool to manage database connections is optimal.
  Since the databases are not known at the start of the application, it was not possible for me to set up datasources and make connection pools. (I could not find a way in Tomcat to make dynamic connection pool: a connection pool that is created at runtime).</p>
  
  <p>my question is: what other options do I have to work efficiently with connections to multiple databases ? (I don't have experience to implement connection pools myself)
  is there any library that can be used with tomcat and allow me to establish multiple connection pools to different databases at runtime ? if not what do you suggest that I do instead of connection pools ? 
  i am fairly new with this issue therefore please correct and guide me if I am messing up concepts.</p>
  
  <p>Thank you in advance.</p>