WORKERS AHEAD!
You are viewing the development documentation for the Apereo CAS server. The functionality presented here is not officially released yet. This is a work in progress and will be continually updated as development moves forward. To view the documentation for a specific Apereo CAS server release, please choose an appropriate version. The release schedule is also available here.
JDBC Drivers
While in most cases this is unnecessary and handled by CAS automatically, you may need to also include the following module to account for various database drivers:
1
2
3
4
5
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jdbc-drivers</artifactId>
<version>${cas.version}</version>
</dependency>
Database Support
Automatic support for drivers includes the following databases. All other drivers need to be manually added to the build configuration. To see the relevant list of CAS properties, please review this guide.
H2
Available drivers are:
org.h2.Driver
| Dialects |
|---|
org.hibernate.dialect.H2Dialect |
HSQLDB
Available drivers are:
org.hsqldb.jdbcDriver
| Dialects |
|---|
org.hibernate.dialect.HSQLDialect |
Oracle
Available drivers are:
oracle.jdbc.driver.OracleDriver
| Dialects |
|---|
org.hibernate.dialect.Oracle8iDialect |
org.hibernate.dialect.Oracle9iDialect |
org.hibernate.dialect.Oracle10gDialect |
org.hibernate.dialect.Oracle12cDialect |
MYSQL
Available drivers are:
com.mysql.jdbc.Drivercom.mysql.cj.jdbc.Driver
| Dialects |
|---|
org.hibernate.dialect.MySQLDialect |
org.hibernate.dialect.MySQL5Dialect |
org.hibernate.dialect.MySQLInnoDBDialect |
org.hibernate.dialect.MySQLMyISAMDialect |
org.hibernate.dialect.MySQL5InnoDBDialect |
org.hibernate.dialect.MySQL57InnoDBDialect |
org.hibernate.dialect.MySQL8Dialect |
PostgreSQL
Available drivers are:
org.postgresql.Driver
| Dialects |
|---|
org.hibernate.dialect.PostgreSQL81Dialect |
org.hibernate.dialect.PostgreSQL82Dialect |
org.hibernate.dialect.PostgreSQL9Dialect |
org.hibernate.dialect.PostgreSQL91Dialect |
org.hibernate.dialect.PostgreSQL92Dialect |
org.hibernate.dialect.PostgreSQL93Dialect |
org.hibernate.dialect.PostgreSQL94Dialect |
org.hibernate.dialect.PostgreSQL95Dialect |
org.hibernate.dialect.PostgresPlusDialect |
MariaDB
Available drivers are:
org.mariadb.jdbc.Driver
| Dialects |
|---|
org.hibernate.dialect.MariaDBDialect |
org.hibernate.dialect.MariaDB53Dialect |
org.hibernate.dialect.MariaDB10Dialect |
org.hibernate.dialect.MariaDB102Dialect |
org.hibernate.dialect.MariaDB103Dialect |
Microsoft SQL Server
Available drivers are:
net.sourceforge.jtds.jdbc.Drivercom.microsoft.sqlserver.jdbc.SQLServerDriver
| Dialects |
|---|
org.hibernate.dialect.SQLServerDialect |
org.hibernate.dialect.SQLServer2005Dialect |
org.hibernate.dialect.SQLServer2008Dialect |
org.hibernate.dialect.SQLServer2012Dialect |