Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-145

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

    XMLWordPrintable

    Details

    • Type: Feature
    • Status: Dismissed (View Workflow)
    • Priority: 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>
        

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: