Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl Project deploy - How does error handling and rollback upon failed deployment work?

Hi,

Right now I'm facing issues on finding good information about the error handling process with SQLcl project deploy command.

There doesn't seem to have any good guide about how to handle deployment error properly.

Does anyone have info about :

  • How to properly catch the state of a deployment after running it? (ex : project deploy -file artifact/release-1.0.0.zip)
  • If there is an error running the migration, how is it handled by liquibase? Is there a rollback process?

For example, I had an issue with index creation running my last migration. The thing is that I had no way to know what happened after the error. Did the migration was reverted? Did liquibase ran everything that came after the error or did it stop once it got the error?

Does anyone have good info about this?

Thanks!

This post has been answered by heraoui-Oracle on Feb 25 2025
Jump to Answer
Comments
Post Details
Added on Feb 25 2025
6 comments
291 views