File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked 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 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 these 3 database are changed yearly as u can c "04" at last.

Plz guide me.

Love is GOD and GOD is Love.
Anand Karia
IT Concretor.......
M/s. Anand Karia Concreting IT
Ashish Vegaraju
Ranch Hand

Joined: Aug 19, 2004
Posts: 47

r u sure u have 3 separate datatbases? i think these r 3 diff tables in a database!! well whatever....u can create 3 diff connections to access the data. i think their should'nt be any problem with that.

correct me if i m wrong.
[ October 18, 2004: Message edited by: Ashish Vegaraju ]
Jessica Sant

Joined: Oct 17, 2001
Posts: 4313

We've got an entire forum dedicated to DB questions like this. I'm going to move this to the JDBC forum.
So please post your replies there. Thanks!


Ahh... it looks like you've already posted this thread here. Please don't post duplicate threads in multiple forums. It makes a conversation difficult to follow. Please post your replies in the original thread.
[ October 18, 2004: Message edited by: Jessica Sant ]

- Jess
Blog:KnitClimbJava | Twitter: jsant | Ravelry: wingedsheep
I agree. Here's the link:
subject: Multiple database multiple conneciton problem.
jQuery in Action, 3rd edition