| public Connect ( string hostIp, int hostPortNo, string charSet, string dbName, string user, string pwd, int commandTimeoutSec = 60 ) : void | ||
| hostIp | string | |
| hostPortNo | int | |
| charSet | string | |
| dbName | string | |
| user | string | |
| pwd | string | |
| commandTimeoutSec | int | |
| return | void | |
public void Initialize(String ipAddress, Int32 portNo, String charSet, String dbName, String userId, String userPwd)
{
if (_cancelTasks != null)
throw new AegisException(AegisResult.AlreadyInitialized);
// Connection Test
try
{
DBConnector dbc = new DBConnector();
dbc.Connect(ipAddress, portNo, charSet, dbName, userId, userPwd);
dbc.Close();
}
catch (Exception e)
{
throw new AegisException(AegisResult.MySqlConnectionFailed, e, "Invalid MySQL connection.");
}
IpAddress = ipAddress;
PortNo = portNo;
CharSet = charSet;
DBName = dbName;
UserId = userId;
UserPwd = userPwd;
_cancelTasks = new CancellationTokenSource();
PingTest();
}
public void Initialize(string ipAddress, int portNo, string charSet, string dbName, string userId, string userPwd)
{
if (_cancelTasks != null)
{
throw new AegisException(AegisResult.AlreadyInitialized);
}
// Connection Test
try
{
DBConnector dbc = new DBConnector();
dbc.Connect(ipAddress, portNo, charSet, dbName, userId, userPwd);
dbc.Close();
}
catch (Exception e)
{
throw new AegisException(AegisResult.MySqlConnectionFailed, e, "Invalid MySQL connection.");
}
IpAddress = ipAddress;
PortNo = portNo;
CharSet = charSet;
DBName = dbName;
UserId = userId;
UserPwd = userPwd;
_cancelTasks = new CancellationTokenSource();
PingTest();
}
public void IncreasePool(Int32 count)
{
while (count-- > 0)
{
DBConnector dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
using (_lock.WriterLock)
{
_listPoolDBC.Add(dbc);
}
}
}
public void IncreasePool(int count)
{
int remain = _maxDBCCount - (PooledDBCCount + ActiveDBCCount);
count = (new Calculate.MinMaxValue <int>(remain, count)).Min;
while (count-- > 0)
{
DBConnector dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
_dbConnectors.Add(dbc);
_poolDBC.Enqueue(dbc);
}
}
internal DBConnector GetDBC()
{
lock (this)
{
if (_poolDBC.Count == 0 &&
PooledDBCCount + ActiveDBCCount < _maxDBCCount)
{
var dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
_poolDBC.Enqueue(dbc);
}
}
return(_poolDBC.Dequeue());
}
internal DBConnector GetDBC()
{
DBConnector dbc;
using (_lock.WriterLock)
{
if (_listPoolDBC.Count == 0)
{
dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
}
else
{
dbc = _listPoolDBC.ElementAt(0);
_listPoolDBC.RemoveAt(0);
_listActiveDBC.Add(dbc);
}
}
return(dbc);
}
internal DBConnector GetDBC()
{
DBConnector dbc;
using (_lock.WriterLock)
{
if (_listPoolDBC.Count == 0)
{
dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
}
else
{
dbc = _listPoolDBC.ElementAt(0);
_listPoolDBC.RemoveAt(0);
_listActiveDBC.Add(dbc);
}
}
return dbc;
}
public void IncreasePool(Int32 count)
{
while (count-- > 0)
{
DBConnector dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
using (_lock.WriterLock)
{
_listPoolDBC.Add(dbc);
}
}
}
internal DBConnector GetDBC()
{
lock (this)
{
if (_poolDBC.Count == 0 &&
PooledDBCCount + ActiveDBCCount < _maxDBCCount)
{
var dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
_poolDBC.Enqueue(dbc);
}
}
return _poolDBC.Dequeue();
}
public void IncreasePool(int count)
{
while (count-- > 0)
{
DBConnector dbc = new DBConnector();
dbc.Connect(IpAddress, PortNo, CharSet, DBName, UserId, UserPwd);
_poolDBC.Enqueue(dbc);
}
}