Database Change Notification

使用java监控oracle数据库的变化，主要是针对表数据，如果发生变化，使用select去查询，能够达到推送的目的

package com.test.notifi;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import oracle.jdbc.OracleConnection;
import oracle.jdbc.OracleDriver;
import oracle.jdbc.OracleStatement;
import oracle.jdbc.dcn.DatabaseChangeEvent;
import oracle.jdbc.dcn.DatabaseChangeListener;
import oracle.jdbc.dcn.DatabaseChangeRegistration;
import oracle.jdbc.pool.OracleDataSource;

public class TestNotification {

    public void run(){
        OracleDataSource dataSource;
        try {
            dataSource = new OracleDataSource();
               dataSource.setUser("hw");
                dataSource.setPassword("112311");
                dataSource.setURL("jdbc:oracle:thin:@198.22.1.4:1521:COPYDB1");
                 OracleConnection conn = (OracleConnection) dataSource.getConnection();
                 
                 Properties prop = new Properties();
                 prop.setProperty(OracleConnection.DCN_NOTIFY_ROWIDS,"true");
                 prop.setProperty(OracleConnection.DCN_QUERY_CHANGE_NOTIFICATION,"true");
                 DatabaseChangeRegistration dcr = conn.registerDatabaseChangeNotification(prop);
                 
                 DCNDemoListener list = new DCNDemoListener(this);
                 dcr.addListener(list);
                 
                 Statement stmt = conn.createStatement();
                 
                 ((OracleStatement)stmt).setDatabaseChangeRegistration(dcr);
//                  ResultSet rs = stmt.executeQuery("select * from hs_secu.entrust a where a.fund_account = '610005385'");
                  ResultSet rs = stmt.executeQuery("select * from stocc");
                  while (rs.next())
                  {}
                  String[] tableNames = dcr.getTables();
                  for(int i=0;i<tableNames.length;i++)
                    System.out.println(tableNames[i]+" is part of the registration.");
                  rs.close();
                  stmt.close();
                  conn.close();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            
        }
    }
    
    public static void main(String[] a) {
            TestNotification notification = new TestNotification();
            notification.run();
}
    
}

package com.test.notifi;

import oracle.jdbc.dcn.DatabaseChangeEvent;
import oracle.jdbc.dcn.DatabaseChangeListener;

class DCNDemoListener implements DatabaseChangeListener
{
  TestNotification demo;
  DCNDemoListener(TestNotification dem)
  {
    demo = dem;
  }
  public void onDatabaseChangeNotification(DatabaseChangeEvent e)
  {
    Thread t = Thread.currentThread();
    System.out.println("DCNDemoListener: got an event ("+this+" running on thread "+t+")");
    System.out.println(e.toString());
    synchronized( demo ){ demo.notify();}
  }
}

使用windows机器去运行这个程序的时候，请注意，hostname需要添加自己的IP和主机名称

例如：  198.28.1.2 TIM-PC

这样oracle数据库才能知道是谁注册的