Difference between revisions of "Setup4j"

From Commander4j Wiki
Jump to: navigation, search
(Created page with "File:Setup4j.jpg The setup utility shown below serves a number of purposes. * Defines how to connect to your database * Installs or Updates the Application tables in the...")
 
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[File:Setup4j.jpg]]
+
The Setup4j utility allows you to setup the database you want to use with Commander4j. The application supports 3 types of database
 +
<br><br>
 +
* mySQL
 +
* Microsoft SQL Server
 +
* Oracle
 +
<br>
 +
[https://www.youtube.com/watch?v=BgF1-zs3pT4&t=3s Video Tutorial]
 +
<br>
 +
<br>
 +
In addition to creating the tables needed for Commander4j the Setup4j also creates a file called hosts.xml which<br>
 +
is loaded at startup and displays a menu to allow you to select which database you want to connect to.
 +
<br><br><br>
 +
[[File:host_selection.jpg]]
 +
<br><br><br>
 +
The Setup4j will be needed to create the initial database when installing for the first time. It will also be used when<br>
 +
upgrading to a new version of the application.
 +
<br>
 +
[[File:Setup4j_buttons.jpg]]
 +
<br>
 +
The example hosts file which is installed during installation is purely for illustration purposes. You should create your <br>
 +
own entries which point to your own database(s).
 +
<br><br>
 +
Sytax for '''URL for Application Update'''
 +
<br><br>
 +
''file://servername/sharename/directory/updates.xml''
 +
<br><br>
 +
Sytax for '''URL for Hosts File Update'''
 +
<br><br>
 +
''//servername/sharename/directory/hosts.xml''
 +
<br><br>
 +
Below are 3 sample host configurations. One for each database type which is supported.
 +
<br><br><br>
 +
== mySQL ==
 +
<br>
 +
[[File:Setup4j_mysql.jpg]]
 +
<br><br><br>
  
The setup utility shown below serves a number of purposes.
+
== Microsoft SQL Server ==
 
+
<br>
* Defines how to connect to your database
+
[[File:Setup4j_mssql.jpg]]
* Installs or Updates the Application tables in the database
+
<br><br><br>
* Identifies which database is to be used by the Interface Service.
+
== Oracle ==
 +
<br>
 +
[[File:Setup4j_oracle.jpg]]

Latest revision as of 18:22, 14 July 2019

The Setup4j utility allows you to setup the database you want to use with Commander4j. The application supports 3 types of database

  • mySQL
  • Microsoft SQL Server
  • Oracle


Video Tutorial

In addition to creating the tables needed for Commander4j the Setup4j also creates a file called hosts.xml which
is loaded at startup and displays a menu to allow you to select which database you want to connect to.


Host selection.jpg


The Setup4j will be needed to create the initial database when installing for the first time. It will also be used when
upgrading to a new version of the application.
Setup4j buttons.jpg
The example hosts file which is installed during installation is purely for illustration purposes. You should create your
own entries which point to your own database(s).

Sytax for URL for Application Update

file://servername/sharename/directory/updates.xml

Sytax for URL for Hosts File Update

//servername/sharename/directory/hosts.xml

Below are 3 sample host configurations. One for each database type which is supported.


mySQL


Setup4j mysql.jpg


Microsoft SQL Server


Setup4j mssql.jpg


Oracle


Setup4j oracle.jpg