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.