solidDB Help : Configuring and administering : Performance tuning : Reducing Bonsai tree size by committing transactions : Preventing excessive Bonsai tree growth : Providing COMMIT statements in the application code
  
Providing COMMIT statements in the application code
To make sure that every database operation gets committed, perform one of the following operations:
Execute the statement COMMIT WORK.
Call ODBC function SQLTransact or SQLEndTran.
Call JDBC method commit.
Make sure that these operations succeed by checking the return code or by properly catching the possible exception. Be aware of how many database connections your application has, when and where they are created, and when the transactions at these connections are committed.
Go up to
Preventing excessive Bonsai tree growth