File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Multiple database multiple conneciton problem. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Meteor in Action this week in the JavaScript forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Multiple database multiple conneciton problem." Watch "Multiple database multiple conneciton problem." New topic

Multiple database multiple conneciton problem.

Anand Karia
Ranch Hand

Joined: Sep 25, 2004
Posts: 156

Dear All!

Wht should i ve 2 do more in this DBConnection class if i ve multiple databases.

like i ve
1. dbAccount04
2. dbSale04
3. dbPurchase04

While working in dbAccounts i also have 2 get result from dbSale and dbPurchase in single form.

plz be informed that that 3 database are changed yearly.

Plz guide me.

Love is GOD and GOD is Love.
Anand Karia
IT Concretor.......
M/s. Anand Karia Concreting IT
somkiat puisungnoen
Ranch Hand

Joined: Jul 04, 2003
Posts: 1312
You should be used Data Access Object Pattern to solve this problem.

This will help you.

Java Developer, Thailand
I agree. Here's the link:
subject: Multiple database multiple conneciton problem.