KC 17 Quarkus: Cannot change db-dialect for an Oracle Database

Configuring the server
#1

Im trying to change the default dialect to an Oracle database, but any modification ( even setting the default value ) to this property disable any aplied dialect, example:

With this command:

sudo /opt/keycloak-17.0.0/bin/kc.sh  build \
--db=oracle \
--metrics-enabled=true \
--cache-config-file=../conf/cache-ispn.xml

I get this configuration:

Runtime Configuration:
        kc.cache =  ispn (PersistedConfigSource)
        kc.cache-config-file =  ../conf/cache-ispn.xml (PersistedConfigSource)
        kc.config.args =  show-config;;all (SysPropConfigSource)
        kc.db =  oracle (PersistedConfigSource)
        kc.db-dialect =  org.hibernate.dialect.Oracle12cDialect (PersistedConfigSource)
        kc.home.dir =  /opt/keycloak-17.0.0/bin/../ (SysPropConfigSource)
        kc.http-enabled =  false (PropertiesConfigSource[source=jar:file:///opt/keycloak-17.0.0/lib/lib/main/org.keycloak.keycloak-quarkus-server-17.0.0.jar!/META-INF/keycloak.conf])
        kc.http-relative-path =  / (PersistedConfigSource)
        kc.metrics-enabled =  true (PersistedConfigSource)
        kc.quarkus-properties-enabled =  true (PersistedConfigSource)
        kc.show.config =  all (SysPropConfigSource)
        kc.version =  17.0.0 (SysPropConfigSource)
Quarkus Configuration:
        quarkus.log.category."org.infinispan.transaction.lookup.JBossStandaloneJTAManagerLookup".level =  WARN (QuarkusProperties)
        quarkus.log.category."org.jboss.resteasy.resteasy_jaxrs.i18n".level =  WARN (QuarkusProperties)
        quarkus.log.min-level =  TRACE (QuarkusProperties)
        quarkus.naming.enable-jndi =  true (QuarkusProperties)

Give me the error:

"Caused by: Error : 933, Position : 191, Sql = select migrationm0_.ID as id1_39_, migrationm0_.UPDATE_TIME as update_time2_39_, migrationm0_.VERSION as version3_39_ from MIGRATION_MODEL migrationm0_ order by migrationm0_.UPDATE_TIME DESC fetch first :1 rows only"

It was ok because fetch first was introduced in oracle 12c and my database is version 9i

But when i use the command:

sudo /opt/keycloak-17.0.0/bin/kc.sh -Dkc.db-dialect=org.hibernate.dialect.Oracle12cDialect  build \
--db=oracle \
--metrics-enabled=true \
--cache-config-file=../conf/cache-ispn.xml

I get the same config:

Runtime Configuration:
        kc.cache =  ispn (PersistedConfigSource)
        kc.cache-config-file =  ../conf/cache-ispn.xml (PersistedConfigSource)
        kc.config.args =  show-config;;all (SysPropConfigSource)
        kc.db =  oracle (PersistedConfigSource)
        kc.db-dialect =  org.hibernate.dialect.Oracle12cDialect (PersistedConfigSource)
        kc.home.dir =  /opt/keycloak-17.0.0/bin/../ (SysPropConfigSource)
        kc.http-enabled =  false (PropertiesConfigSource[source=jar:file:///opt/keycloak-17.0.0/lib/lib/main/org.keycloak.keycloak-quarkus-server-17.0.0.jar!/META-INF/keycloak.conf])
        kc.http-relative-path =  / (PersistedConfigSource)
        kc.metrics-enabled =  true (PersistedConfigSource)
        kc.quarkus-properties-enabled =  true (PersistedConfigSource)
        kc.show.config =  all (SysPropConfigSource)
        kc.version =  17.0.0 (SysPropConfigSource)
Quarkus Configuration:
        quarkus.log.category."org.infinispan.transaction.lookup.JBossStandaloneJTAManagerLookup".level =  WARN (QuarkusProperties)
        quarkus.log.category."org.jboss.resteasy.resteasy_jaxrs.i18n".level =  WARN (QuarkusProperties)
        quarkus.log.min-level =  TRACE (QuarkusProperties)
        quarkus.naming.enable-jndi =  true (QuarkusProperties)

But a different error:

Caused by: Error : 933, Position : 188, Sql = select migrationm0_.ID as id1_39_, migrationm0_.UPDATE_TIME as update_t2_39_, migrationm0_.VERSION as version3_39_ from MIGRATION_MODEL migrationm0_ order by migrationm0_.UPDATE_TIME DESC limit :1

Now limit was aplied to the query and limit arent implement in the oracle 12c version, so the dialect was’t aplied

If i try to change the database dialect this LIMIT clause is aplied to the query