Setup should not add :: to connection string if database schema and port are empty

Current Situation

• The JobScheduler Setup is not able to manage TAF (Service) configurations for JDBC drivers.
• For example a connection string for an Oracle RAC cluster with TAFService might contain:

  (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XXXXX_TAF.DOMAIN.COM)
  (FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
  

• If the values for schema and port are empty during setup (auto installation with xml file) then the installer sets the colons as if these values were present:

  ...  )(METHOD=BASIC)(RETRIES=180)(DELAY=5))))::
  

• As a result a connection to the database is not possible. The workaround is to remove the colons :: manually.
• These files are affected druing installation:
  • sos_settings.ini
  • factor.ini
  • hibernate.cfg.xml
• Sample excerpt from the auto installation XML file:

  </com.izforge.izpack.panels.UserInputPanel>
  <com.izforge.izpack.panels.UserInputPanel id="dbconnection">
  <userInput>
  
  <entry key="databaseHost" value="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(LOAD_BALANCE=yes))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxx_TAF.xxxDOMAIN.COM)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))"/>
  
  <entry key="databasePassword" value="xxxxxxx"/>
  <entry key="databaseUser" value="xxxxxxxx"/>
  <entry key="databaseSchema" value=""/>
  <entry key="databasePort" value=""/>
  

Desired Behavior

• The JobScheduler Setup should omit colons for missing values of schema and port.

Workaround

• Add the setup parameters directly to the jobscheduler_install.xml file of the installer and run the installer in headless mode.
• More information on this "batch" mode can be found in the JobScheduler installation instructions, see http://www.sos-berlin.com/jobscheduler-documentation