I did oracle CQN registration from Java application using JDBC driver with the following parameters
Properties prop = new Properties();
prop.setProperty(OracleConnection.DCN_NOTIFY_ROWIDS, "true");
prop.setProperty(OracleConnection.NTF_QOS_RELIABLE, "true");
prop.setProperty(OracleConnection.DCN_CLIENT_INIT_CONNECTION, "true");
try (OracleConnection connection = (OracleConnection) DriverManager.getConnection(jdbcUrl, dbUsername, dbPassword)) {
DatabaseChangeRegistration dcr = ((OracleConnection) connection).registerDatabaseChangeNotification(prop);
dcr.addListener(this);
OracleStatement stmt = (OracleStatement) connection.createStatement();
stmt.setDatabaseChangeRegistration(dcr);
ResultSet rs = stmt.executeQuery("select * from employees");
...
Oracle Database every time registers a new registration Id and callback, is there any way to use existing one? I want to get all the notifications in case of my application restart.