Using Liquibase and Spring Boot with SQL Plus and Kerberos Authentication
The Liquibase Spring Boot integration supports SQL Plus using the
runWith=sqlplus changesets. To run the
runWith types of changesets, Liquibase requires the authentication mechanism that allows running the native executor without specifying credentials, such as Kerberos.
For now, the
runWith=sqlplus attribute is not available if you connect to your database using the following authentication mechanisms:
- JNDI Datasource
However, the authentication mechanisms do not affect changesets which do not use the
Ensure you have configured the following parts:
- Liquibase with Oracle
- Liquibase with Spring Boot
Running Spring Boot and SQL Plus with Kerberos
Configure Liquibase and Kerberos.
Specify how Liquibase can find SQL Plus by adding SQL Plus to your PATH. Alternatively, pass its location in the
liquibase.sqlplus.conffile or from the command prompt using the
--sqlplus-pathparameter during runtime.
runWithattribute to the needed changesets in the changelog file that you use. For more information, see Using the SQL Plus integration and run-with attribute with Liquibase Pro and Oracle.
- Run the
Note: If you have specified your changelog file as an environment variable or in the properties file, you can skip passing it at the command prompt.
liquibase --changelog-file=<your changelog file> update