Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases and the fly likes Several JDBC connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Several JDBC connections" Watch "Several JDBC connections" New topic

Several JDBC connections

Colm Keogh

Joined: Jan 18, 2002
Posts: 4
I want to connect to several databases one after the other using JDBC (about 20 in total). What's the best approach/technique to use, I have no problem connecting to a single database.
The only difference in each URL is the IP address.
Graeme Brown
Ranch Hand

Joined: Oct 13, 2000
Posts: 193
What is the problem? Are you wanting to do the same thing on each database, or different things?
There is nothing stopping you connecting to a database, doing some stuff, disconnecting then going on to the next one. You can put this in a loop if you want to do the same stuff to each database. You can connect to multiple databases at the same time if you want.
Have you tried LearnNowOnline?
subject: Several JDBC connections