BDE Issues

[guidovalduchi]

We're running into a crazy problem with lock files, below is the synopsis from one of my programmers who can't figure out what, or how to get past BDE's inability to NOT use its lock file.

The borland BDE is the single connection point for all of our borland apps to the oracle database.

It has session management capabilities so multiple apps may use the same connections. It also keep two directories, in which it stores the temp database tables and other temp files. This is specified by Session->PrivateDir

The other directory is the network management directory, this marshalls the directory so that one user may have control of it at a time. this is specified by Session->NetDir.

The expected operation (as I understand it) is that when setting your temp files out on the network to be shared with other users you want to make sure that one user can mess with the temp tables at a time so no data get corrupted.

So you'd point the PrivateDir and the NetDir to the same location.

When storing the directories locally, when running multiple applications, the seperate applications hit this directory lock and assume that dir is in use. So they fail to start up.

Hopefully what should happen is no directory lock gets created, because it doesn't need to be. This would allow multiple applications to store their temp tables and files in the same directory.

Thanks in advance!

 

[Wings]

I could be way off base here, but you might want to look into the TransIsolation level of the database component you are using for your connection, as well as the handleshared property.