Skip to content

DBZ-8302: Treat oracle negative timestamp values as -infinity.#5996

Open
dongwook-chan wants to merge 3 commits intodebezium:mainfrom
dongwook-chan:DBZ-8302
Open

DBZ-8302: Treat oracle negative timestamp values as -infinity.#5996
dongwook-chan wants to merge 3 commits intodebezium:mainfrom
dongwook-chan:DBZ-8302

Conversation

@dongwook-chan
Copy link

We were hoping to create a PR on this issue but found that the repo is archived.
Below is the PR that we attempted to create.

We want to refer to config from ZonedTimestampType.
But it takes a lot of depth to reach config from this class.
So we would you to provide some advice on this issue pls.
https://github.com/dongwook-chan/debezium-connector-jdbc/blob/2e2aa669c2a4f50ba85196d5cf8f4115a5155c28/src/main/java/io/debezium/connector/jdbc/dialect/mysql/ZonedTimestampType.java#L37-L39

We tried to run integration test on jdbc sink connector but failed.
So if you have any instructions on this please provide.

Co-authored-by: Bue-von-hon <[email protected]>
Co-authored-by: chungeun-choi <[email protected]>
Co-authored-by: sean-k1 <[email protected]>
@Naros Naros self-requested a review November 16, 2024 19:14
Copy link
Contributor

@jpechane jpechane left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@dongwook-chan Thanks for the PR. Could you please reformat the code so the tests are executed. lso could you please add a test case for the new feature? Thanks

<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc11</artifactId>
<version>23.6.0.24.10</version>
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Why it is necessary to override the version here?

Copy link
Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Sorry, my bad! I removed the version tag.

Copy link
Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@jpechane
I also added config variable ORACLE_INFINITY_CONVERTER_ENABLE for the feature,
but have trouble accessing it from convertInfinityTimestampValue(). Could you give some advice on this? And I would like some advice on running integration test too.

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I think this would require a different approach. The class io.debezium.connector.jdbc.dialect.oracle.ZonedTimestampType should provide two instances. The existing one and one with the requested behaviour. io.debezium.connector.jdbc.dialect.oracle.OracleDatabaseDialect.registerTypes() wil then register the one based on connector config.

Copy link
Member

@Naros Naros left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Hi @dongwook-chan do you intend to add test cases?

@Naros
Copy link
Member

Naros commented Jan 6, 2026

❌ Developer Certificate of Origin (DCO) check failed.

Hi @dongwook-chan, please sign off all commits with:

git commit -s

If pull request commits are not signed off, the pull request cannot be merged. For more information about why this is required, please see our blog about contribution requirement changes.

@Naros Naros self-assigned this Mar 16, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants