JDBC settings

Top  Previous 

The JDBC Drivers node controls what JDBC drivers may be used by JSCAPE MFT Server when storing account and/or log information in a relational database.

 

JDBC driver downloads

Adding a JDBC driver

 

 

Figure 73

 

clip0073

 

 

JDBC driver downloads

 

Microsoft SQL Server JDBC Driver

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

 

Oracle JDBC Driver

http://www.oracle.com/technology/tech/java/sqlj_jdbc/index.html

 

MySQL JDBC Driver

http://dev.mysql.com/downloads/connector/j/5.1.html

 

PostgreSQL JDBC Driver

 

https://jdbc.postgresql.org/

 

 

Adding a JDBC driver

 

1.  Place the JDBC driver JAR file in the libs/jdbc directory of your JSCAPE MFT Server installation.

2.  Shutdown JSCAPE MFT Server Manager and JSCAPE MFT Server Service.

3.  Restart JSCAPE MFT Server Manager and JSCAPE MFT Server Service.

4.  From JDBC drivers panel click on the Add button.  When prompted enter the JDBC driver class and press enter.

 

Note: Should you wish to use a downloaded MySQL driver instead of the pre-installed MariaDB driver, make sure you include the ?disableMariaDbDriver argument in your JDBC URL when connecting to a MySQL v 8.x. For example:

 

jdbc:mysql://localhost:3306/mftserver?disableMariaDbDriver