• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Several JDBC connections

 
Colm Keogh
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic