A Java Database Connectivity (JDBC) driver is required for the NetX application to communicate with a database. We recommend the following JDBC drivers for use with NetX. For a list of databases that are supported for use with NetX, see Supported Platforms.
The drivers listed below are supported for the latest release of NetX. If you are running an earlier version of NetX, please contact Support for information on the supported JDBC driver for your instance.
Database | JDBC Driver |
---|---|
MySQL |
Connector/J 8.0 for MySQL: https://dev.mysql.com/downloads/connector/j/8.0.html Notes: Downloading the platform-independent version is the quickest way to obtain the jar file. The jar file should be named something like mysql-connector-java-8.0.27.jar. |
Microsoft SQL Server |
Microsoft JDBC Driver 7.0 for SQL Server: https://www.microsoft.com/en-us/download/details.aspx?id=57175 Windows: Download sqljdbc_7.0.0.0_enu.exe Linux: Download sqljdbc_7.0.0.0_enu.tar.gz Notes: The 7.0 package contains two jar files, please use the one named mssql-jdbc-7.0.0.jre8.jar. |
Installing the driver
Once downloaded, JDBC driver .jar files should be copied into {NetX installation directory}\webapps\ROOT\WEB-INF\lib. Please ensure that only one JDBC .jar file is located inside that directory at a time, or the system will arbitrarily choose a driver to load. NetX must be restarted before it can recognize a new JDBC driver, so it's best to copy the driver into the lib directory while NetX is shut down.