Appboard/2.6/admin/db drivers - Revision history

imported>Jason.nicholls: /* Included JDBC Drivers */

2015-07-27T05:42:58Z

Included JDBC Drivers

← Older revision		Revision as of 05:42, 27 July 2015
Line 15:		Line 15:
	\|-		\|-
	\|MySQL / MariaDB		\|MySQL / MariaDB
	\|<tt>mariadb-java-client-1.2.0.jar</tt>		\|<tt>mariadb-java-client-1.1.8.jar</tt>
	\|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below).		\|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below).
	\|-		\|-

imported>Jason.nicholls: /* Included JDBC Drivers */

2015-07-22T03:31:26Z

Included JDBC Drivers

← Older revision		Revision as of 03:31, 22 July 2015
Line 15:		Line 15:
	\|-		\|-
	\|MySQL / MariaDB		\|MySQL / MariaDB
	\|<tt>mariadb-java-client-1.1.8.jar</tt>		\|<tt>mariadb-java-client-1.2.0.jar</tt>
	\|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below).		\|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below).
	\|-		\|-

imported>Doug yeager: /* Installing a JDBC Driver */

2015-06-04T21:15:10Z

Installing a JDBC Driver

← Older revision		Revision as of 21:15, 4 June 2015
Line 57:		Line 57:
	\|http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect		\|http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect
	\|<tt>jconn2.jar</tt>		\|<tt>jconn2.jar</tt>
			\|-
			\|HSQLDB
			\|http://hsqldb.org/
			\|<tt>hsqldb.jar</tt>
	\|-		\|-
	\|Cloudera Impala (Apache Hive)		\|Cloudera Impala (Apache Hive)

imported>Jason.nicholls: /* Included JDBC Drivers */

2015-06-04T03:18:17Z

Included JDBC Drivers

← Older revision		Revision as of 03:18, 4 June 2015
Line 19:		Line 19:
	\|-		\|-
	\|PostgreSQL		\|PostgreSQL
	\|<tt>postgresql-9.3-~~1102~~-jdbc41.jar</tt>		\|<tt>postgresql-9.4-1201-jdbc41.jar</tt>
	\|		\|
	\|}		\|}

imported>Jason.nicholls: 1 revision

2015-04-30T10:59:28Z

1 revision

← Older revision	Revision as of 10:59, 30 April 2015
(No difference)

imported>Jason.nicholls: /* Included JDBC Drivers */

2015-02-04T17:06:39Z

Included JDBC Drivers

New page

{{DISPLAYTITLE:Loading Database Drivers}}
[[Category:AppBoard 2.6]]

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.

{{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.6/admin/backup_and_recovery#Customizing_the_Export|Backup & Recovery]] documentation for more information}}

== Included JDBC Drivers ==

{|class='wikitable'
!Database
!Filename
!Notes
|-
|MySQL / MariaDB
|<tt>mariadb-java-client-1.1.8.jar</tt>
|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below).
|-
|PostgreSQL
|<tt>postgresql-9.3-1102-jdbc41.jar</tt>
|
|}

== Installing a JDBC Driver ==

To install a new database driver:

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

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

{|class='wikitable'
!Database
!Link to JDBC driver
!Filename
|-
|MySQL
|http://dev.mysql.com/downloads/connector/j/
|<tt>mysql-connector-java-''version''-bin.jar</tt>
|-
|Oracle
|http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
|<tt>oracle-thinJDBC-''version''.jar</tt>
|-
|SQL Server
|http://jtds.sourceforge.net/
|<tt>jtds-''version''.jar</tt>
|-
|DB2
|http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html
|<tt>db2jcc4.jar</tt>
|-
|Sybase (jConnect 5.5)
|http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect
|<tt>jconn2.jar</tt>
|-
|Cloudera Impala (Apache Hive)
|contact Edge support
|''multiple files''
|}