Clarify the connection string settings for XStream/TCPS [DBZ-6168]
- Dominant language
- HTML
- Stars
- 6
- Forks
- 9
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 1
Description
Migrated from [DBZ-6168](https://issues.redhat.com/browse/DBZ-6168)
In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.
h1. Bug report
For bug reports, provide this information, please:
h2. What Debezium connector do you use and what version?
Oracle Connector v1.9
h2. What is the connector configuration?
debezium.name = oracle-engine
offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore
offset.storage.file.filename = /offsets/oracle4.txt
offset.flush.interval.ms = 60000
database.history = io.debezium.relational.history.FileDatabaseHistory
database.url = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=db-host)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=servicename)))
database.user = xxxxxxx
database.password = xxxxxx
database.history.file.filename = /offsets/dbhistory.txt
database.server.name = oracle-connector
database.out.server.name = dbzxout
database.pdb.name = xxxxpdb
database.connection.adapter = xstream
Also I have included the following Java environment properties when running Debezium
-Djavax.net.ssl.trustStore="xxx.jks"
-Djavax.net.ssl.trustStorePassword="xxxxxx"
-Djavax.net.ssl.trustStoreType="JKS"
h2. What is the captured database version and mode of deployment?
On-premise Oracle 19c RAC CDB Installation with Multiple PDBs with TCPS enabled and only server certificate validation
h2. What behaviour do you expect?
Debezium is able to successfully connect to XStream outbound server via TCPS
h2. What behaviour do you see?
java.lang.RuntimeException: Failed to resolve Oracle database version
io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:161)
...
Contributor guide
Research direction
Start at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:161) and review the supplied XStream/TCPS configuration for Oracle 19c. Reproduce the connection attempt with the listed Java trust-store properties; done means the connector resolves the Oracle version and connects to the XStream outbound server without the reported RuntimeException.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases, security
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100