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.

Oracle

Download manually from this link.

Apache Maven

You need to install it into your local repository that houses and caches all artifacts.

1
mvnw install:install-file -Dfile=[path/to/your/ojdbc.jar] -DgroupId=com.oracle -DartifactId=[ojdbc-jar-name] -Dversion=[ojdbc-version] -Dpackaging=jar

Then include in your build as such:

1
2
3
4
5
<dependency>
   <groupId>com.oracle</groupId>
   <artifactId>[ojdbc-jar-name]</artifactId>
   <version>[ojdbc-version]</version>
</dependency>

Gradle

You may reference the downloaded JAR directly in your build script:

1
2
3
4
5
dependencies {
   ... 
   runtime files("[path/to/your/ojdbc.jar]")
   ...
}

HSQLDB

Available drivers are:

1. org.hsqldb.jdbcDriver

Oracle

Note that the Oracle database driver needs to be manually installed before the above configuration can take effect. Depending on the driver version, the actual name of the driver class may vary.

MYSQL

Available drivers are:

1. com.mysql.jdbc.Driver
2. com.mysql.cj.jdbc.Driver

PostgreSQL

Available drivers are:

1. org.postgresql.Driver

MariaDB

Available drivers are:

1. org.mariadb.jdbc.Driver

Microsoft SQL Server

Available drivers are:

1. net.sourceforge.jtds.jdbc.Driver
2. com.microsoft.sqlserver.jdbc.SQLServerDriver