Hello,
I have a problem during liquibase update statement is running. I try run statement in batch file like below:
call liquibase update --defaultsFile %~dp0/mydb.properties --log-file %LOG_FILE_my_user% --log-level=DEBUG --classpath=%~dp0 --changelog-file release.xml --contexts %my_user% --username “%my_user%” --password “ABC^=abc” -Drelease=r-%release%
I get the error:
Unexpected error running Liquibase: Connection could not be created to jdbc:oracle:thin:@mydb.db.com:1543/mydb with driver oracle.jdbc.OracleDriver. ORA-01017: invalid username/password; logon denied
But when I paste this statement and run it directly from the command line everything works fine:
Starting Liquibase at 11:16:56 (version 4.13.0 #3391 built at 2022-07-06 12:07+0000)
Liquibase Version: 4.13.0
Liquibase Community 4.13.0 by Liquibase
Running Changeset: schema/views/test_view.sql::test_view::migration
Liquibase command ‘update’ was executed successfully.
Does anyone know where is the problem and could help me with this situation? It’s a very strange that the same statement works from command line but doesn’t in script.
I thought that password is a problem because contains characters like ^= but when I around password in the double quotes it’s okay running it from cmd.
I’ll be very grateful for your help