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)
MS Access net.ucanaccess.jdbc.UcanaccessDriver (shipped with EASA)

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
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
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