JDBC-Based Development

Java Database Connectivity (JDBC) is a Java API for executing SQL statements, providing a unified access interface for different relational databases, based on which applications process data. GaussDB(DWS) supports JDBC 4.0 and requires JDK 1.6 or later for code compiling. It does not support JDBC-ODBC Bridge.

• JDBC Package and Driver Class
  
• Development Process
  
• Loading a Driver
  
• Connecting to a Database
  
• Executing SQL Statements
  
• Processing Data in a Result Set
  
• Closing the Connection
  
• Example: Common Operations
  
• Example: Retrying SQL Queries for Applications
  
• Example: Importing and Exporting Data Through Local Files
  
• Example: Migrating Data from MySQL to GaussDB(DWS)
  
• Example: Processing the RoaringBitmap Result Set on Application Then Importing It to GaussDB(DWS)
  
• JDBC Interface Reference