Hi,
I’m encountering an error when trying to run Liquibase with an Oracle database. Here’s the exact error message I receive:
Unexpected error running Liquibase: ORA-17056: Non-supported character set (add orai18n.jar in the classpath): AR8MSWIN1256
Environment:
Liquibase Version: [insert version here]
Database: Oracle 19c
JDBC Driver: ojdbc8.jar
Operating System: Windows 10 Enterprise
JDBC URL: jdbc:oracle:thin:@//hostname:1521/sid?useUnicode=true&characterEncoding=UTF-8
Command Executed:
liquibase --changeLogFile=changelog.xml --url=jdbc:oracle:thin:@//hostname:1521/DB --username=–password= update
Error Details:
When running the above command, I get the following error:
ORA-17056: Non-supported character set (add orai18n.jar in the classpath): AR8MSWIN1256
It suggests adding orai18n.jar to the classpath, but I’m not sure how to do this or if there’s something else I need to adjust in my setup.
What I’ve Tried:
Added the orai18n.jar to the classpath.
Verified the character set by running the following query in Oracle:
SELECT * FROM nls_database_parameters WHERE parameter=‘NLS_CHARACTERSET’;
The result was AR8MSWIN1256.
Could anyone help me with how to resolve this issue? Do I need to change the Liquibase configuration? Any help would be appreciated!