Appboard/2.5/admin/db drivers: Difference between revisions

imported>Jason.nicholls
No edit summary
imported>Jason.nicholls
No edit summary
Line 7: Line 7:
{{Tip|For convenience and best practice it's recommended to add the drivers required in your environment to the custom export properties file. This way archives will include the drivers and they will not have to be installed separately. Refer to the [[appboard/2.5/admin/backup_and_recovery#Customizing_the_Export|Backup & Recovery]] documentation for more information}}
{{Tip|For convenience and best practice it's recommended to add the drivers required in your environment to the custom export properties file. This way archives will include the drivers and they will not have to be installed separately. Refer to the [[appboard/2.5/admin/backup_and_recovery#Customizing_the_Export|Backup & Recovery]] documentation for more information}}


== Included JDBC Drivers ==
{|class='wikitable'
!Database
!Filename
!Notes
|-
|MariaDB / MySQL
|mariadb-java-client-1.1.7.jar
|The default driver used for MySQL and MariaDB connections
|-
|PostgreSQL
|postgresql-9.3-1102-jdbc41.jar
|
|}
== Installing a JDBC Driver ==


To install a new database driver:
To install a new database driver:
Line 24: Line 41:
|http://dev.mysql.com/downloads/connector/j/
|http://dev.mysql.com/downloads/connector/j/
|<tt>mysql-connector-java-''version''-bin.jar</tt>
|<tt>mysql-connector-java-''version''-bin.jar</tt>
|-
|PostgreSQL
|http://jdbc.postgresql.org/
|<tt>postgresql-''version''.jdbc4.jar</tt>
|-
|-
|Oracle
|Oracle

Revision as of 09:21, 22 September 2014


Due to licensing restrictions AppBoard ships with a limited set of JDBC drivers. The appropriate drivers may need to be installed to interface with your chosen configuration database or data sources.


Template-tip.png
For convenience and best practice it's recommended to add the drivers required in your environment to the custom export properties file. This way archives will include the drivers and they will not have to be installed separately. Refer to the Backup & Recovery documentation for more information

Included JDBC Drivers

Database Filename Notes
MariaDB / MySQL mariadb-java-client-1.1.7.jar The default driver used for MySQL and MariaDB connections
PostgreSQL postgresql-9.3-1102-jdbc41.jar

Installing a JDBC Driver

To install a new database driver:

  1. download the driver file or package, usually there is a .jar which is the relevant file.
  2. copy the driver to: [INSTALL_HOME]/webapps/enportal/WEB-INF/lib/
  3. restart AppBoard.

See below for a table of common drivers and where to obtain them.

Database Link to JDBC driver Filename
MySQL http://dev.mysql.com/downloads/connector/j/ mysql-connector-java-version-bin.jar
Oracle http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html oracle-thinJDBC-version.jar
SQL Server http://jtds.sourceforge.net/ jtds-version.jar
DB2 http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html db2jcc4.jar
Sybase (jConnect 5.5) http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect jconn2.jar
Retrieved from "http://ab.edge-technologies.com/docs/index.php?title=Appboard/2.5/admin/db_drivers&oldid=6280"