Using the AWS JDBC Driver for PostgreSQL, you can execute a direct query to your PostgreSQL database. The driver is configured to take advantage of clustered PostgreSQL database deployments and is also compatible with all PostgreSQL versions and deployments. It supports fast failover to Amazon Aurora, and offers Enhanced Failover Monitoring. It can also be used as an advanced JDBC wrapper to extend the functionality of an existing driver. It also provides a way to monitor the health of your database cluster.
The AWS JDBC Driver for PostgreSQL is based on the PostgreSQL JDBC Driver. It supports PostgreSQL compatibility, fast failover to Amazon Aurora, and Enhanced Failover Monitoring. It is also a drop-in replacement for the PostgreSQL JDBC driver. It can be accessed from the Maven central repository.
In order to get the most out of the AWS JDBC Driver for PostgreSQL, it is important to understand what it does. In addition to performing standard SQL query operations, the AWS JDBC Driver for PostgreSQL provides a number of advanced features. These include support for Enhanced Failover Monitoring, fast failover to Amazon Aurora, and direct query to PostgreSQL. The driver also provides a JDBC wrapper that allows applications to take advantage of the features of clustered databases.
The AWS JDBC Driver uses Java Service Provider (JSPS) mechanisms to communicate with PostgreSQL. This allows the driver to connect to the database without the need to bundle the driver in a jar. The driver supports a number of additional properties, which can be specified in the connection URL, the connection string, or the Properties object. The following table lists the properties.
The OCSP (Online Certificate Status Protocol) is a protocol that checks the validity of a certificate. The driver uses this to verify that the certificate is genuine and is not faked. In addition, it can be used to detect network problems. If a driver does not have an OCSP server, it may fail to open. However, the driver does support OCSP response cache servers.
The most basic properties include the account identifier, port, and password. For a standard database, the account identifier is a string, and is used to configure a database connection. The password is the user’s password, which is passed along with the account identifier when establishing a connection. The server can also use a server name, which is the name of the machine hosting the database. The default server name is ‘postgres’. The port is the default port for the server. If you do not specify a port, the driver will use the port that is configured for the machine hosting the database. This port is usually 5432, but may vary depending on the platform and configuration of the server.
The optional socket timeout property allows you to specify the time it takes to wait for a database connection. The value is in seconds, and should be used in conjunction with the cancel command property to prevent the driver from sending a keep-alive probe. A socket timeout is a good way to detect network problems, but it can also be used for brute force global query timeouts.