Development Based on JDBC

Java Database Connectivity (JDBC) is a Java API for running SQL statements. It provides unified access interfaces 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

• Example: Common Operations

• Example: Retrying SQL Queries for Applications

• Example: Importing and Exporting Data Through Local Files

• Example 2: Migrating Data from a MY Database to openGauss

• JDBC Interface Reference