Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread A bit of a TService problem
Wed, Oct 18 2006 9:41 PMPermanent Link

Mark Shapiro
Under the control of a middleware server, my application uses a TMemoryStream to copy its
DBISAM tables to a back-up folder in the early hours of the morning. The application logs
the following error only on those sytems that are running the server application as a service:

exception class   : EFOpenError
exception message : Cannot open file "F:\Apps\Alice\tables\Child.dat". The process cannot
access the file because it is being used by another process.

I'm closing and then re-opening the TDBISAMDatabase component prior to the back-up. This
works fine in non-service setups Is there a way to release any table locks within a
service application or otherwise get around this problem?

Mark Shapiro
Thu, Oct 19 2006 5:11 AMPermanent Link

Telling the session to close is how I've done this - it makes sure any
temporary things are closed too.

/Matthew Jones/
Thu, Oct 19 2006 1:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mark,

<< I'm closing and then re-opening the TDBISAMDatabase component prior to
the back-up. This works fine in non-service setups Is there a way to release
any table locks within a service application or otherwise get around this
problem? >>

This isn't specific to services per se.  I would verify that there isn't any
session/data module caching in the middleware server.  If there is, then
make sure that you call the appropriate methods to clear out the cache prior
to running the backup.  That will make sure that all open tables are closed
so that you can access them as necessary.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Oct 20 2006 1:23 PMPermanent Link

Mark Shapiro
Mathew & Tim,

I'm not aware of any data caching going on but I will try turning the session off and on.
I had wanted to avoid that simply to avoid reloading password settings. However, that's a
minor consideration. Thanks to you both.

Mark Shapiro
Image