EASA ships with a Java database driver for MySQL.
Here we provide details to independently download (for licensing reasons) and configure other database drivers.
EASA software is tested to be compatible with the following databases:
Database Type | Driver Name Download Link |
---|---|
MYSQL | com.mysql.jdbc.Driver (shipped with EASA) https://dev.mysql.com/downloads/connector/j/ |
MS SQL Server | com.microsoft.sqlserver.jdbc.SQLServerDriver Insure database-jdbc driver compatibility and download a driver Update to at least 4.1 to avoid a bug in 4.0 (2008) which causes saved-then-retrieved dates to be two days younger 4.2 or later is recommended |
Oracle 8i/9i/10g | oracle.jdbc.driver.OracleDriver https://www.oracle.com/technetwork/database/features/jdbc/index-091264.html Use thin JDBC driver for use with JDK 1.2 or 1.3, drivers for 1.4 or higher will not work |
PostgreSQL | org.postgresql.Driver https://jdbc.postgresql.org/download.html |
Database Type | URL |
---|---|
MYSQL | jdbc:mysql://<hostname>:<port-number>/<database-name>?<parameter-list> |
MS SQL Server | Jdbc:sqlserver://<host-name>:<port-number>;DatabaseName=<database-name> |
Oracle 8i/9i/10g | jdbc:oracle:thin:@<domain>:<port-number>:<database-name> |
PostgreSQL | jdbc:postgresql://<host-name>:<port-number>/<database-name> |
ODBC | not supported (from Java 8 onward) |
<text-inside-tags> should be replaced (including tags) according to the specific database configuration:
URL examples: