Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection pooling problem

 
bhargav shankar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

please help..

awaiting the answer


Thanks in advance
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi..

may i know, how many estimation tables for each modules?..
how about if you merge all of that it in one database?..

Thanks..
 
bhargav shankar
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are about 50 tables , and more than 100 stored procedures in each database.
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does all databases would be used in your application? or only several tables?..
and then do you use JDBC in your application or ORM?..

how about if you set your connection pool to "information_schema" database?..
and then if you want to do data manipulation, you have to attach database name of each own module...

assume that you want to select data from Table1 in database named Module1, and the query would be :

Select * From Module1.Table1;


and you could use the same way (through attach the database name) to do other data manipulation such as insert, delete, and so on..

Correct me if i'm wrong..
Thanks..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic