sqlcl lb exit code is always 0

User_LSLH0 · Mar 3, 2022 12:39PM

Hi

I am running sqlcl liquibase from script like so.

The exit code is always 0 regardless of success or failure of change log errors .

How can we get return code when sqlcl lb fail?

sql /nolog<<EOF

WHENEVER OSERROR EXIT FAILURE

WHENEVER SQLERROR EXIT FAILURE

connect usr/pwd

lb update -changelog changelog.xml

EOF

echo $?

wes_fdny · Mar 17, 2022 4:44PM

/subbed

same question and need to know how to fail a build in jenkins if the changesets fail.

wes_fdny · Mar 21, 2022 5:06PM

Ok i got it to work in jenkins -

...

bat echo @test.sql|sql user/[email protected]//host:port/service

...

--test.sql content

whenever sqlerror exit failure;

truncate table liquibase;

insert into liquibase (id) values (1);

insert into liquibase (id) values (1); -- this will fail the jenkins job

commit;

User_LSLH0 · Mar 21, 2022 10:23PM

how do you set it?

Forum Stats