> Hi all. Sorry about another cflock question, but using it
> has stopped our system cold.
>
> Our system: CF v4.1 on NT integrating with ESRI ArcIMS and
> using SYBASE IQ12 on UNIX for our datawarehouse. In ArcIMS,
> the screen is divided into frames and and the CF comes on
> in one of the frames. I put a CFLOCK around a set of session
> variables. See code below. Then I have an SQL statement using
> the session.variables and put a CFLOCK around this too. Now,
> I have to say that it takes forever to get a query back (2 or
> more minutes) but I have no control over the IQ server and
> once I added the CFLOCK it came back with "Timed out while
> waiting to obtain exclusive lock." and stopped everything
> cold. To get it working again, we have to reboot our CF
> server. If we put a THROWTIMEOUT= "No" it will continue to
> process but we need those session variables for the query
> that follows.
>
> If I am to use CFLOCK how can I do it without locking our
> whole system?
I've never seen CFLOCK cause the server to need to be cycled!
There are a couple of things you might look at.
In your query, are you writing to session variables, or simply reading them?
If you're just reading them, you don't need an exclusive lock. You might
also, in that case, cast the variables to a local scope within a lock before
the query, then reference the local variables instead.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
