This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, We have an application using Lightspeed 3.0.789.12667 and we are getting database errors that appear intermittant in nature. We have these error randomly when we have more than one user using to our web application. The system works fine when there is only one user. The errors we are getting include: Invalid attempt to call Read when reader is closed. Internal connection fatal error. There is already an open DataReader associated with this Command which must be closed first. We have tried a couple of different SQL Server instances, but this doesn't seem to help. The application uses MVC 1.0 with NINJect as a dependancy injection. A previous version of the application used version 2 of lightspeed, and didn't seem to have this problam. I have included a log which may assist. Many thanks for your help. |
|
|
|
|
Hi David, This sounds like you are using a shared/static UnitOfWork object? If you are, you will need to refactor this so that each request produces a new unit of work object which will be disposed at the end of the request lifecycle. We have an example of this using a class call "PerRequestUnitOfWorkScope" which is in the ASP.NET and ASP.NET MVC samples which ship with LightSpeed. If you can post some more details about how you are managing your UnitOfWork we can try and provide some more specific guidance in your case.
Jeremy |
|
|
|
