Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.0.x)/ Using JDBC or ODBC for DWS Secondary Development/ JDBC-Based Development/ JDBC Development Process
Updated on 2026-07-02 GMT+08:00
View PDF
Share

JDBC Development Process

Java Database Connectivity (JDBC) is a Java API for running SQL statements. It provides a unified access API for different relational databases, based on which applications process data. DWS supports JDBC 4.0 and requires JDK 1.6 or later for code compiling. It does not support JDBC-ODBC Bridge. The following figure shows the JDBC application development process.

Figure 1 JDBC-based application development process
Table 1 JDBC development process

Procedure

Description

Load the driver.

Download the JDBC driver and edit and load it in the program.

Connect to a database.

Connect to the database through the JDBC driver.

Execute SQL statements.

Applications operate database data by executing SQL statements.

Process the result set.

Different types of result sets have different application scenarios. Applications need to select the appropriate result set type as needed.

Close the connection.

Make sure to close the database connection after completing the required data operations.
Parent Topic: JDBC-Based Development