Hi, I�m thinking about writing a DB adapter for Mimer SQL Engine ( www.mimer.com <http://www.mimer.com/> ). I read the methods that needs to be implemented and I saw that I need to implement void lockTable(Connection con, String table) if the database doesn�t support table locking.
Now, heres the funny part. Mimer doesn�t use locking at all. It uses something called optimistic concurrency control (pessimistic concurrency control is locking). But this is done at the row level. You can read more about optimistic concurrency control here: http://developer.mimer.com/features/feature_15.htm 1) Does anyone know if that will work with Torque? 2) Do I only need to implement the table locking at the process level or do I need to prevent several processes from writing to the same table at once? 3) And here�s the trickiest question: what happens if I don�t implement table locking at all in an occ database? Will it somehow magically work? And finally, why does the design rely on table locking and how does that affect performance? Regards, Olof Edlund
