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.
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.