Communtity edition: rollback, LDAP and enddelimiter questions

General Discussion
1

Hello All,

If someone could help me with the below questions I have, I would really appreciate it.

Note: we use free community version & we have SQL Server and Oracle targets.

  1. How do we use LDAP(CyberArk) authentication with JDBC? How does the URL look for it? is there a an article or an example I can refer to?
  2. How does rollback work with changesets that use runOnChange=true ? we want to use the option where we can rollback to previous version of it.
  3. What happens if we set endDelimiter as ‘GO’ and there are 3 queries in one script and the last/final query does not have ‘GO’ at the end?
2

I can’t asnwer #1, but I’ll try #2 & #3…

#2:
Rollback and runOnChange really have no relation. Liquibase “rollback” uses the rollback sql that you define, or it uses auto-rollback.
What I think your are asking is how do you rollback to a prior version of your code object (function, procedure, trigger, etc). I think what you are looking for is the “rollback to prior changeset” functionality. Here is an example:

<changeSet id="changeRollback2-drop" author="liquibase">
  <dropTable tableName="changeRollback2"/>
  <rollback changeSetId="changeRollback2-create" changeSetAuthor="liquibase"/>
</changeSet>

The example is XML, but support for this was now added for sql format in a recent release. Full documentation found here: rollback

#3
If you set endDelimiter=GO then every sql statement in your changeset must be delimited with GO.

3

Hello @daryldoak ,

I have same issue actually we are updating the same changeset or same file multiple times so the changesetid is same in our case so is there any solution we can rollback to its previous version