
Patch: w502_070920_0078_querybuilder.zip

Install Instructions: Unzip this patch into the server installation folder.  This replaces the querybuilder.war file in the 
applications folder and includes all fixes detailed below.  Any custom settings in the WEB-INF/web.xml file should be propagated into the web.xml file
contained within this patch war.

Case Num: 5469

Description: 05/02/2007 Added the ability for MMDataSource to support connection-time fail-over through the use of setAlternateServers() and getAlternateServer().  The methods take and return a string of comma delimited servers with an optional :port for each server.  If :port is not specified the portNumber set on the MMDataSource is used.  For example: 

       setServerName(“mymmserver”);
       setPortNumber(31000);
       setAlternateServers(“mymmserver:31001,mymmserver2:31000,mymmserver2:31001”);
       
       This would allow connections to be attempted mymmserver:31000, mymmserver:31001, mymmserver2:31000, and mymmserver2:31001.  Because portNumber has been set to 31000, the following would be the same:

       setServerName(“mymmserver”);
       setPortNumber(31000);
       setAlternateServers(“mymmserver:31001,mymmserver2,mymmserver2:31001”);
       
       Note that :31000 was omitted from the setAlternateServers() method.
    
