Skip to Main Content
Forums

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!

liquibase changelog overwrite from sqlcl

vmuthadiNov 8 2021

Hi,
We are trying to generate table code using lb genobject command and the below command by default generates xml file with name <tablename>_table.xml
lb genobject -type table -name countries
Now When we are add a column and rerun the above command, we are gettign changelog name with number added as <tablename>_table1.xml which doesn;t seem to be fine for us. I could not find a way to overwrite the file with name.
As we are generating the code with the updated changes, I wanted the file to be overwritten so that the file is checked in github and we have tracking of changes.
Is this possible to acheive. Please advise

Comments

handat
Answer

The UUID is pseudo unique since the random function it uses for randomisation is also only pseudo random. So yes, if you want to be very pedantic about it, then it is not absolutely guranteed to be random and unique. But it depends on what you really need it for and how does reading a value from an ini file make it more unique? What kind of value is in your ini file and how will it make it unique? Reading some value from an ini file is trivial though.

For your reference, here's the gnu classpath equivalent of the UUID class. It is not the same, but does the same thing: http://fuseyism.com/classpath/doc/java/util/UUID-source.html

Marked as Answer by captain_kirk · Sep 27 2020
captain_kirk

Thanks for the link handat. I agree that reading from an ini file does nothing for uniqueness. Right now I am just putting a 'j' character in the ini and append it to a unique vendor file name to resolve a dupe file issue. Since UUID generates a (supposedly) unique id every time, it provides more uniqueness than reading 'j' from an ini. But sigh, it's not up to me how this is done, I just code this .

1 - 2

Post Details

Added on Nov 8 2021
#sqldeveloper
2 comments
214 views