JDBC connection problem

[kanghao]

What's the difference the value of "rm.oracle.db.url" case A, and case B
why the url A is not working?

Thanks in advance.

========= Java source =======

Class.forName(conf.get("rm.oracle.db.driver"));
con = DriverManager.getConnection(conf.get("rm.oracle.db.url"),
conf.get("rm.oracle.db.user"),
conf.get("rm.oracle.db.password"));


====== configuration file =====

rm.oracle.db.user=APUSER
rm.oracle.db.password=APUSER

A(not working)
rm.oracle.db.url=jdbcracle:thin(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=11.111.111.122)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=11.111.111.132)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORAKIPO1))))
B(working)
rm.oracle.db.url=jdbcracle:thin11.111.111.122:1522:ORAKIPO1

 

[sedj]

Your first URL looks like a mangled TNSNAMES.ORA entry - not sure if thats valid.
I'd just use the second URL ...

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[ascotta]

My opinion for what its worth is that the first looks awfully complicated and there is probably a typo in there, or parameters not required. Where as the second is pretty self explanatory. ie address port server.

[blue] Oh you know, just doing what I do.[/blue]

Cheers
Scott