Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ Application Development Guide/ Development Specifications
Updated on 2025-02-27 GMT+08:00
View PDF
Share

Development Specifications

If the connection pool mechanism is used during application development, comply with the following specifications:

  • If GUC parameters are set in the connection, run SET SESSION AUTHORIZATION DEFAULT;RESET ALL; to clear the connection status before you return the connection to the connection pool.
  • If a temporary table is used, delete the temporary table before you return the connection to the connection pool.

If you do not do so, the connection state in the connection pool will remain, which affects subsequent operations using the connection pool.

Table 1 describes the compatibility of application development drivers.
Table 1 Compatibility

Driver

Compatibility

JDBC, ODBC, libpq, and Psycopg

The drivers are compatible with the earlier database version. However, to use the new features added to the drivers and database, you must upgrade the database.

If the driver is used in a multi-thread environment:

The JDBC driver is not thread-safe and does not guarantee that the connection methods are synchronized. The caller synchronizes the calls to the driver.