This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am using mysql database, where there is no schema concept, so i created different databases for different modules.
I am using connection pooling concept, And i'm implementing it in tomcat server,
it is going to create one pool for each database, i have 12 modules and if create those many no.of pools it would be a nightmare.
so what is the solution for this problem.