aspose file tools*
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
JavaRanch » Java Forums » Java » Java in General
Bookmark "Multiple database multiple conneciton problem." Watch "Multiple database multiple conneciton problem." New topic
Author

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.

http://java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html

This will help you.


SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Multiple database multiple conneciton problem.