Connection Reset
- Last Updated: August 5, 2021
- 1 minute read
- DataDirect Connectors
- ODBC
- PostgreSQL 8.0
- Documentation
Connection Reset
Attribute
ConnectionReset (CR)
Purpose
Determines whether the state of connections that are removed from the connection pool for reuse by the application is reset to the initial configuration of the connection.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the state of connections removed
from the connection pool for reuse by an application is reset to the initial configuration
of the connection. Resetting the state can negatively impact performance because additional
commands must be sent over the network to the server to reset the state of the
connection.
If set to 0 (Disabled), the state of connections is not
reset.
Notes
- This connection option can affect performance.
Default
0 (Disabled)