extra backslash added in the column values in the genarated sql file from generateChangeLog using maven Liquibase

Please let me know if there is solution to use it in maven plugin with liquibase.

Could be a bug, but using CDATA might be the best solution. There isn’t going to be any property that I can think of that would affect this. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/

Thanks for the reply,

Yes CDATA is the best solution but the problem is I am first generating ChangeLogFile for generateChangeLog maven goal and then generating SQL using UpdateSql maven goal. So I don’t want any manual supervision for these kind of values those may affect. Instead those should stay unaffected without any change.

Your workflow sounds very convoluted. SQL -> XML -> SQL complicates things quite a bit. 

We are doing something like that at Datical and it has taken a team of engineers 2 years to get that to where we are now. We also don’t do very much with data in databases - we focus primarily on structure.

The two suggestions I have if you are committed to that workflow. For both of them you should create a small easily-reproducible test case that shows the problem.

  1. Start running liquibase in a debugger and see if you can discover where the problem is coming from, and then fix that issue and submit a pull request to Liquibase

  2. Submit the test case in a bug report to Liquibase and hope that someone else will fix it for you. 

Steve Donie
Principal Software Engineer
Datical, Inc. http://www.datical.com/