Search code examples
javaderbyliquibase

derby Data migration using liquibase


How to assign two columns to one index in Lquibase datamigration.xml file for Derby DB. I have used following codes which work fine with oracle and MSSQL. but derby is creating two rows with same index name.

<createIndex indexName="idx_group_name" tableName="rights" unique="true">
            <column name="name"/>
            <column name="group_name"/>
        </createIndex>

Solution

  • Derby DB was complaining while uploading same data from csv file. Issue was resolved by not uploading csv file from dbmigration.xml file. Thanks