Can JDBC connection strings specify multiple databases?

Question

Here's my current connection string:

jdbc:amazon;moduleName=Foobar:oracle:thin:@ab1na-orasvr.db.foobar.com:42111:ab1na

But I need JDBC to access multiple databases. Can I simply append the second module name, separated by a semi-colon?

Sorry, this is a really basic yes/no question. Just want to be sure before I go chasing my tail. — Aaron Fi
– Aaron Fi, Commented Aug 11, 2009 at 17:13

sth · Accepted Answer · 2010-12-29 04:44:46Z

3

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST = (ADDRESS =(PROTOCOL=TCP)
(HOST=1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=2)(PORT=1521))(ADDRESS =(PROTOCOL=TCP)
(HOST=3)(PORT=1521))(ADDRESS =(PROTOCOL=TCP)
(HOST=4)(PORT=1521))(ADDRESS =(PROTOCOL=TCP)
(HOST=5)(PORT=1521))(ADDRESS =(PROTOCOL=TCP)
(HOST=6)(PORT=1521))(ADDRESS =(PROTOCOL=TCP)
(HOST=7)(PORT=1521))(ADDRESS =(PROTOCOL=TCP)
(HOST=8)(PORT=1521))(FAILOVER=on) (LOAD_BALANCE=ON)) 
(CONNECT_DATA = (SERVER=DEDICATED) 
(SERVICE_NAME =ccbfsinterface.comp.pge.com)))

edited Dec 29, 2010 at 4:44

sth

231k56 gold badges288 silver badges370 bronze badges

answered Dec 29, 2010 at 0:02

Max Monterrey

311 bronze badge

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

Comments

Peter D · Accepted Answer · 2009-08-11 17:18:08Z

2

No I don't think you can do this. You can do this with Hibernate though by creating multiple persistence units and creating entity managers based on the name you give each unit.

http://schuchert.wikispaces.com/JPA+Tutorial+1+-+Persistence+Unit

answered Aug 11, 2009 at 17:18

Peter D

4,9162 gold badges32 silver badges31 bronze badges

Collectives™ on Stack Overflow

Can JDBC connection strings specify multiple databases?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related