Hello, I’m trying to use liquibase 4.25.0 to run sql scripts in DB2 on zOS from the zOS Unix System service. The first time liquibase is run (with status or update) the databasechangelog and databasechangeloglock are created in DB2 on zOS, but when trying to run another script a second time it always gives the error ‘Unexpected error running Liquibase: java.lang.NullPointerException’ . It seems that when running liquibase with the databasechangelog and databasechangeloglock tables already created, it does not recognize them or cannot access them (?).
I don’t think it’s a permissions problem as I can access them directly on zOS with the same user. My properties file looks like this:
changelogFile=/db2_zos/changelog-zos.xml
driver= com.ibm.db2.jcc.DB2Driver
liquibase.command.url=jdbc:db2://db2d.qldplex.gbpios.loc:447/ESA2DSN
classpath: lib/db2jcc4.jar:lib/db2jcc_license_cisuz.jar
defaultSchemaName=DSVDB2
liquibase.fileEncoding: IBM-1047
liquibase.outputEncoding: IBM-1047
liquibase.outputFileEncoding: IBM-1047
verbose=true
liquibase.command.username: Myusername
liquibase.command.password: Mypassword
logLevel: DEBUG
#logFile: liquibase.log
And the script it’s just a simple SELECT :
–liquibase formatted sql
–changeset Myuser:Teste
SET CURRENT SQLID = ‘DSVDB2’;
SELECT * FROM AAT001_TESTE
WITH UR;
Can anyone help me see if I’m doing something wrong or what could be causing the problem?
Thank you