Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)FrançaisItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for JDBC Drivers Reference February 2026

Managing connections and updates

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for JDBC Drivers Reference
  • Troubleshooting
    • Troubleshooting your application
      • Turning on and off DataDirect Spy logging
      • DataDirect Spy Log Example
    • Troubleshooting connection pooling
      • Enabling tracing with the setTracing method
      • Pool Manager Trace File Example
    • Troubleshooting statement pooling
      • Generating an export file with the exportStatement method
      • Statement pool export file example
    • Troubleshooting Out-of-Memory Errors
    • Using Java logging
      • Logging components
        • JDBC API logger
        • SQL engine logger
        • Web service adapter logger
      • Configuring logging
        • Using the JVM
        • Using the driver
    • Enabling Debug Record Mode
      • Diagnostic recording in the Autonomous REST Composer
    • Contacting Technical Support
  • Failover
    • Connection failover
    • Extended connection failover
    • Select connection failover
    • Guidelines for primary and alternate servers
    • Using client load balancing
    • Using connection retry
  • Client information
    • How databases store client information
      • Storing client information
    • Returning client Information
    • Returning metadata about client information locations
  • JDBC support
    • Array
    • Blob
    • CallableStatement
    • Clob
    • Connection
    • ConnectionEventListener
    • ConnectionPoolDataSource
    • DatabaseMetaData
    • DataSource
    • Driver
    • ParameterMetaData
    • PooledConnection
    • PreparedStatement
    • Ref
    • ResultSet
    • ResultSetMetaData
    • RowSet
    • SavePoint
    • Statement
    • StatementEventListener
    • Struct
    • XAConnection
    • XADataSource
    • XAResource
  • JDBC extensions
    • Using JDBC wrapper methods to access JDBC extensions
    • DatabaseMetaData interface
    • DDBulkLoad interface
    • ExtConnection interface
    • ExtDatabaseMetaData interface
    • ExtLogControl class
  • SQL escape sequences for JDBC
    • Date, time, and timestamp escape sequences
    • Scalar functions
      • String functions
      • Numeric functions
      • Date and time Functions
      • System functions
    • Outer join escape sequences
    • LIKE escape character sequence for wildcards
    • Native and refresh escape sequences
    • Procedure call escape sequences
  • Designing JDBC applications for performance optimization
    • Using database metadata methods
      • Minimizing the use of database metadata methods
      • Avoiding search patterns
      • Using a dummy query to determine table characteristics
    • Returning data
      • Returning long data
      • Reducing the size of returned data
      • Choosing the right data type
      • Retrieving result sets
    • Selecting JDBC objects and methods
      • Using parameter markers as arguments to stored procedures
      • Using the statement object instead of the PreparedStatement object
      • Using batches instead of prepared statements
      • Choosing the right cursor
      • Using get methods effectively
      • Retrieving auto-generated keys
    • Managing connections and updates
      • Managing connections
      • Managing commits in transactions
      • Choosing the right transaction model
      • Using updateXXX methods
      • Using getBestRowIdentifier
  • Security best practices for JDBC applications
    • Use the latest version of the product
    • Verify the software integrity
    • Secure connection property settings
    • Set file system permissions
    • Encrypt transferred data
    • Use secure authentication methods
    • Use supported security features
    • Protect against SQL injection attacks
    • Use HTTP proxies
    • Secure log files
  • DataDirect tools
    • DataDirect Test
      • DataDirect Test tutorial
        • Configuring DataDirect Test
        • Starting DataDirect Test
        • Connecting using DataDirect Test
          • Connecting using a data source
          • Connecting using database selection
        • Executing a simple Select statement
        • Executing a prepared statement
        • Retrieving database metadata
        • Scrolling through a result set
        • Batch execution on a prepared statement
        • Returning parameter metadata
        • Establishing savepoints
        • Updatable result sets
          • Deleting a row
          • Inserting a row
          • Updating a row
        • Retrieving large object (LOB) data
    • Connection Pool Manager
      • How connection pooling works
        • The connection pool environment
        • The DataDirect Connection Pool Manager
        • Using a connection pool DataSource object
        • Using Reauthentication
      • Implementing DataDirect connection pooling
        • Creating a driver DataSource object
        • Creating the connection pool
      • Configuring the connection pool
        • Configuring the maximum pool size
        • Using Reauthentication with the Pool Manager
      • Connecting using a connection pool
      • Closing the connection pool
      • Checking the Pool Manager version
      • Enabling Pool Manager tracing
      • Connection Pool Manager interfaces
        • PooledConnectionDataSourceFactory
        • PooledConnectionDataSource
        • ConnectionPoolMonitor
    • Statement Pool Monitor
      • Using DataDirect-specific methods to access the Statement Pool Monitor
        • Using the poolEntries method
        • Generating a list of statements in the statement pool
      • Using JMX to access the Statement Pool Monitor
      • Importing statements into a statement pool
      • Clearing all statements in a statement pool
      • Freezing and unfreezing the statement pool
      • Generating a statement pool export file
      • DataDirect Statement Pool Monitor interfaces and classes
        • ExtStatementPoolMonitor class
        • ExtStatementPoolMonitorMBean interface
    • Tracking JDBC calls with DataDirect Spy
      • Enabling DataDirect Spy
        • Using the JDBC DriverManager
        • Using JDBC data sources
        • DataDirect Spy attributes
  • Copyright
Table of Contents

Managing connections and updates

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: August 6, 2018
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Aha! 6.0
    • Amazon Redshift 6.0
    • Apache Cassandra 6.0
    • Apache Hive 6.0
    • Apache Spark SQL 6.0
    • Atlassian Jira 6.0
    • Autonomous REST Connector 6.0
    • Cloudera Impala 5.1
    • + 24
      • Denodo 6.0
      • GitHub 6.0
      • Google BigQuery 6.0
      • IBM Db2 5.1
      • IBM Informix 6.0
      • Microsoft Dynamics 365 6.0
      • Microsoft Sharepoint 6.0
      • Microsoft SQL Server 6.0
      • MongoDB 6.1
      • MongoDB 6.0
      • MySQL 5.1
      • Oracle Database 6.0
      • Oracle Eloqua 6.0
      • Oracle Sales Cloud 6.0
      • Oracle Service Cloud 5.1
      • PostgreSQL 6.0
      • Progress OpenEdge 5.1
      • Salesforce 6.0
      • SAP HANA 6.0
      • SAP S/4HANA 6.0
      • SAP Sybase 5.1
      • Snowflake 6.0
      • TeamCity 6.0
      • Documentation

The guidelines in this section will help you to manage connections and updates to improve system performance for your JDBC applications.

Contents
  • Managing connections
  • Managing commits in transactions
  • Choosing the right transaction model
  • Using updateXXX methods
  • Using getBestRowIdentifier
TitleResults for “How to create a CRG?”Also Available inAlert