|
Hi,
I am getting below error when I am generating a report using RDLC, and getting the data into the DataTable for one of my Windows application. My report works sometime and sometime don't. Suppose, I have to display 20 rows for that I am retrieving the data in datatable using foreach() and this breaks any of the occurance of loop (i.e 5th or 7th or 12th) and throws exception.
ERROR:
System.Data.OleDb.OleDbException: Unspecified error
at System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Spring.Data.NHibernate.HibernateTransactionManager .DoBegin(Object transaction, ITransactionDefinition definition)
at Spring.Transaction.Support.AbstractPlatformTransac tionManager.GetTransaction(ITransactionDefinition definition)
at Spring.Transaction.Interceptor.TransactionAspectSu pport.CreateTransactionIfNecessary(MethodInfo method, Type targetType)
at Spring.Transaction.Interceptor.TransactionIntercep tor.Invoke(IMethodInvocation invocation)
at Spring.Aop.Framework.AbstractMethodInvocation.Proc eed()
at Spring.Aop.Framework.DynamicProxy.AdvisedProxy.Inv oke(Object proxy, Object target, Type targetType, MethodInfo targetMethod, Object[] args, IList interceptors)
at Spring.Proxy.CompositionAopProxy_619ebcbba1e5449f9 8ed7d2ac5aa51fd.GetAttendanceForStudent(Int32 classId, Int32 studentId, DateTime beginDate, DateTime endDate)
....actually the build sometime works on 32bit machine, and always crashes on 64bit machine.
Please anyone can help..?
Thanks in Advance...
Regards: Madhusudan Kushwaha
|
|
|
|
|
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
|
|
|
|