This is from our Cold Fusion programmer:

All our apps do are SQL SELCT statements (a few of which are complex with joins), but the only commands being sent are SELECT. I do not explicitly set a lock command or statement anywhere in the application. We are using Cold Fusion 7 connecting to UniVerse via IBMs JDBC driver.

Pam





Ray Wurlod wrote:
If this is UniVerse there is a uvconfig parameter MAXRLOCK that specifies how 
many record locks to take (on an INSERT, UPDATE or DELETE statement) before 
choosing to use a FILELOCK.  Reducing this parameter will mean fewer record 
locks per query, at the cost of greater danger of another updating process 
being locked out of the table till the first process finishes its updates.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/



--
Pamela J Robbins             New Bolton Center
Senior Programmer Analyst    School of Veterinary Medicine
[EMAIL PROTECTED]       University of Pennsylvania
610-925-6438 -------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to