Liquibase boolean for Oracle and HSQLDB

Viewed 21

I need to insert a new row inside both Oracle (for prod) and HSQLDB (for tests) with only one <insert>, but the boolean is what makes the problem - Oracle expects 1, HSQLDB expects true.

Here is how I do it right now, but is it possible to remove the dbms and do it for both DBs with the same <insert>

    <insert dbms="oracle" tableName="MY_TABLE">
        <column name="ID" valueComputed="MY_TABLE_ID_SEQ.NEXTVAL"/>
        <column name="NAME" value="JOHN DOE"/>
        <column name="VISIBLE" value="1"/>
    </insert>
    <insert dbms="hsqldb" tableName="MY_TABLE">
        <column name="ID" valueComputed="MY_TABLE_ID_SEQ.NEXTVAL"/>
        <column name="NAME" value="JOHN DOE"/>
        <column name="VISIBLE" value="true"/>
    </insert>
0 Answers
Related