ServerAutoCommit property |
Applies to
TIB_Transaction
Declaration
Property ServerAutoCommit : boolean;
Description
Use the native AutoCommit mode of InterBase. If you are watching the SQL
trace monitor and looking for any COMMIT RETAINING calls due to AutoCommit
being true then you will not see any. You will only see a COMMIT or ROLLBACK
call to end the transaction. I don't bother calling anything when I know the
commit has been performed on the server automatically.
In some cases it is necessary to set this to true when executing scripts that
have DDL in them. If you have a script that is giving errors try setting this
to true.
Another great reason to set this to true is to initiate a change on the server
that must be committed. If this is false then the client still has to issue a
subsequent call to commit the changes made by executing the statement which
opens up a point of failure. Setting this to true will guarantee that if the
statement executes properly on the server that it will be committed at the
same time.
Note: You cannot use PessimisticLocking when this property is true.