Esempio n. 1
0
        private static void registryDB()
        {
            try {
                // 启动时建立ConnectionManager,需要正确配置Bitsflow参数
                Yoyosys.ConnectionManager manager = new Yoyosys.ConnectionManager("192.168.204.35:23245", "5678", "4567", "5888", "ConnectionManager");

                System.Console.WriteLine("1");
                // 构造数据,需要根据实际情况修改IP和connectionString
                Yoyosys.DatabaseConfig databaseConfig = new Yoyosys.DatabaseConfig();
                databaseConfig.name   = "test";
                databaseConfig.master = new Yoyosys.ConnectionConfig("192.168.204.73", "MTSBW", "NEWTEST", "oracle", "Oracle.DataAccess.Client"); // "Provider=MSDAORA.1;User ID=MTSBW;Password=mtsbw123;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.204.73)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = NEWTEST)))");
                List <Yoyosys.ConnectionConfig> slaveList = new List <Yoyosys.ConnectionConfig>();
                slaveList.Add(new Yoyosys.ConnectionConfig("192.168.204.74", "MTSBW", "NEWTEST", "oracle", "Oracle.DataAccess.Client"));          //"192.168.204.74","MTSBW", "Provider=MSDAORA.1;User ID=MTSBW;Password=mtsbw123;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.204.74)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = NEWTEST)))"));
                slaveList.Add(new Yoyosys.ConnectionConfig("192.168.204.75", "MTSBW", "NEWTEST", "oracle", "Oracle.DataAccess.Client"));          //"192.168.204.75", "MTSBW", "Provider=MSDAORA.1;User ID=MTSBW;Password=mtsbw123;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.204.75)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = NEWTEST)))"));
                databaseConfig.slaves = slaveList;
                manager.updateDatabaseConfig("core", databaseConfig);
                Thread.Sleep(500);
                System.Console.WriteLine("2");
                // DAO层获取数据库连接
                bool readOnly = false;
                Yoyosys.ConnectionConfig connectionConfig = manager.getConnectionConfig("core", readOnly);
                System.Console.WriteLine("3");
                // String connectionString = connectionConfig.connectionString;
                System.Console.WriteLine(connectionConfig.ip);
                manager.Dispose();
                connectionConfig = manager.getConnectionConfig("core", readOnly);
                //
                // Console.WriteLine("enter any key to end");
                // Console.ReadKey();
            }
            catch (Exception ex) {
                Console.WriteLine(ex);
            }
        }
Esempio n. 2
0
        static void iniConnectionManager()
        {
            _CloudConfigInfo = CloudConfigManager.GetConfigInfo();
            if (_CloudConfigInfo == null)
            {
                throw new MB.Util.APPException("MBCloudConfig 还没有进行配置,请先配置", APPMessageType.SysErrInfo);
            }

            var cfg = _CloudConfigInfo.CloudDbManager;

            if (_ConnectionManager == null)
            {
                lock (_Lock) {
                    if (_ConnectionManager == null)
                    {
                        _ConnectionManager = new Yoyosys.ConnectionManager(cfg.Agent, cfg.DatabaseService, cfg.MonitorService, cfg.GroupService, cfg.GroupName);
                        System.Threading.Thread.Sleep(2000);
                    }
                }
            }
        }