Issue with connection pool. Getting Underlying provider failed error after max pool size reached
Posted: Fri 05 Oct 2012 16:40
Hi,
I am using dotConnect for Oracle. I am getting "Underlying provider failed" eror after my connection pool reaches 100 since the default setting of the connection pool is 100. The connections from the connection pool are not getting reused. Below is my sample code. Can somebody please let me know what is wrong here?.
Connection string -
<add name="MyNamespace.EntityFrameWorkConnectionString"
connectionString="metadata=res://*/MyNamespace.EntityFrameWork.csdl|res://*/MyNamespace.EntityFrameWork.ssdl|res://*/MyNamespace.EntityFrameWork.msl;provider=Devart.Data.Oracle;provider connection string='User Id=db_user;Password=db_pwd;Server=ora_server;Persist Security Info=True';"
providerName="System.Data.EntityClient" />
using (DBEntity dbEntity = new DBEntity())
{
MyTableRec tableRec = new tableRec()
{
ResponsibilitieId = GenericHelper.GetNextSequenceValue(GenericHelper.TABLE_NAME),
Name = "Some Name",
CreatedBy = "User1"
};
try
{
dbEntity.AddToMyTable(tableRec);
dbEntity.SaveChanges();
}
catch
{
isSuccess = GenericHelper.isNotSucessfull;
}
}
I am using dotConnect for Oracle. I am getting "Underlying provider failed" eror after my connection pool reaches 100 since the default setting of the connection pool is 100. The connections from the connection pool are not getting reused. Below is my sample code. Can somebody please let me know what is wrong here?.
Connection string -
<add name="MyNamespace.EntityFrameWorkConnectionString"
connectionString="metadata=res://*/MyNamespace.EntityFrameWork.csdl|res://*/MyNamespace.EntityFrameWork.ssdl|res://*/MyNamespace.EntityFrameWork.msl;provider=Devart.Data.Oracle;provider connection string='User Id=db_user;Password=db_pwd;Server=ora_server;Persist Security Info=True';"
providerName="System.Data.EntityClient" />
using (DBEntity dbEntity = new DBEntity())
{
MyTableRec tableRec = new tableRec()
{
ResponsibilitieId = GenericHelper.GetNextSequenceValue(GenericHelper.TABLE_NAME),
Name = "Some Name",
CreatedBy = "User1"
};
try
{
dbEntity.AddToMyTable(tableRec);
dbEntity.SaveChanges();
}
catch
{
isSuccess = GenericHelper.isNotSucessfull;
}
}