ODBiC Discussion Board


RE: Does Commit SQL commands have any value?, Max Steiner, 03-08-2008

The default is "auto-commit" is on

by Roger Harris, March 8, 2008 22:51

"Auto-commit" will automatically commit inserts and updates when each statement is executed, so COMMIT would not have any effect. (If you need transactions, you can use <%SETOPTION SQL_AUTO_COMMIT="OFF"%> and then use whatever "begin transaction" syntax your database supports, and use COMMIT or ROLLBACK to complete.)

There are some other ODBC controls that you can set with SETOPTION that might help (although not all drivers support some of them):

SETOPTION SQL_ACCESS_MODE = READ_ONLY or READ_WRITE

(Read_write is the default, which does lock, so setting read_only may help if you have queries that won't update any rows. However, if another script already has a row locked for read_write, you won't be able to read it. This just means that the script opening for read_only won't lock it.)

SETOPTION SQL_TXN_ISOLATION = READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, or SERIALIZABLE

(See your database documentation to see if these are supported and precisely how they are handled.)



Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.