-
Bug
-
Resolution: Done
-
Critical
-
2.4.0.Beta1
-
None
-
False
-
None
-
False
-
-
In DBZ-6801, a change introduced a trailing ; (semicolon) in the generated SQL statements and this causes the following failure:
Caused by: jakarta.persistence.PersistenceException: Converting `org.hibernate.exception.SQLGrammarException` to JPA `PersistenceException` : JDBC exception executing SQL [INSERT INTO DEBEZIUM.ORACLE_DEBEZIUM_UOBOWNG7HKHF (DATA) VALUES (?);] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:165) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:175) at org.hibernate.query.spi.AbstractQuery.executeUpdate(AbstractQuery.java:654) at io.debezium.connector.jdbc.JdbcChangeEventSink.writeInsert(JdbcChangeEventSink.java:246) at io.debezium.connector.jdbc.JdbcChangeEventSink.write(JdbcChangeEventSink.java:220) at io.debezium.connector.jdbc.JdbcChangeEventSink.execute(JdbcChangeEventSink.java:79) ... 105 common frames omitted Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [INSERT INTO DEBEZIUM.ORACLE_DEBEZIUM_UOBOWNG7HKHF (DATA) VALUES (?);] at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) at org.hibernate.sql.exec.internal.StandardJdbcMutationExecutor.execute(StandardJdbcMutationExecutor.java:97) at org.hibernate.query.sql.internal.NativeNonSelectQueryPlanImpl.executeUpdate(NativeNonSelectQueryPlanImpl.java:78) at org.hibernate.query.sql.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:820) at org.hibernate.query.spi.AbstractQuery.executeUpdate(AbstractQuery.java:643) ... 108 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
- links to
-
RHEA-2024:129636 Red Hat build of Debezium 2.5.4 release