I’m trying to use liquibase with informix and when I try to generate a change log I get this message:
liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: liquibase.exception.DatabaseException: Error executing SQL select CONSTRAINT_NAME, COLUMN_LIST as COLUMN_NAME from informix.constraints where constraint_type=‘UNIQUE’ and constraint_catalog=‘hol’ and constraint_schema=‘informix’ and table_name=‘oraaccte’ and constraint_name=‘oraaccte_bill_i6’: The specified table (informix.constraints) is not in the database.
This is with liquibase 3.5.5 running against an informix 11.70FC7 engine on HPUX.
I’m simply trying to run generatechangelog via:liquibase --classpath=./ifxjdbc.jar --driver=com.informix.jdbc.IfxDriver --url=“jdbc:informix-sqli://manitoba:9000/hol:INFORMIXSERVER=m_tcp_1” --logLevel=debug --changeLogFile=changelog.informix.sql generateChangeLog
Of course, maybe I’m just doing something grossly wrong.
Thanks,
Todd