Hi all,
does MwS support full-blown connection descriptors like the following for its own database (set by URL parameter in mws.db.xml file)?

jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host4)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = servicename)))

I’m asking because our system, which had been set up by consultants, does only use a simple connection string to a single host which, of course, does not enable failover handling nor load-balancing.

Best regards,
Marcus

Yes it does as it uses oracle drivers and those drivers support full-blown connection descriptors.

Hi Senthil,
that’s interesting. The answer I got from the SAG support team was a bit different: They told me that MwS is shipped with the Progress DataDirect driver which uses a different connection URL syntax - though it should still support failover.

Best regards
Marcus