时间戳

首页 > 解决方案 > ORA-29973: 使用 DatabaseChangeRegistration 时更改通知注册期间不支持的查询或操作

java - ORA-29973: 使用 DatabaseChangeRegistration 时更改通知注册期间不支持的查询或操作

问题描述

错误：我使用 ojdbc8 和 Oracle11gR2；当我使用 DatabaseChangeRegistration 时；出现此错误：ORA-29973：更改通知注册期间不支持的查询或操作。这是我的代码

public class OracleDCN {
    static final String USERNAME = "sys as sysdba";
    static final String PASSWORD = "123456";
    static String URL = "jdbc:oracle:thin:@localhost:1521:db11g";
    public static void main(String[] args) {
        OracleDCN oracleDCN = new OracleDCN();
        try {
            oracleDCN.run();
        } catch (Exception ex) {
            System.out.println("Loi " + ex);
        }

    }

     private void run() throws Exception {
        OracleConnection conn = connect();

        Properties prop = new Properties();
        prop.setProperty(OracleConnection.DCN_NOTIFY_ROWIDS, "true");

        prop.setProperty(OracleConnection.DCN_IGNORE_DELETEOP, "false");
        prop.setProperty(OracleConnection.DCN_IGNORE_UPDATEOP, "false");
        prop.setProperty(OracleConnection.DCN_QUERY_CHANGE_NOTIFICATION, "true");
        DatabaseChangeRegistration dcr = conn.registerDatabaseChangeNotification(prop);
        System.out.println("abc");
     }
     OracleConnection connect() throws SQLException {
        OracleDriver dr = new OracleDriver();
        Properties prop = new Properties();
        prop.setProperty("user", OracleDCN.USERNAME);
        prop.setProperty("password", OracleDCN.PASSWORD);
        return (OracleConnection) dr.connect(OracleDCN.URL, prop);
    }
}

标签： javasqldatabaseoracleoracle11g

解决方案

推荐阅读