Hi all.
I am trying to use Oracle DCD but I got this error during connector creation.
{“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_ora56act’: 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_ora56act’: 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_ora56act’: 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_ora56act’: 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_ora56act’: 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_ora56act’: 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_ora56act’: 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_ora56act’: 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”}
Follows my connector config
{
“name”: “OracleCDC_ora56act”,
“config”:{
“connector.class”:“io.confluent.connect.oracle.cdc.OracleCdcSourceConnector”,
“tasks.max”:“1”,
“key.converter”: “io.confluent.connect.avro.AvroConverter”,
“key.converter.schema.registry.url”: “http://xxx:8081”,
“value.converter”: “io.confluent.connect.avro.AvroConverter”,
“value.converter.schema.registry.url”: “http://xxx:8081”,
“confluent.topic.bootstrap.servers”:“xxx:9092”,
“oracle.server”: “xxxx”,
“oracle.port”: “1591”,
“oracle.sid”:“xxx”,
“oracle.username”: “xxx”,
“oracle.password”: xxx",
“table.inclusion.regex”:“.CUSTOMER.”
}
}