public void LifeTimeIsTakenInAccount()
{
var SMALLEST_LIFETIME_TO_TEST = 1;
var WAIT_TO_MAKE_LIFETIME_PASSED = 2;
TdsConnectionPoolManager sqlConnectionPools = new FakeConnectionPoolManager();
TdsConnectionInfo info = new TdsConnectionInfo("dummy", 0, 0, 0,
1 /*minpoolsize*/,
1 /*maxpoolsize*/,
SMALLEST_LIFETIME_TO_TEST /*lifetime*/);
TdsConnectionPool pool = sqlConnectionPools.GetConnectionPool("test", info);
Mono.Data.Tds.Protocol.Tds tds, tds2 = null;
tds = pool.GetConnection();
System.Threading.Thread.Sleep(TimeSpan.FromSeconds(WAIT_TO_MAKE_LIFETIME_PASSED));
pool.ReleaseConnection(tds);
tds2 = pool.GetConnection();
Assert.IsFalse(object.ReferenceEquals(tds, tds2));
pool.ReleaseConnection(tds2);
}
void Open()
{
string serverName = "";
if (connectionString == null || connectionString.Equals(""))
{
throw new InvalidOperationException("Connection string has not been initialized.");
}
try {
if (!pooling)
{
ParseDataSource(dataSource, out port, out serverName);
tds = new Tds50(serverName, port, PacketSize, ConnectionTimeout);
}
else
{
ParseDataSource(dataSource, out port, out serverName);
TdsConnectionInfo info = new TdsConnectionInfo(serverName, port, packetSize, ConnectionTimeout, minPoolSize, maxPoolSize);
pool = sybaseConnectionPools.GetConnectionPool(connectionString, info);
tds = pool.GetConnection();
}
}
catch (TdsTimeoutException e) {
throw SybaseException.FromTdsInternalException((TdsInternalException)e);
}
tds.TdsErrorMessage += new TdsInternalErrorMessageEventHandler(ErrorHandler);
tds.TdsInfoMessage += new TdsInternalInfoMessageEventHandler(MessageHandler);
if (!tds.IsConnected)
{
try {
tds.Connect(parms);
ChangeState(ConnectionState.Open);
ChangeDatabase(parms.Database);
}
catch {
if (pooling)
{
pool.ReleaseConnection(tds);
}
throw;
}
}
else if (connectionReset)
{
// tds.ExecuteNonQuery ("EXEC sp_reset_connection"); FIXME
ChangeState(ConnectionState.Open);
}
}
public void CheckNullException()
{
//set up dummy sql listener, if there is a real sql server on this
//machine at that port, in theory this part will fail, but that's ok
//becuase something will be listening on the port and that's all we
//require at this point: a listener on port 1433...
try{
Socket Listener = new Socket(AddressFamily.InterNetwork,
SocketType.Stream,
ProtocolType.Tcp);
IPAddress hostIP = Dns.GetHostEntry("localhost").AddressList[0];
IPEndPoint ep = new IPEndPoint(hostIP, 1433);
Listener.Bind(ep);
Listener.Listen(1);
} catch (Exception) {
//ignore
}
//try to connect twice, in earlier failure would get null exception
//on 2nd call to pool.GetConnection();
//Most of this code ripped from sqlConnection.Open()
TdsConnectionPool pool;
TdsConnectionPoolManager sqlConnectionPools =
new TdsConnectionPoolManager(TdsVersion.tds80);
TdsConnectionInfo info =
new TdsConnectionInfo(SERVER /*dummyhost*/, 1433 /*port*/,
8192 /*pktsize*/, 15 /*timeout*/, 0 /*minpoolsize*/,
100 /*maxpoolsize*/, 0 /*lifetime*/);
pool = sqlConnectionPools.GetConnectionPool("test", info);
Tds tds = null;
//this first one succeeded regardless as long as something answered
//the phone on port 1433 of localhost
tds = pool.GetConnection();
pool.ReleaseConnection(tds);
// 2nd time thru: This will fail with nullreferenceexception
// at pool.GetConnection() unless the patch by Rob Wilkens which
// adds "result=null;" before retry in pool.getConnection() source
//First let's pretend we're calling this test fresh, as if we
//call sqlConnection.Open() again :
info = new TdsConnectionInfo(SERVER /*dummyhost*/, 1433 /*port*/,
8192 /*pktsize*/, 15 /*timeout*/, 0 /*minpoolsize*/,
100 /*maxpoolsize*/, 0 /*lifetime*/);
pool = sqlConnectionPools.GetConnectionPool("test", info);
//Then: Test for failure (will raise uncaught exception which
//causes failure of test if bug is not fixed
tds = pool.GetConnection();
pool.ReleaseConnection(tds);
//exit
}
public void CheckNullException()
{
//set up dummy sql listener, if there is a real sql server on this
//machine at that port, in theory this part will fail, but that's ok
//becuase something will be listening on the port and that's all we
//require at this point: a listener on port 1433...
try{
Socket Listener = new Socket(AddressFamily.InterNetwork,
SocketType.Stream,
ProtocolType.Tcp);
IPAddress hostIP =Dns.GetHostEntry("localhost").AddressList[0];
IPEndPoint ep = new IPEndPoint(hostIP, 1433);
Listener.Bind(ep);
Listener.Listen(1);
} catch (Exception){
//ignore
}
//try to connect twice, in earlier failure would get null exception
//on 2nd call to pool.GetConnection();
//Most of this code ripped from sqlConnection.Open()
TdsConnectionPool pool;
TdsConnectionPoolManager sqlConnectionPools =
new TdsConnectionPoolManager(TdsVersion.tds80);
TdsConnectionInfo info=
new TdsConnectionInfo(SERVER/*dummyhost*/,1433/*port*/,
8192/*pktsize*/,15/*timeout*/,0/*minpoolsize*/,
100/*maxpoolsize*/, 0/*lifetime*/);
pool=sqlConnectionPools.GetConnectionPool("test",info);
Tds tds=null;
//this first one succeeded regardless as long as something answered
//the phone on port 1433 of localhost
tds=pool.GetConnection();
pool.ReleaseConnection(tds);
// 2nd time thru: This will fail with nullreferenceexception
// at pool.GetConnection() unless the patch by Rob Wilkens which
// adds "result=null;" before retry in pool.getConnection() source
//First let's pretend we're calling this test fresh, as if we
//call sqlConnection.Open() again :
info=new TdsConnectionInfo(SERVER/*dummyhost*/,1433/*port*/,
8192/*pktsize*/,15/*timeout*/,0/*minpoolsize*/,
100/*maxpoolsize*/, 0/*lifetime*/);
pool=sqlConnectionPools.GetConnectionPool("test",info);
//Then: Test for failure (will raise uncaught exception which
//causes failure of test if bug is not fixed
tds=pool.GetConnection();
pool.ReleaseConnection(tds);
//exit
}
public override Mono.Data.Tds.Protocol.Tds CreateConnection(TdsConnectionInfo info)
{
return(new FakeTds(info.LifeTime));
}