Versions Compared

Version Old Version 9 New Version 10
Changes made by

Fiona Sargeant

Fiona Sargeant

Saved on

Key

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

This page is for administrators who need to connect PhixFlow to external databases using Driver Classes.

...

Tip

Your PhixFlow instance is installed on a database, either MariaDB, SQL Server or Oracle. PhixFlow uses the appropriate driver class to communicate with its own database.

...

To find out which (usually JDBC)  database drivers you require, read the documentation for your database. Also check check the  System Requirements and Compatibility page. 

  1. An administrator with permission to add system files must download the required JDBC drivers and save them to the system.
    To avoid your drivers being overwritten during Tomcat or PhixFlow upgrades, we recommend that you save them in a different part of the your file system. 

  2. The PhixFlow administrator configures a driver class for the JDBC drivers by adding to the repository Driver Classes, specifying the database driver name and its path.

...

To add a new driver, right-click Driver Classes and select 

Insert excerpt
_add
_add
nopaneltrue
. PhixFlow opens a property tab where you can enter the details for the new driver.

...

The driver classes configured in the repository populate the the the drop-down list in

Insert excerpt
_datasource
_datasource
nopaneltrue
 properties Basic Settings → Driver Class. 

...

FieldDescription

Name

Enter a unique name for the driver, which will appear in the PhixFlow repository.
Driver Class Name

Enter the driver class name, which you will find in the driver documentation. For example, for MySQL, the driver name is: com.mysql.jdbc.Driver

System Defined

Read-only.

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 indicates this driver class is custom defined for your PhixFlow instance.

Insert excerpt
_check_box_ticked
_check_box_ticked
nopaneltrue
 indicates this driver is preconfigured when PhixFlow is installed. It is required for the system and cannot be updated.

DescriptionOptionally enter a description for the driver.

Driver Class File

This section has a toolbar with standard buttons.

The grid contains a list of jar files and their file path.  To add a jar file to the list:

...

  • are exported and then imported to other instances
  • have access to the database driver jar file from the other instances.

This ensures that  that all datasource objects that use the database driver continue to work on the other instances. 

How PhixFlow Decides Which Driver to Use

(Needed??) The PhixFlow is configured with a class path for finding drivers. This will use the first appropriate driver it finds in the following locations:

  1. The driver classes you configure In PhixFlow.
  2. The system driver classes.
  3. Database drivers in the Tomcat class directory.
  4. Database drivers in the Tomcat lib directory.

...