aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Several JDBC connections" Watch "Several JDBC connections" New topic
Author

Several JDBC connections

Colm Keogh
Greenhorn

Joined: Jan 18, 2002
Posts: 4
Hello,
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.
Thanks,
Colm.
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Several JDBC connections