Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagexml
titleExample: JobScheduler Database Connection in scheduler_install.xml
<com.izforge.izpack.panels.UserInputPanel id="dbconnection"> 
 
     <userInput> 
 
          <!-- JobSchedulerDatabase Configuration. --> 
 
          <!-- Enter the name or ip address of the database host. --> 
          <entry key="databaseHost" value=""/> 
      This entry   <!-- The "databaseHost" entry shouldcan also be used to configure the URL(s) for Oracle RAC databases.
                 For example: -->

                 <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)))"/>
     
           <!-- The "databaseSchema" and "databasePort" entries should then be left empty. -->
  
          <!-- Enter the port number <entry key="databaseHost" value=""/> 
          
          <!-- Enter the port number for the database instance. 
               Default ports are for 
                - MySql®: 3306, 
                - Oracle® Database: 1521, 
                - Microsoft® SQL Server: 1433, 
                - postgreSQL: 5432, 
                - IBM® DB2: 50000, 
                - Sybase: 5000. --> 
          <entry key="databasePort" value=""/> 
 
          <!-- Enter the schema --> 
          <entry key="databaseSchema" value=""/> 
 
          <!-- Enter the user name for database access --> 
          <entry key="databaseUser" value=""/> 
 
          <!-- Enter the password for database access --> 
          <entry key="databasePassword" value=""/> 
 
          <!-- You must provide the MySql®, Microsoft® SQL Server or Sybase JDBC® Driver respectively if you selected corresponding DBMS type. 
               For license reasons MySql®, Sybase and Microsoft® SQL Server JDBC® Drivers are not provided. 
               Alternatively you can use:
                - the MariaDB® JDBC® Driver for MySql® and 
                - the jTDS JDBC® Driver for Microsoft® SQL Server and Sybase which is provided.--> 
          <!-- You can choose between 'yes' or 'no' for using the jTDS JDBC® Driver 
               This entry has only an effect for Microsoft® SQL Server or Sybase --> 
          <entry key="connectorJTDS" value="yes"/> 
 
          <!-- You can choose between 'yes' or 'no' for using the MariaDB® JDBC® Driver 
               This entry has only an effect for MySql® --> 
          <entry key="connectorMaria" value="yes"/> 
 
     </userInput> 
 
</com.izforge.izpack.panels.UserInputPanel>

...

Code Block
languagexml
titleExample: Reporting Database Connection in scheduler_install.xml
<com.izforge.izpack.panels.UserInputPanel id="reportingDbconnection"> 
 
     <userInput> 
 
          <!-- ReportingDatabase Configuration 
               NOT SUPPORTED FOR SYBASE AND DB2 --> 
 
          <!-- Enter the name or ip address of the database host --> 
          <entry key="databaseHost" value=""/> 
    This entry can    <!-- The "databaseHost" entry should also be used to configure the URL(s) for Oracle RAC databases.
                 For example: -->

                 <entry key="reporting.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)))"/>
      
          <!-- The "reporting.databaseSchema" and "reporting.databasePort" entries should then be left empty. -->
          <entry key="reporting.databaseHost" value=""/>
  
          <!-- Enter the port number for the database instance. 
               Default ports are for: 
                - MySql®: 3306, 
                - Oracle® Database: 1521, 
                - Microsoft® SQL Server: 1433, 
                - postgreSQL: 5432. --> 
          <entry key="databasePort" value=""/> 
 
          <!-- Enter the schema --> 
          <entry key="reporting.databaseSchema" value=""/>  

          <!-- Enter the user name for database access --> 
          <entry key="reporting.databaseUser" value=""/> 
 
          <!-- Enter the password for database access --> 
          <entry key="reporting.databasePassword" value=""/> 
 
          <!-- You have to provide the MySQL or MS SQL Server JDBC driver respectively if you selected 
               corresponding DBMS type. For license reasons MySQL and MS SQL Server JDBC Drivers
               are not provided. Alternatively you can use the mariadb JDBC Driver for MySQL and the 
               jTDS JDBC Driver for MS SQL Server which are provided. --> 

          <!-- You can choose between 'yes' or 'no' for using the jTDS JDBC® Driver 
               This entry only affects MS SQL Server. --> 
          <entry key="reporting.connectorJTDS" value="yes"/> 
 
          <!-- You can choose between 'yes' or 'no' for using the MariaDB® JDBC® Driver 
               This entry has only an effect for MySql® --> 
          <entry key="reporting.connectorMaria" value="yes"/> 
 
     </userInput> 
 
</com.izforge.izpack.panels.UserInputPanel>

...