Development Based on JDBC

Java Database Connectivity (JDBC) is a Java API for running SQL statements. It provides unified access APIs for different relational databases, based on which applications process data. The openGauss library supports JDBC 4.0 and requires JDK 1.8 for code compiling. It does not support JDBC-ODBC bridge.

• JDBC Package, Driver Class, and Environment Class

• Development Process

• Loading the Driver

• Connecting to a Database

• Connecting to the Database (Using SSL)

• Running SQL Statements

• Processing Data in a Result Set

• Closing a Connection

• Log Management

• Example: Retrying SQL Queries for Applications

• Example: Importing and Exporting Data Through Local Files

• Example: Migrating Data from a MY Database to openGauss

• Example: Logic Replication Code

• Example: Parameters for Connecting to the Database in Different Scenarios

• JDBC API Reference