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
|
I am intermittantly getting pooling issues with my connections..
evening though I have set pooling to true with 200 max connections..
any ideas? |
|
|
|
|
Hi Lawrence, How are you scoping and disposing of your UnitOfWork instances? This is the object in which LightSpeed opens and closes physical database connections so if you have any of these active there will be associated database connections active.
Jeremy |
|
|
|
|
Hi there, I presumed disposal and connection release was automatic, What is the best way to dispose and release the connections?
obj.dispose() ?
Lawrence |
|
|
|
|
This will depend on how you application is structured, but you need to be calling Dispose() on the UnitOfWork object at some point to have it release its resources and close the associated database connection. In general we would recommend keeping your UnitOfWork fairly tightly scoped in a using statement around the associated code block where you are working with your entities and this will automatically call Dispose() for you. For web applications where you need the UnitOfWork available through the lifetime of a request but disposed at the end of it have a look at the PerRequestUnitOfWorkScope object and have this disposed in the EndRequest event.
Jeremy |
|
|
|
