For Oracle RAC database provide the possibility to configure JDBC-URL

Current Situation

• The JOC setup provides the possibility of configuring database server name, port, database,
• For Oracle RAC database setup, since there are multiple database instances available for a single JDBC URL the configuration can look like this:

  jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
  (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604))
  (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604)))
  (CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))
  

Desired Behavior

• For Oracle database, during setup provide a possibility to enter JDBC-URL

Maintainer Note

It is already provided by the setup

• In a dialog installation use the "Host:" field in the "Database Connection Configuration" form
  • "Schema:" and "Port:" can remain empty
• In a batch installation use "databaseHost" entry

         <com.izforge.izpack.panels.UserInputPanel id="dbconnection">
             <userInput>
                 <entry key="databaseSchema" value=""/>
                 <entry key="databaseUser" value="???"/>
                 <entry key="databaseHost" value="(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) (CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))"/>
                 <entry key="databasePassword" value="???"/>
                 <entry key="databasePort" value=""/>
             </userInput>
         </com.izforge.izpack.panels.UserInputPanel>
  

• Further you can add a ready configured hibernate configuration file during the setup with

  <property name="hibernate.connection.url">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) (CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))</property>