Reference two databases with Connection in java

Question

I have two local databases I'm trying to connect to using Java's Connection class. It's easy enough to connect to the first database using:

public Connection conn;
conn = DriverManager.getConnection(connectionString);

How can I add a second database to that same connection? They're both on the same server so it should be fairly simple but I can't find the right commands to do it.

Thanks

why do you want to connect two databases from the same connection? to replicate? — Low Flying Pelican
– Low Flying Pelican, Commented Oct 25, 2011 at 7:44
say if you have table1 in db1 and table2 in db2, so you need to run queries joining table1 and table2? — Low Flying Pelican
– Low Flying Pelican, Commented Oct 25, 2011 at 9:05
More like, I have table1 in db1 with columns id1 and id2, and table2 in db2 with columns id1 and id3, and I want to update id3 in table2 conditional on id2 having certain values in table 1 where t1.id2 = t2.id2 — Zain Rizvi
– Zain Rizvi, Commented Oct 25, 2011 at 9:33

socha23 · Accepted Answer · 2011-10-25 07:44:31Z

9

A Connection is a session with a specific database. You can't use one Connection to communicate with two different databases; for that, you need two separate Connections.

Connection conn1 =  DriverManager.getConnection(connectionString1);
Connection conn2 =  DriverManager.getConnection(connectionString2);

answered Oct 25, 2011 at 7:44

socha23

10.3k3 gold badges31 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zain Rizvi Over a year ago

That's the workaround I was using but I was hoping there would be a better way to do it

Rohith · Accepted Answer · 2011-10-25 07:44:02Z

2

Have you tried:

public Connection conn1;
conn1 = DriverManager.getConnection(connectionString1);
public Connection conn2;
conn2 = DriverManager.getConnection(connectionString2);

answered Oct 25, 2011 at 7:44

Rohith

2,1111 gold badge17 silver badges42 bronze badges

Comments

user207421 · Accepted Answer · 2011-10-25 07:44:22Z

1

Instance members shouldn't be public.
Connection should be a local variable, not an instance member.

You can only connect to one database at a time with a single Connection. Ergo you need another Connection.

answered Oct 25, 2011 at 7:44

user207421

312k45 gold badges324 silver badges493 bronze badges

2 Comments

Zain Rizvi Over a year ago

Thanks, but I was already following 1 and 2 in my code, I'd just simplified it for the example here.

user207421 Over a year ago

@Zain I don't see how that simplifies anything. Actually it just wastes your time and mine.

Low Flying Pelican · Accepted Answer · 2011-10-25 09:10:35Z

0

I think you have to use J2EE, JTA transaction manager to accomplish this.

answered Oct 25, 2011 at 9:10

Low Flying Pelican

6,0621 gold badge36 silver badges44 bronze badges

4 Comments

Low Flying Pelican Over a year ago

Using 2 connections is not very transaction safe. With JTA transaction manager it is possible to achieve this functionality in transparent manner,stackoverflow.com/questions/1961566/…

user207421 Over a year ago

I would have thought using two connections wasn't transaction-safe at all, but that statement isn't the same thing as 'you have to use'. OP has said nothing about transaction safety across the databases being a requirement, nor about being in a J2EE environment where JTA is even available.

Low Flying Pelican Over a year ago

since it says, 'How can I add a second database to that same connection', using of two connections does not seems to be the option as I think. So what left is to access databases in transaction safe manner that is why i suggested to use JTA, as I am not aware of any other mechanism to achieve this.

user207421 Over a year ago

The other mechanism is to rejectb the terms of the question, as everyone else has done.

Collectives™ on Stack Overflow

Reference two databases with Connection in java

4 Answers 4

1 Comment

Comments

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related