sqlcl lb exit code is always 0

User_LSLH0

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

/subbed

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

wes_fdny

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

how do you set it?