Is Informix transaction logging required?

Article ID: 782
Last updated: 05 Feb, 2008
Article ID: 782
Last updated: 05 Feb, 2008
Revision: 1
Views: 8302
Posted: 22 Jul, 1997
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
Problem


When I use the DBTools.h++ Access Library for Informix with transaction logging disabled on my database, I get a server error, -261. Must transaction logging be enabled to use DBTools.h++?


Cause


Many of the features in DBTools.h++ (such as beginTransaction(), commitTransaction(), and rollbackTransaction()) require transaction support on your database. In addition, DBTools.h++ internally uses your database's transaction features for other purposes (RWDBCursor is one example). If you receive this error (-261), this usually means you have used a feature that requires transaction logging to be enabled.


Action


If you aren't using transactions in your application with version 2.x, it should be safe to ignore these -261 errors. One caveat, however, is using the RWDBCursor class. An RWDBCursor created for writing requires transaction support on Informix.

Otherwise, if you need to use transactions in your application, transaction logging must be enabled on your database.

For version 3.x, non ANSCII complient databases must be used with transaction logging enabled.

This article was:   Helpful | Not helpful
Report an issue
Article ID: 782
Last updated: 05 Feb, 2008
Revision: 1
Views: 8302
Posted: 22 Jul, 1997 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category