Help Center/ GaussDB/ M-Compatibility Developer Guide(Distributed)/ Application Development Guide/ Development Based on GaussDB JDBC
Updated on 2025-10-23 GMT+08:00
View PDF
Share

Development Based on GaussDB JDBC

Java Database Connectivity (JDBC) is a Java API for running SQL statements. JDBC provides a unified access API for different relational databases, based on which applications process data.

The M-compatible database can be developed based on GaussDB JDBC. For details, see "Application Development > Development Based on JDBC" in Developer Guide. Some functions of the M-compatible database are different from those of GaussDB. For details about the differences, see Restrictions on Connecting GaussDB JDBC to the M-compatible Database.

Restrictions on Connecting GaussDB JDBC to the M-compatible Database

  1. When the DriverManager.getConnection(String url, Properties info) method is used to create a database connection, the info parameter does not support the binaryTransfer, binaryTransferEnable, and binaryTransferDisable attributes.
  2. When the DriverManager.getConnection(String url, Properties info) method is used to create a database connection and the info parameter is set to mCompatible, some functions and behaviors are changed. The change is compatible with the MySQL JDBC 5.1 driver. For details, see "Application Development Guide > Development Based on JDBC > Development Procedure > Connecting to a Database" in Developer Guide.
  3. For details about other GaussDB features that are not supported, see GaussDB Features That Are Not Supported by the M-compatible Database.