Hi, I am facing this error when creating a Oracle CDC connector.
I’ve benn looking around but no success in finda a solution.
Please, can you help me?
{
“name”: “OracleCDC_ctuact”,
“config”:{
“connector.class”: “io.confluent.connect.oracle.cdc.OracleCdcSourceConnector”,
“name”: “OracleCDC_ctuact”,
“tasks.max”:1,
“key.converter”: “io.confluent.connect.avro.AvroConverter”,
“key.converter.schema.registry.url”: “http://localhost:8081”,
“value.converter”: “io.confluent.connect.avro.AvroConverter”,
“value.converter.schema.registry.url”: “http://localhost:8081”,
“confluent.topic.bootstrap.servers”:“localhost:9092”,
“oracle.server”: “server-name”,
“oracle.port”: 1571,
“oracle.sid”:“ORACL”,
“oracle.username”: “xxxxx”,
“oracle.password”: “xxxxx”,
“start.from”:“current”,
“redo.log.topic.name”: “redo-log-ctuact-topic”,
“redo.log.consumer.bootstrap.servers”:“localhost:9092”,
“table.inclusion.regex”:“CTUACT[.]CTU[.].”,
“table.topic.name.template”:“”,
“connection.pool.max.size”: 20,
“confluent.topic.replication.factor”:1,
“topic.creation.groups”: “redo”,
“topic.creation.redo.include”: “redo-log-ctuact-topic”,
“topic.creation.redo.replication.factor”: 3,
“topic.creation.redo.partitions”: 1,
“topic.creation.redo.cleanup.policy”: “delete”,
“topic.creation.redo.retention.ms”: 1209600000,
“topic.creation.default.replication.factor”: 3,
“topic.creation.default.partitions”: 3,
“topic.creation.default.cleanup.policy”: “compact”
}
}
{“error_code”:500,“message”:“Error trying to forward REST request: Connector configuration is invalid and contains the following 8 error(s):\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nUnable to create connection pool ‘OracleCDC_ctuact’: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to create factory class instance with provided factory class name: java.lang.SecurityException: sealing violation: package oracle.jdbc is sealed\nYou can also find the above list of errors at the endpoint /connector-plugins/{connectorType}/config/validate”}You have mail in /var/spool/mail/root