title: How to create and maintain one jdbc connection per user in web app (Spring/Vaadin)?
body: <p>How to create an application which can handle thousand of jdbc connection at runtime without implementing connection pool ? AFAIK to establish connection pool, we need <strong>username</strong>, <strong>passowrd</strong> and required <strong>dbinstance url</strong> but here all of them will be provided at runtime to connect particular database, and there would be more than 1000 user at one time to connect to set of databases.(memory intensive !)<br>
  So typically it going to be like this:  </p>
  
  <p><strong>Users</strong>: User-A,User-B,User-C.....User-n<br>
  <strong>db</strong>:  DB1, DB2, DB3....DBn</p>
  
  <p>Can anyone please guide me how can I achieve this task ?<br>
  I only have one thing in my mind, i.e. to create single connection with each session and use it whereever required specific to that user.</p>
  
  <p>I've used Apache Commons DBCP2 for connection pooling, MyBatis-Spring implementation, Spring and Vaadin for different application but not sure if anyone of them gonna help me !</p>