SET - Setups
  1. SET - Setups
  2. SET-145

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

    Details

    • Type: Feature Feature
    • Status: Dismissed (View Workflow)
    • Priority: Minor Minor
    • Resolution: Works as designed
    • Affects Version/s: 1.12
    • Fix Version/s: 1.12.6
    • Labels:
      None

      Description

      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>
        

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

            • Assignee:
              Alan Amos
              Reporter:
              Mahendra Patidar
              Approver:
              Mahendra Patidar
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: