In FUJITSU Enterprise Postgres 12 SP1 allows an application using the Connection Manager to change the error information when attempting to execute SQL again on a connection that the Connection Manager has determined to be in error due to a database error.

The changed error information is included in the error presented in "Errors when an Application Connection Switch Occurs and Corresponding Actions" for each client driver in "Application Development Guide".

Incompatibilities may occur if the following conditions are met:

1) The application uses one of the following drivers. and

-libpq (C Library)

-ECPG (Embedded SQL in C)

2) You are using the Connection Manager. and

3) The database server to which the application in 1) was connected goes down. and

4) The Connection Manager notifies the application in 1) of an error when the database is down in 3). and

5) The application in 1) does not disconnect from the database server that is down, but executes SQL using the connection.

FUJITSU Enterprise Postgres 12, 13 or later

The error information returned depends on the actual database server error condition.

FUJITSU Enterprise Postgres 12 SP1

The following error information is returned:

• For libpq (C Library): CONNECTION_BAD (PQstatus () return value)

• For ECPG (Embedded SQL in C): 57P02 (SQLSTATE return value)

Consider that the above error may be returned during the SQL error determination process.

Also, if you encounter an error about switching application destinations as described in "Errors when an Application Connection Switch Occurs and Corresponding Actions" for each client driver in "Application Development Guide", you should explicitly disconnect and reconnect or rerun the application.