Hi All,
I've got a CFMX 7 server talking to a database called Advantage
Database Server (ADS) by Extended Systems. In terms of files, ADS is kinda
between a RDMS that we're all used to and Access. It's got a bunch of files
that serve as the various tables and then it's got a data dictionary that is
responsible for maintaining the associations between the tables (and to a
certain extent, the schema of each table). Here's where things get
funky.you can create tables outside of the data dictionary (called free
tables) and then add them to the data dictionary. At this point the table
has a unique identifier that points to the data dictionary, and the data
dictionary has a unique identifier that points to that specific table/file.
Think of it as dBase making babies with a 'regular' RDMS. This may be
normal for some people out there.but it's new to me.
Anyways, on my DB server the data needs to be updated
periodically. The application that's currently running under CF doesn't
write to the data, it only looks things up. The way the updates happen is
that the tables and the data dictionary are copied in wholesale. On the
next call to the data dictionary, the new data is caught and all is well
with the world. Something to keep in mind is that when the data is being
accessed the data dictionary is locked so that you can't make any changes to
the tables/files or the overall schema of the DB. The old consumer of this
data opened a DB connection did it's thing, and closed the connection. This
worked great because ADS would release the lock on the files in between user
lookups, the update guy could do his thing during the off hours.
(have a headache yet?) Okay, now with CF the connections to the
DB are never closed. This means that the updates can't happen because ADS
has locked the data dictionary. I've tried the usual settings and I can't
get CF to release the connections reliably without restarting the server.
Does anybody have any ideas on how to get CF to either close all connections
on a given datasource, or to get CF to close a connection after it's done
with it. The check box in the administrator isn't doing it for me.
Thanks for letting me share my misery.
Best Regards,
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5503
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/10
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
