Problem with Flyway - cannot access to SYSCAT.TABLES

48 Views Asked by At

I have a problem with Flyway

My Quarkus project fails to start due to this error

DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=4.31.10

That's because I can't access to SYSCAT.TABLES with my credentials

How can i bypass this control?

In my Quarkus project I've a DB2 zOS connection, but I can't create table on the schema with my credential So, I ask to create a custom FLYWAY table and i set this custom name on application.properties

quarkus.flyway.table=CUSTOM_FLYWAY_TABLE_NAME

quarkus.flyway.migrate-at-start=true #this to load data with SQL script

I also ask to create other tables, then I want to load data with SQL script by Flyway

I tried with custom table name, but nothing happens

0

There are 0 best solutions below