User Tools

Site Tools


Database drivers in EASA

EASA ships with Java database drivers for both MySQL and Microsoft Access.

Here we provide details to configure other database drivers.

  • download, install and test a driver on a running EASA Server via
    • EASA→Set Mode→Administrator→Configure
      • →Configure Drivers
      • →Configure Databases
  • restart the EASA Server

For more general database info see EASA database migration

Database Type Driver Name
Download Link
MYSQL com.mysql.jdbc.Driver (shipped with EASA)
https://dev.mysql.com/downloads/connector/j/
MS Access net.ucanaccess.jdbc.UcanaccessDriver (shipped with EASA)
http://ucanaccess.sourceforge.net/site.html

MS SQL Servercom.microsoft.sqlserver.jdbc.SQLServerDriver
https://www.microsoft.com/en-us/download/search.aspx?q=jdbc
Warning, 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
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>:<PortNumber>/<DatabaseName>?<ParameterList>
MS Access jdbc:ucanaccess:///<path-to-database-data> (note the three slashes)
MS SQL Server Jdbc:sqlserver://<HostName>:<PortNumber>;DatabaseName=<DatabaseName>
Oracle 8i/9i/10g jdbc:oracle:thin:@<Domain>:<PortNumber>:<DatabaseName>
PostgreSQL jdbc:postgresql://<HostName>:<PortNumber>/<DatabaseName>
ODBC not supported (from Java 8 onward)
  • <text-inside-tags> should be replaced (including tags) according to the specific database configuration,
    • HostName → Domain or machine name where the database is installed
    • PortNumber → Port Number where the database listens for connections
    • DatabaseName → The database name
    • ParameterList → Some databases allow a list of parameters as a part of the URL
    • Domain → Account domain name to log in to the database (Oracle)
    • path-to-database-data → three slashes and then the absolute path to a file
  • URL examples
    • MySQL → jdbc:mysql://localhost:3306/test?autoReconnect=true
    • Oracle → jdbc:oracle:thin:@localhost:1521:TEST
    • MS Access → jdbc:ucanaccess:///Users/easa-user/StockData.mdb
    • MS SQL Server → jdbc:sqlserver://localhost:4900;DatabaseName=test
    • PostgreSQL → jdbc:postgresql://localhost:5432/test

Page Tools