Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ JDBC Driver GuideThe HCL OneDB™ JDBC Driver Programmer's Guide describes how to install, load, and use HCL OneDB™ JDBC Driver to connect to the HCL OneDB™ database from within a Java™ application.
Perform database operations
Hold cursors

Hold cursors

When transaction logging is used, HCL OneDB™ generally closes all cursors and releases all locks when a transaction ends. In a multiuser environment, this behavior is not always desirable.

HCL OneDB JDBC Driver had already implemented holdable cursor support with HCL OneDB extensions. HCL OneDB database servers (5.x, 7.x, SE, 8.x, 9.x, and 10.x, or later) 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.

HCL OneDB 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 HCL OneDB Guide to SQL: Syntax.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.