sql-show-sql-warnings
--sql-show-sql-warnings is a global Boolean parameter that specifies whether Liquibase logs should include Java SQLWarning messages. The default value is true. This parameter is available in Liquibase 4.25.0 and later.
Uses
If your database connection, JDBC driver, database tables, or SQL queries contain non-fatal errors, the SQLWarning
Java class may throw an exception to inform you of the issue. By default, Liquibase 4.25.0+ includes these warning messages in your Liquibase logs, including Structured Logging output.
If you know about these errors and don't want to include them in your logs, you can set --sql-show-sql-warnings
to false
.
Syntax
You can set this parameter in the following ways:
Option | Syntax |
Liquibase properties file (defaults file) | liquibase.sql.showSqlWarnings: <true|false> |
Global flow file argument | globalArgs: { sql-show-sql-warnings: "<true|false>" } |
Global CLI parameter | liquibase --sql-show-sql-warnings=<true|false> update --changelog-file=example-changelog.xml |
JVM system property (JAVA_OPTS environment variable) | Unix: JAVA_OPTS=-Dliquibase.sql.showSqlWarnings=<true|false> Windows: JAVA_OPTS=-D"liquibase.sql.showSqlWarnings"=<true|false> |
Liquibase environment variable |
|
For more information, see Working with command parameters.