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 Liquibase - Data always inserting

Clarkec21Feb 6 2023

Hi

Using SQLCL v21.4 LB version 4.6.1 - warning I am new to LB….it might be obvious when I ask my question…

Exporting the data for a table works fine creating the expected “data.xml” file:

lb data -filter include -object “BUSINESS_PARAMETERS”

Importing data into empty table works fine, rows created

lb update -changelog data.xml -emit_schema

If I re-run this same update command I was under the impression this data would not get loaded, instead I get unique constraint violation on the first row and processing stops. If I add a new row to my table re-export and run a now changed file the same thing happens, I expected only the new row to be inserted. Are my assumptions incorrect? I have tried looking around in documentation and using the help function - I am not seeing any examples.

Thank you for your time

Comments
Post Details
Added on Feb 6 2023
4 comments
248 views