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>
|
1
| implementation "org.apereo.cas:cas-server-support-jdbc-drivers:${project.'cas.version'}"
|
1
2
3
4
5
6
7
8
9
| dependencyManagement {
imports {
mavenBom "org.apereo.cas:cas-server-support-bom:${project.'cas.version'}"
}
}
dependencies {
implementation "org.apereo.cas:cas-server-support-jdbc-drivers"
}
|
JPA Implementations
The following JPA implementations are provided by CAS. In most cases, the indicated modules do not need
to be included in a CAS build and the implementation would be automatically chosen by the feature module.
The details below are listed for reference and may be of use in advanced scenarios where development may be required.
Hibernate
Hibernate ORM is an object–relational mapping tool for the Java programming
language. It provides a framework for mapping an object-oriented domain model to a relational database.
1
2
3
4
5
| <dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jpa-hibernate</artifactId>
<version>${cas.version}</version>
</dependency>
|
1
| implementation "org.apereo.cas:cas-server-support-jpa-hibernate:${project.'cas.version'}"
|
1
2
3
4
5
6
7
8
9
| dependencyManagement {
imports {
mavenBom "org.apereo.cas:cas-server-support-bom:${project.'cas.version'}"
}
}
dependencies {
implementation "org.apereo.cas:cas-server-support-jpa-hibernate"
}
|
EclipseLink
EclipseLink is the open source Eclipse Persistence Services Project from the
Eclipse Foundation. The software provides an extensible framework that allows
Java developers to interact with various data services, including databases,
web services, Object XML mapping, and enterprise information systems.
1
2
3
4
5
| <dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jpa-eclipselink</artifactId>
<version>${cas.version}</version>
</dependency>
|
1
| implementation "org.apereo.cas:cas-server-support-jpa-eclipselink:${project.'cas.version'}"
|
1
2
3
4
5
6
7
8
9
| dependencyManagement {
imports {
mavenBom "org.apereo.cas:cas-server-support-bom:${project.'cas.version'}"
}
}
dependencies {
implementation "org.apereo.cas:cas-server-support-jpa-eclipselink"
}
|
Database Support
Automatic support for drivers includes the following databases.
All other drivers need to be manually added to the build configuration.
Control global properties that are relevant to Hibernate,
when CAS attempts to employ and utilize database resources,
connections and queries.
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.Driver
com.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.PostgreSQL10Dialect |
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.Driver
com.microsoft.sqlserver.jdbc.SQLServerDriver
Dialects |
org.hibernate.dialect.SQLServerDialect |
org.hibernate.dialect.SQLServer2005Dialect |
org.hibernate.dialect.SQLServer2008Dialect |
org.hibernate.dialect.SQLServer2012Dialect |