Ashish:
as of the latest release of
jdbc(not including the jdk 1.4 beta) you can only have one connection per statement/prepared statement. So you can not do this in
java as you would need two different connections if you were to join 2 tables from different databases in one statement.
You can have 2 different connections open at the same time, but you can only have 1 connection for a statement.
Jamie
[This message has been edited by Jamie Robertson (edited September 24, 2001).]