Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: 'JDBC' code blocks updated

...

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   <!-- This field 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 blankempty. -->
  
          <!-- Enter the port number for the <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: JobScheduler Database Driver in scheduler_install.xml
<com.izforge.izpack.panels.UserInputPanel id="jdbc"> 
 
     <userInput> 
 
          <!-- ConfigurationJobScheduler forDatabase JDBC® Driver Configuration -->
 
          <!-- You can specify an Thisexternal entryJDBC isconnector onlythen necessaryset ifinternalConnector the= packageno
 'Database Support' is chosen and 
         For license reasons MySQL, Sybase, MS youSQL selectedServer aand DBMS type like MySql®, Microsoft® SQL Server or Sybase in the previous <userInput> element. --> 
 
    Oracle ojdbc7 JDBC 
               drivers are not provided. 
      <!-- You must provide the MySql®, Microsoft® SQL Server orAlternatively Sybaseyou JDBC®can Driveruse respectivelythe ifmariadb youJDBC selectedDriver correspondingfor DBMSMySQL type.and 
               Forthe licensejTDS reasonsJDBC MySql®Driver andfor Microsoft®MS SQL Server JDBC®and DriversSybase arewhich notis provided. 
               SpecifyAn theOracle JDBC®ojdbc6 DriverJDBC source (e.g. mysql-connector-java-*.jar for MySql®, sqljdbc.jar for Microsoft® SQL Server, jconn3.jar for Sybase). 
driver is also provided.
               An internal JDBC connector for DB2 is not Alternatively you can use:available -->

          <!-- You can choose between 'yes' -or the'no' MariaDB®for JDBC®using Driverthe forinternal MySql®JDBC andconnector
 
              or not - the jTDS JDBC® Driver for Microsoft® SQL Server and Sybase, which is provided. --> ->
               <entry key="internalConnector" value="yes"/>

            <!-- Select the path to JDBC® Driver --> 
               <entry key="connector" value=""/> 
 
          <!-- Only for DB2: Select the path to DB2 license file for JDBC Driver -->
               <entry key="connectorLicense" value=""/>
            
     </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  Configuration 
               NOT SUPPORTED FOR SYBASE AND DB2 --> 
 
          <!-- Enter the name or ip address of the database host 
                 This entry can 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)))"/>
               NOT SUPPORTED FOR SYBASE AND DB2 --> 
 
          <!-- Enter the name or ip address of the database hostThe "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>
Code Block
languagexml
titleExample: Reporting Database Driver in scheduler_install.xml
<com.izforge.izpack.panels.UserInputPanel id="reportingJdbc"> 
 
     <userInput> 
 
          <!-- Reporting Database Configuration 
               NOT SUPPORTED FOR SYBASE AND DB2 -->
           NOT SUPPORTED FOR SYBASE AND DB2 -->
 
          <!-- You can Configurationspecify foran JDBC®external DriverJDBC 
connector then set reporting.internalConnector = no
          This entry is only necessary ifFor thelicense packagereasons 'Database Support' is chosenMySQL, MS SQL Server and 
Oracle ojdbc7 JDBC 
            you selected a DBMSdrivers typeare likenot MySql®,provided. Microsoft®
 SQL Server or Sybase in the previous 
       Alternatively you can use the mariadb JDBC Driver <userInput>for element. --> 
 MySQL and 
          <!-- You have to provide the jTDS JDBC MySQLDriver orfor MS SQL Server JDBCand driverSybase respectivelywhich if you selectedis provided. 
               correspondingAn DBMSOracle type.ojdbc6 ForJDBC licensedriver reasonsis MySQLalso and MS SQL Server JDBC Drivers are 
provided. -->
                
   not provided. Specify the JDBC Driver source (e.g. mysql-connector-java-*.jar for MySQL, 
        <!-- You can choose between 'yes' or 'no' for using the internal JDBC connector
        sqljdbc.jar for MS SQL Server). Alternatively you canor use the mariadb JDBC Driver for 
not -->
               <entry key="reporting.internalConnector" value="yes"/>
   MySQL and the jTDS JDBC Driver for MS SQL Server which is provided. --> 

          <!-- Select the path to JDBC®JDBC Driver -->
     
          <entry key="reportingconnectorreporting.connector" value=""/> 
 
     </userInput> 
 
</com.izforge.izpack.panels.UserInputPanel>

...