Homepage | About EASA | Contact
Sidebar
Table of Contents
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