File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Making Connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Making Connections" Watch "Making Connections" New topic

Making Connections

Shreya Menon
Ranch Hand

Joined: Jul 31, 2001
Posts: 285
Hi all,
I have to write a servlet, or a Java class which calls 2 databases and selects some values from 2 tables.
That is, when I come to that servlet, at first the servlet has to Select values x,y and Z from table A. Then this servlet has to select values r,t,y from table B.
But table A and table B exist in two databases ans at 2 locations. I am getting connections to the 2 locations, so it is okay.
But my qn is can I do this in a single servlet ?
Any suggestions welcome
Manoj Singh
Ranch Hand

Joined: Aug 10, 2000
Posts: 41
Yes you can ! you just have to use two different Connection objects .

Sun Certified Java 2 Programmer<BR>" Only those who will risk going too far can possibly find out how far one can go "
Shreya Menon
Ranch Hand

Joined: Jul 31, 2001
Posts: 285
Thanks Manoj.
I agree. Here's the link:
subject: Making Connections
It's not a secret anymore!