File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Connection pooling problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pooling problem" Watch "Connection pooling problem" New topic
Author

Connection pooling problem

bhargav shankar
Greenhorn

Joined: Jan 10, 2008
Posts: 8
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


bhargav
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

Hi..

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

Thanks..

Sorry, perhaps my english language isn't too good.. Prepare for SCJP 6, Please God help me.. ☼
References : [Java.Boot] [JavaChamp] [JavaPrepare]
bhargav shankar
Greenhorn

Joined: Jan 10, 2008
Posts: 8
There are about 50 tables , and more than 100 stored procedures in each database.
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

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..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection pooling problem
 
Similar Threads
data source and connection pooling ?
DataSouce without JNDI
Two hibernate.cfg.xml files?
code or server problem ?
Why close the connection, statement and resultset?