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); } }
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); } } } }