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.
Joined: Oct 13, 2000
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.