public static void Destroy() { Logging.WriteLine("Destroying PhoenixEmu environment..."); if (GetGame() != null) { GetGame().Destroy(); Game = null; } if (GetConnectionManager() != null) { Logging.WriteLine("Destroying connection manager."); GetConnectionManager().GetListener().Destroy(); GetConnectionManager().DestroyManager(); ConnectionManager = null; } if (GetDatabase() != null) { try { Logging.WriteLine("Destroying database manager."); MySqlConnection.ClearAllPools(); DatabaseManager = null; } catch { } } Logging.WriteLine("Uninitialized successfully. Closing."); }
public void TestBadConnections() { MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder(); builder.Pooling = true; builder.Server = "xxxxxxxx"; // one that definitely does not exist. builder.UserID = "whoever"; builder.Password = "******"; int numberOfConnections = 1; for (int i = 0; i < numberOfConnections; ++i) { using (MySqlConnection connection = new MySqlConnection(builder.ConnectionString)) { try { connection.Open(); Assert.Fail("Connection should throw an exception."); } catch (Exception ex) { } } Thread.Sleep(50); } MySqlConnection.ClearAllPools(); }
private MySqlProvider(MySqlTransaction trans = null) { if (trans != null) { this.Trans = trans; this.Conn = trans.Connection; InTrans = true; } else { var connString = MySqlConf.ConnString(); try { this.Conn = new MySqlConnection(connString); Conn.Open(); } catch { MySqlConnection.ClearAllPools(); this.Conn = new MySqlConnection(connString); Conn.Open(); } } this.Parameters = new List <DbParameter>(); }
protected override void Dispose(bool disposing) { if (Interlocked.Decrement(ref total) == 0) { MySqlConnection.ClearAllPools(); } }
private void fillPerTicket(int ticketId) { DataTable ticketTable = new DataTable(); using (MySqlConnection myConn = new MySqlConnection(myConnString)) { //string query = "select * from TechDailyTicket where techId = " + box.SelectedValue + ";"; string query = "SELECT * FROM PerTicket WHERE ticketId=" + ticketId + ";"; //always add one for starters Console.WriteLine(query); using (MySqlCommand myComm = new MySqlCommand(query, myConn)) { MySqlDataAdapter myAdapter = new MySqlDataAdapter(); myAdapter.SelectCommand = myComm; myAdapter.Fill(ticketTable); myComm.Dispose(); } myConn.Close(); myConn.Dispose(); MySqlConnection.ClearPool(myConn); } MySqlConnection.ClearAllPools(); //this.perticketTableAdapter.Fill(ticketTable); this.partsOnTixDisplay.DataSource = ticketTable; resetPartsOnDisplayForRowOne(); }
private void deleteButton_Click(object sender, EventArgs e) { int ticketId = selectedTicket; int itemId = selectedPartToRemove; if (ticketId == -1 || itemId == -1) { return; } using (MySqlConnection myConn = new MySqlConnection(myConnString)) { //string query = "select * from TechDailyTicket where techId = " + box.SelectedValue + ";"; string query = "DELETE FROM ItemsUsed WHERE ticketId=" + ticketId + " AND itemId=" + itemId + ";"; //always add one for starters Console.WriteLine(query); using (MySqlCommand myComm = new MySqlCommand(query, myConn)) { myComm.Connection.Open(); myComm.ExecuteNonQuery(); myComm.Dispose(); } myConn.Close(); myConn.Dispose(); MySqlConnection.ClearPool(myConn); } MySqlConnection.ClearAllPools(); //refresh the per ticket stuff fillPerTicket(ticketId); }
public static void smethod_16() { Logging.WriteLine("Destroying GoldTreeEmu environment..."); if (GoldTree.GetGame() != null) { GoldTree.GetGame().ContinueLoading(); GoldTree.Game = null; } if (GoldTree.smethod_14() != null) { Logging.WriteLine("Destroying connection manager."); GoldTree.smethod_14().method_3().method_2(); GoldTree.smethod_14().method_0(); GoldTree.ConnectionManage = null; } if (GoldTree.GetDatabase() != null) { try { Logging.WriteLine("Destroying database manager."); MySqlConnection.ClearAllPools(); GoldTree.DatabaseManager = null; } catch { } } Logging.WriteLine("Uninitialized successfully. Closing."); }
public virtual void Teardown() { MySqlConnection.ClearAllPools(); #if !RT CheckOrphanedConnections(); #endif conn.Close(); if (Version.Major < 5) { suExecSQL("REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'test'"); } else { suExecSQL("DROP USER 'test'@'localhost'"); } DropDatabase(database0); DropDatabase(database1); DropDatabase("Perm"); if (rootConn.State == ConnectionState.Open) { rootConn.Close(); } }
protected virtual void Dispose(bool disposing) { if (disposed) { return; } if (disposing) { MySqlConnection.ClearAllPools(); #if !RT CheckOrphanedConnections(); #endif if (rootConn.State == ConnectionState.Closed) { rootConn.Open(); } DropDatabase(database0); DropDatabase(database1); DropDatabase("Perm"); rootConn.Close(); conn.Close(); } disposed = true; }
public System.Data.DataTable ExecuteDataTable(System.Data.CommandType cmdType, string cmdText, params System.Data.Common.DbParameter[] commandParameters) { MySqlCommand cmd = new MySqlCommand(); MySqlConnection conn = new MySqlConnection(connectionString); try { MySqlConnection.ClearAllPools(); PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); DataTable dt = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); adapter.Fill(dt); return(dt); } catch { conn.Close(); throw; } finally { conn.Close(); } }
public static void Fatal(Exception ex, string Source) { HttpContext.Current.Response.StatusCode = 500; try { try { if (ex.GetBaseException().GetType().ToString() == "MySql.Data.MySqlClient.MySqlException") { MySqlConnection.ClearAllPools(); } } catch { } Fatal("[" + ex.GetBaseException().GetType().ToString() + "]" + ex.GetBaseException().Message, ex.GetBaseException().ToString(), "Fatal " + ex.GetBaseException().GetType().ToString(), Source); } catch { try { if (ex.GetType().ToString() == "MySql.Data.MySqlClient.MySqlException") { MySqlConnection.ClearAllPools(); } } catch { } Fatal("[" + ex.GetType().ToString() + "]" + ex.Message, ex.ToString(), "Fatal " + ex.GetType().ToString(), Source); } }
public void SetupDatabase() { Thread.Sleep(10000); const string database = "countries"; for (int i = 0; i < 20; i++) { try { using var connection = new MySqlConnection(Configuration.GetConnectionString("Root")); connection.Open(); var command = new MySqlCommand($"create database if not exists `{database}`", connection); command.ExecuteNonQuery(); connection.Close(); break; } catch (Exception) { if (i == 19) { throw; } } MySqlConnection.ClearAllPools(); Thread.Sleep(5000); } CreateCountryTable(); }
public static void Destroy() { Program.DeleteMenu(Program.GetSystemMenu(Program.GetConsoleWindow(), true), Program.SC_CLOSE, Program.MF_BYCOMMAND); Logging.WriteLine("Destroying GoldTreeEmu environment..."); if (GoldTree.GetGame() != null) { GoldTree.GetGame().ContinueLoading(); GoldTree.Internal_Game = null; } if (GoldTree.GetSocketsManager() != null) { Logging.WriteLine("Destroying connection manager."); GoldTree.GetSocketsManager().method_3().method_2(); //GoldTree.smethod_14().Destroy(); GoldTree.GetSocketsManager().method_0(); GoldTree.SocketsManager = null; } if (GoldTree.GetDatabase() != null) { try { Logging.WriteLine("Destroying database manager."); MySqlConnection.ClearAllPools(); GoldTree.DatabaseManager = null; } catch { } } Logging.WriteLine("Uninitialized successfully. Closing."); }
protected void Button1_Click1(object sender, EventArgs e) { MySqlConnection.ClearAllPools(); using (MySqlConnection con = new MySqlConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (MySqlCommand com = new MySqlCommand("SELECT username,password FROM PROFILE", con)) { using (MySqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { if (reader.GetString("username") == tbUsername.Text && reader.GetString("password") == tbPassword.Text) { Label1.Text = "พบผู้ใช้งาน"; Label1.Visible = true; } else { Label1.Text = "ไม่พบผู้ใช้งานหรือรหัสผ่านไม่ถูกต้อง"; Label1.Visible = true; //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertmessage", "alert('ไม่พบผู้ใช้งานหรือรหัสผ่านไม่ถูกต้อง')", true); } } } } } }
public static void BindGridView(GridView gv, string sql) { MySqlConnection.ClearAllPools(); SqlDataSource sds = CreateSQLDataSource(sql); gv.DataSource = sds; gv.DataBind(); }
public static void BindDropDownNon(DropDownList ddl, string sql, string text, string value) { MySqlConnection.ClearAllPools(); ddl.DataSource = CreateSQLDataSource(sql); ddl.DataTextField = text; ddl.DataValueField = value; ddl.DataBind(); }
/// <summary> /// 关闭MySql连接池,释放资源 /// </summary> internal static void Close() { try { MySqlConnection.ClearAllPools(); } catch { } }
protected virtual void Dispose(bool disposing) { if (disposing) { Connection.Dispose(); MySqlConnection.ClearAllPools(); } }
public override async Task DeleteAsync(CancellationToken cancellationToken = default(CancellationToken)) { MySqlConnection.ClearAllPools(); using (var workingConnecton = _connection.CreateSystemConnection()) { await _migrationCommandExecutor.ExecuteNonQueryAsync(GetDropOps(), workingConnecton, cancellationToken); } }
//public override void CreateTables() //{ // IReadOnlyList<MigrationOperation> ops = modelDiffer.GetDifferences(null, Model); // IReadOnlyList<SqlBatch> sqlBatches = sqlGenerator.Generate(ops, Model); // SqlStatementExecutor.ExecuteNonQuery(connection, connection.DbTransaction, sqlBatches); //} //public override async Task CreateTablesAsync(CancellationToken cancellationToken = default(CancellationToken)) //{ // IReadOnlyList<MigrationOperation> ops = modelDiffer.GetDifferences(null, Model); // IReadOnlyList<SqlBatch> sqlBatches = sqlGenerator.Generate(ops, Model); // await SqlStatementExecutor.ExecuteNonQueryAsync(connection, connection.DbTransaction, sqlBatches, cancellationToken); //} public override void Delete() { MySqlConnection.ClearAllPools(); using (var workingConnecton = _connection.CreateSystemConnection()) { _migrationCommandExecutor.ExecuteNonQuery(GetDropOps(), workingConnecton); } }
public static void BindDropDown(DropDownList ddl, string sql, string text, string value, string first) { MySqlConnection.ClearAllPools(); ddl.DataSource = CreateSQLDataSource(sql); ddl.DataTextField = text; ddl.DataValueField = value; ddl.DataBind(); ddl.Items.Insert(0, new ListItem(first, "")); }
public virtual void Dispose(bool disposing) { if (disposing) { MySqlConnection.ClearAllPools(); execSQL($"DROP DATABASE IF EXISTS `{Connection.Database}`"); Connection.Close(); } }
/** * Dispose all MySQL connections */ public static void mysqlDispose() { if (dbConn != null) { dbConn.Close(); dbConn.Dispose(); MySqlConnection.ClearAllPools(); } }
/// <summary> /// /// </summary> public override void ClearAllPools() { try { MySqlConnection.ClearAllPools(); } catch (Exception e) { TraceLog.WriteSqlError("ClearAllPools error:{0}", e); } }
public MySqlConnection baglan() // class içinde baglan adında fonksiyon oluşturduk { MySqlConnection baglanti = new MySqlConnection("Server=localhost;Database=schoolproject;Uid=root;Pwd=;"); //bağlantı yolunu verdik baglanti.Open(); //bağlantıyı açtık MySqlConnection.ClearPool(baglanti); MySqlConnection.ClearAllPools(); //bundan önceki bağlantıları temizledik return(baglanti); //çağırıldığı yere bağlantıyı yolladık }
private bool disposedValue = false; // To detect redundant calls protected virtual void Dispose(bool disposing) { if (!disposedValue) { if (disposing) { MySqlConnection.ClearAllPools(); } disposedValue = true; } }
internal protected virtual void Initialize() { // we don't use FileVersion because it's not available // on the compact framework string fullname = Assembly.GetExecutingAssembly().FullName; string[] parts = fullname.Split(new char[] { '=' }); string[] versionParts = parts[1].Split(new char[] { '.' }); database0 = String.Format("db{0}{1}{2}-a", versionParts[0], versionParts[1], port - 3300); database1 = String.Format("db{0}{1}{2}-b", versionParts[0], versionParts[1], port - 3300); MySqlConnection.ClearAllPools(); }
public void Refresh(string name, string master, params string[] slaves) { MySqlConnection.ClearAllPools(); ConnectionManager.Remove(name); ConnectionManager.Add(name, master, false); if (slaves?.Length > 0) { foreach (var conn in slaves) { ConnectionManager.Add(name, conn, true); } } }
public void OneTimeTearDownAttribute() { MySqlConnection.ClearAllPools(); CleanupDatabase(); if (Connection != null && Connection.State == ConnectionState.Open) { Connection.Close(); } if (Root != null && Root.State == ConnectionState.Open) { Root.Close(); } }
protected virtual void Dispose(bool disposing) { if (disposed) { return; } if (disposing) { MySqlConnection.ClearAllPools(); CleanupDatabase(); } disposed = true; }