pefernan opened a new issue, #2167: URL: https://github.com/apache/incubator-kie-issues/issues/2167
If a Kogito application is connected via jdbc to certain DBs (reproduced in oracle) and we attempt to migrate a set of process instances using the `migrate` with processInstanceId's method the migration can fail with an `SQLFeatureNotSupportedException` ``` Caused by: java.sql.SQLFeatureNotSupportedException: ORA-17023: Unsupported feature: createArrayOf https://docs.oracle.com/error-help/db/ora-17023/ at oracle.jdbc.driver.PhysicalConnection.createArrayOf(PhysicalConnection.java:8193) at io.agroal.pool.wrapper.ConnectionWrapper.createArrayOf(ConnectionWrapper.java:298) at org.kie.kogito.persistence.jdbc.GenericRepository.migrate(GenericRepository.java:331) ... 52 more ``` GenericRepository `migrate` (with processInstanceIds) is setting the array of processInstanceId's parameter as ARRAY using the `connection.createArrayOf("VARCHAR", processIds)` [GenericRepository.java#L331](https://github.com/apache/incubator-kie-kogito-runtimes/blob/main/addons/common/persistence/jdbc/src/main/java/org/kie/kogito/persistence/jdbc/GenericRepository.java#L331) which is not supported for all jdbc drivers causing migrating instances fail. In order to make this feature work well with al jdbc drivers we may have to change the query to inline the the processid's as individuall arguments instead of creating a full array object. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
