Hi

I am getting the OleDbException error:

2008-04-08 18:10:09,093 [11] INFO AbleSoft.TTBox.UI.Forms.Startup.Support.Logger [(null)] <(null)> - System.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Spring.Data.NHibernate.HibernateTransactionManager.DoBegin(Object transaction, ITransactionDefinition definition)
at Spring.Transaction.Support.AbstractPlatformTransactionManager.GetTransaction(ITransactionDefinition definition)
at Spring.Transaction.Interceptor.TransactionAspectSupport.CreateTransactionIfNecessary(MethodInfo method, Type targetType)
at Spring.Transaction.Interceptor.TransactionInterceptor.Invoke(IMethodInvocation invocation)
at Spring.Aop.Framework.AbstractMethodInvocation.Proceed()
at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Invoke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, Object[] args, IList interceptors)
at Spring.Proxy.CompositionAopProxy_325f4bf92dce48108840b3dc168e7bce.GetAttendanceForStudent(Int32 classId, Int32 studentId, DateTime beginDate, DateTime endDate)

I assume that this could be the reason for timeout for the connection, so I used below settings.

<system.transactions>
<defaultSettings timeout="02:00:30" />
</system.transactions>

in app.config and

<entry key="hibernate.c3p0.timeout" value="50000"/>

in my DAOContext.xml file, but both case doesn't work.


Regards: Madhusudan