When transaction logging is used, IBM Informix Dynamic Server generally closes all cursors and releases all locks when a transaction ends. In a multiuser environment, this behavior is not always desirable.
IBM Informix JDBC Driver had already implemented holdable cursor support by means of Informix extensions. Informix database servers (5.x, 7.x, SE, 8.x, 9.x, and 10.x) support adding keywords WITH HOLD in the declaration of the cursor. Such a cursor is referred to as a hold cursor and is not closed at the end of a transaction.
IBM Informix JDBC Driver, in compliance with the JDBC 3.0 specifications, adds methods to JDBC interfaces to support holdable cursors.
For more information about hold cursors, see the IBM Informix: Guide to SQL Syntax.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]