User Tools

Site Tools


Database drivers shipped with EASA


Description Driver Name Links

Microsoft Access

sun.jdbc.odbc.JdbcOdbcDriver
Integrated Sun JDBC-ODBC-Bridge. Recommended by Sun only for development.

Microsoft Excel

sun.jdbc.odbc.JdbcOdbcDriver
Integrated Sun JDBC-ODBC-Bridge. Recommended by Sun only for development.

Database drivers from Database Vendors

Database Type Driver Name Download Links
MYSQL com.mysql.jdbc.Driver http://dev.mysql.com/downloads/connector/j/
MS SQL Server com.microsoft.sqlserver.jdbc.SQLServerDriver http://www.microsoft.com/en-us/download/search.aspx?q=jdbc
Oracle 8i/9i/10g oracle.jdbc.driver.OracleDriver http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
NOTE: Download thin JDBC driver for use with JDK1.2 and JDK1.3 (Ones for JDK 1.4 or higher will not work)
PostgreSQL org.postgresql.Driver http://jdbc.postgresql.org/download.html
Database Type URL
MYSQL jdbc:mysql://<HostName>:<PortNumber>/<DatabaseName>?<ParameterList>
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 jdbc:odbc:<OdbcName>

Text inside < > should be replaced 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)

URL Examples

  • MY SQL: jdbc:mysql://localhost:3306/test?autoReconnect=true
  • Oracle: jdbc:oracle:thin:@localhost:1521:TEST
  • MS Access: jdbc:odbc:db1
  • MS SQL Server: jdbc:sqlserver://localhost:4900;DatabaseName=test
  • PostgreSQL: jdbc:postgresql://localhost:5432/test