Appboard/2.5/admin/db drivers - Revision history

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

2015-02-04T17:06:39Z

Included JDBC Drivers

← Older revision		Revision as of 17:06, 4 February 2015
Line 15:		Line 15:
	\|-		\|-
	\|MySQL / MariaDB		\|MySQL / MariaDB
	\|<tt>mariadb-java-client-1.1.7.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: /* Installing a JDBC Driver */

2014-10-15T08:03:58Z

Installing a JDBC Driver

← Older revision		Revision as of 08:03, 15 October 2014
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>
			\|-
			\|Cloudera Impala (Apache Hive)
			\|contact Edge support
			\|''multiple files''
	\|}		\|}

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

2014-09-22T09:22:52Z

Included JDBC Drivers

← Older revision		Revision as of 09:22, 22 September 2014
Line 15:		Line 15:
	\|-		\|-
	\|MySQL / MariaDB		\|MySQL / MariaDB
	\|mariadb-java-client-1.1.7.jar		\|<tt>mariadb-java-client-1.1.7.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).
	\|-		\|-
	\|PostgreSQL		\|PostgreSQL
	\|postgresql-9.3-1102-jdbc41.jar		\|<tt>postgresql-9.3-1102-jdbc41.jar</tt>
	\|		\|
	\|}		\|}

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

2014-09-22T09:22:33Z

Included JDBC Drivers

← Older revision		Revision as of 09:22, 22 September 2014
Line 16:		Line 16:
	\|MySQL / MariaDB		\|MySQL / MariaDB
	\|mariadb-java-client-1.1.7.jar		\|mariadb-java-client-1.1.7.jar
	\|The default driver used for MySQL and MariaDB connections		\|The default driver used for MySQL and MariaDB connections. Alternatively install the MySQL driver (see below).
	\|-		\|-
	\|PostgreSQL		\|PostgreSQL

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

2014-09-22T09:21:55Z

Included JDBC Drivers

← Older revision		Revision as of 09:21, 22 September 2014
Line 14:		Line 14:
	!Notes		!Notes
	\|-		\|-
	\|MariaDB ~~/ MySQL~~		\|MySQL / MariaDB
	\|mariadb-java-client-1.1.7.jar		\|mariadb-java-client-1.1.7.jar
	\|The default driver used for MySQL and MariaDB connections		\|The default driver used for MySQL and MariaDB connections

imported>Jason.nicholls at 09:21, 22 September 2014

2014-09-22T09:21:38Z

@@ 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}}
 To install a new database driver:
@@ Line 24: / Line 41: @@
 |http://dev.mysql.com/downloads/connector/j/
 |<tt>mysql-connector-java-''version''-bin.jar</tt>
 |-
 |Oracle

imported>Jason.nicholls at 09:14, 22 September 2014

2014-09-22T09:14:44Z

← Older revision		Revision as of 09:14, 22 September 2014
Line 2:		Line 2:
	[[Category:AppBoard 2.5]]		[[Category:AppBoard 2.5]]

	Due to licensing restrictions AppBoard ~~does not ship~~ with JDBC ~~database~~ drivers. ~~Loading the~~ appropriate drivers ~~for the specific databases being access is required. This is if using an external~~ configuration database, or ~~for database~~ data sources.		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.}}		{{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}}

imported>Jason.nicholls at 11:12, 18 July 2014

2014-07-18T11:12:15Z

← Older revision		Revision as of 11:12, 18 July 2014
Line 2:		Line 2:
	[[Category:AppBoard 2.5]]		[[Category:AppBoard 2.5]]

	Due to licensing restrictions ~~many common~~ JDBC database drivers ~~do not ship with~~ the ~~core AppBoard product~~. ~~As a result these need to be added in order~~ for ~~the relevant~~ database ~~Data Sources to work~~.		Due to licensing restrictions AppBoard does not ship with JDBC database drivers. Loading the appropriate drivers for the specific databases being access is required. This is if using an external configuration database, or for database 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.}}		{{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.}}


	To install a new database driver:		To install a new database driver:

imported>Jason.nicholls: 1 revision

2014-06-26T15:52:01Z

1 revision

← Older revision	Revision as of 15:52, 26 June 2014
(No difference)

imported>Jason.nicholls at 02:55, 1 April 2014

2014-04-01T02:55:03Z

New page

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

Due to licensing restrictions many common JDBC database drivers do not ship with the core AppBoard product. As a result these need to be added in order for the relevant database Data Sources to work.

{{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.}}

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>
|-
|PostgreSQL
|http://jdbc.postgresql.org/
|<tt>postgresql-''version''.jdbc4.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>
|}