internal void Connect(String connectionName)
{
var connectString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
/*
* if (this.connection != null)
* {
* if (this.connection.State == System.Data.ConnectionState.Open)
* {
* this.connection.Close();
* }
*
* }
*/
// Logger.Debug(String.Format("Connecting with {0}", connectString));
this.connection = new MySqlConnection
{
ConnectionString = connectString
};
this.connection.Open();
var f = DbProviderFactories.GetFactory("MySql.Data.MySqlClient"); //your provider
var b = f.CreateConnectionStringBuilder();
b.ConnectionString = connectString;
String hostname = b["server"].ToString();
this.hostIp = HostUtil.HostnameToIp(hostname);
}
public TuDbConnection(String connectionName, Int32 id)
{
this.poolId = id;
var connectString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
var f = DbProviderFactories.GetFactory("MySql.Data.MySqlClient"); //your provider
var b = f.CreateConnectionStringBuilder();
b.ConnectionString = connectString;
String hostname = b["server"].ToString();
this.hostIp = HostUtil.HostnameToIp(hostname);
// this.Connect(connectionName);
}
public ConnectionManager(String connectionName, int poolSize)
{
this.connectionName = connectionName;
this.connectionPool = new List <TuDbConnection>(poolSize);
var connectString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
var f = DbProviderFactories.GetFactory("MySql.Data.MySqlClient"); //your provider
var b = f.CreateConnectionStringBuilder();
b.ConnectionString = connectString;
String hostname = b["server"].ToString();
this.currentHostIp = HostUtil.HostnameToIp(hostname);
for (int i = 0; i < poolSize; i++)
{
TuDbConnection conn = new TuDbConnection(connectionName, i);
this.connectionPool.Insert(i, conn);
}
}
public TuDbConnection GetConnection()
{
connectionMutex.WaitOne();
String connectString;
DbProviderFactory f;
DbConnectionStringBuilder b;
String hostname;
String hostIp;
try
{
connectString = System.Configuration.ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
f = DbProviderFactories.GetFactory("MySql.Data.MySqlClient"); //your provider
b = f.CreateConnectionStringBuilder();
b.ConnectionString = connectString;
hostname = b["server"].ToString();
hostIp = HostUtil.HostnameToIp(hostname);
}
catch (Exception ex)
{
Logging.Logger.Error("Internal error: " + ex.Message);
return(null);
}
TuDbConnection conn = null;
try
{
for (int i = 0; i < this.connectionPool.Count; i++)
{
if (!this.connectionPool[i].InUse)
{
this.connectionPool[i].InUse = true;
if (hostIp != this.currentHostIp)
{
Logging.Logger.Debug("ConnectionManager: IP of host has changed");
Int32 hostsCleared = 0;
Int32 hostsRemaining = 0;
for (int j = 0; j < this.connectionPool.Count; j++)
{
if (!this.connectionPool[j].InUse && this.connectionPool[j].HostIp != hostIp)
{
hostsCleared++;
Logging.Logger.Debug(String.Format("ConnectionManager: Clearing pool of connection {0}", j));
connectionPool[j].ClearPool();
this.connectionPool[j].HostIp = hostIp;
}
else if (this.connectionPool[j].InUse && this.connectionPool[j].HostIp != hostIp)
{
Logging.Logger.Debug(String.Format("ConnectionManager: Remaining Poold Id {0} Connection Id {1} Host Ip {2}", this.connectionPool[j].PoolId, this.connectionPool[j].ConnectionId, this.connectionPool[j].HostIp));
hostsRemaining++;
}
}
if (hostsCleared == 0 && hostsRemaining == 0)
{
Logging.Logger.Debug("ConnectionManager: All connections have been switched over. Setting hostIp");
this.currentHostIp = hostIp;
}
else
{
Logging.Logger.Debug(String.Format("ConnectionManager: {0} cleared {1} remaining", hostsCleared, hostsRemaining));
}
}
else
{
if (this.connectionPool[i].State == ConnectionState.Open)
{
this.connectionPool[i].Release();
}
}
this.connectionPool[i].Connect(this.connectionName);
conn = this.connectionPool[i];
break;
}
}
}
catch (Exception ex)
{
Logging.Logger.Error(string.Format("ConnectionManager: Exception while trying to get connection from connection pool: {0}", ex.Message));
connectionMutex.ReleaseMutex();
return(null);
}
ConnectionManager.connectionMutex.ReleaseMutex();
if (conn == null)
{
throw new DbNoConnections();
}
return(conn);
}
