Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ Using JDBC or ODBC for GaussDB(DWS) Secondary Development/ Prerequisites
Updated on 2024-12-18 GMT+08:00
View PDF
Share

Prerequisites

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

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

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

Downloading Drivers

For details, see Downloading the JDBC or ODBC Driver.