search

PEXPlugins / PermissionsEx

A powerful permissions plugin for Minecraft
https://permissionsex.stellardrift.ca
Apache License 2.0
479 stars 297 forks source link

fix(deps): update dependency org.postgresql:postgresql to v42.7.1 #3213

Open renovate[bot] opened 3 years ago

renovate[bot] commented 3 years ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
org.postgresql:postgresql (source) 42.2.19 -> 42.7.1 age adoption passing confidence

[!WARNING] Some dependencies could not be looked up. Check the Dependency Dashboard for more information.

Release Notes

pgjdbc/pgjdbc (org.postgresql:postgresql) ### [`v42.7.1`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4271-2023-12-06-083400--0500) ##### Changed - perf: improve performance of PreparedStatement.setBlob, BlobInputStream, and BlobOutputStream with dynamic buffer sizing [PR #​3044](https://togithub.com/pgjdbc/pgjdbc/pull/3044) ##### Fixed - fix: Apply connectTimeout before SSLSocket.startHandshake to avoid infinite wait in case the connection is broken [PR #​3040](https://togithub.com/pgjdbc/pgjdbc/pull/3040) - fix: support waffle-jna 2.x and 3.x by using reflective approach for ManagedSecBufferDesc [PR #​2720](https://togithub.com/pgjdbc/pgjdbc/pull/2720) Fixes [Issue #​2690](https://togithub.com/pgjdbc/pgjdbc/issues/2720). - fix: NoSuchMethodError on ByteBuffer#position When Running on Java 8 when accessing arrays, fixes [Issue #​3014](https://togithub.com/pgjdbc/pgjdbc/issues/3014) - Revert "[PR #​2925](https://togithub.com/pgjdbc/pgjdbc/pull/2925) Use canonical DateStyle name" [PR #​3035](https://togithub.com/pgjdbc/pgjdbc/pull/3035) Fixes [Issue #​3008](https://togithub.com/pgjdbc/pgjdbc/issues/3008) - Revert "[PR ##​2973](https://togithub.com/pgjdbc/pgjdbc/pull/2973) feat: support SET statements combining with other queries with semicolon in PreparedStatement" [PR #​3010](https://togithub.com/pgjdbc/pgjdbc/pull/3010) Fixes [Issue #​3007](https://togithub.com/pgjdbc/pgjdbc/issues/3007) - fix: avoid timezone conversions when sending LocalDateTime to the database [#​2852](https://togithub.com/pgjdbc/pgjdbc/pull/3010) Fixes [Issue #​1390](https://togithub.com/pgjdbc/pgjdbc/issues/1390) ,[Issue #​2850](https://togithub.com/pgjdbc/pgjdbc/issues/2850) Closes \[Issue [#​1391](https://togithub.com/pgjdbc/pgjdbc/issues/1391)([https://github.com/pgjdbc/pgjdbc/issues/1391](https://togithub.com/pgjdbc/pgjdbc/issues/1391)) ### [`v42.7.0`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4270-2023-11-20-093300--0500) ##### Changed - fix: Deprecate for removal PGPoint.setLocation(java.awt.Point) to cut dependency to `java.desktop` module. [PR #​2967](https://togithub.com/pgjdbc/pgjdbc/pull/2967) - feat: return all catalogs for getCatalogs metadata query closes [ISSUE #​2949](https://togithub.com/pgjdbc/pgjdbc/issues/2949) [PR #​2953](https://togithub.com/pgjdbc/pgjdbc/pull/2953) - feat: support SET statements combining with other queries with semicolon in PreparedStatement [PR ##​2973](https://togithub.com/pgjdbc/pgjdbc/pull/2973) ##### Fixed - chore: add styleCheck Gradle task to report style violations [PR #​2980](https://togithub.com/pgjdbc/pgjdbc/pull/2980) - fix: Include currentXid in "Error rolling back prepared transaction" exception message [PR #​2978](https://togithub.com/pgjdbc/pgjdbc/pull/2978) - fix: add varbit as a basic type inside the TypeInfoCache [PR #​2960](https://togithub.com/pgjdbc/pgjdbc/pull/2960) - fix: Fix failing tests for version 16. [PR #​2962](https://togithub.com/pgjdbc/pgjdbc/pull/2962) - fix: allow setting arrays with ANSI type name [PR #​2952](https://togithub.com/pgjdbc/pgjdbc/pull/2952) - feat: Use KeepAlive to confirm LSNs [PR #​2941](https://togithub.com/pgjdbc/pgjdbc/pull/2941) - fix: put double ' around log parameter [PR #​2936](https://togithub.com/pgjdbc/pgjdbc/pull/2936) fixes [ISSUE #​2935](https://togithub.com/pgjdbc/pgjdbc/issues/2935) - fix: Fix Issue [#​2928](https://togithub.com/pgjdbc/pgjdbc/issues/2928) number of ports not equal to number of servers in datasource [PR #​2929](https://togithub.com/pgjdbc/pgjdbc/pull/2929) - fix: Use canonical DateStyle name ([#​2925](https://togithub.com/pgjdbc/pgjdbc/issues/2925)) fixes [pgbouncer issue](https://togithub.com/pgbouncer/pgbouncer/issues/776) - fix: Method getFastLong should be able to parse all longs [PR #​2881](https://togithub.com/pgjdbc/pgjdbc/pull/2881) - docs: Fix typos in info.html [PR #​2860](https://togithub.com/pgjdbc/pgjdbc/pull/2860) - fix: Return correct default from PgDatabaseMetaData.getDefaultTransactionIsolation [PR #​2992](https://togithub.com/pgjdbc/pgjdbc/pull/2992) fixes [Issue #​2991](https://togithub.com/pgjdbc/pgjdbc/issues/2991) - test: fix assertion in RefCursorFetchTestultFetchSize rows - test: use try-with-resources in LogicalReplicationStatusTest ### [`v42.6.0`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4260-2023-03-17-153434--0400) ##### Changed fix: use PhantomReferences instead of `Obejct.finalize()` to track Connection leaks [PR #​2847](https://togithub.com/pgjdbc/pgjdbc/pull/2847) The change replaces all uses of Object.finalize with PhantomReferences. The leaked resources (Connections) are tracked in a helper thread that is active as long as there are connections in use. By default, the thread keeps running for 30 seconds after all the connections are released. The timeout is set with pgjdbc.config.cleanup.thread.ttl system property. refactor:(loom) replace the usages of synchronized with ReentrantLock [PR #​2635](https://togithub.com/pgjdbc/pgjdbc/pull/2635) Fixes [Issue #​1951](https://togithub.com/pgjdbc/pgjdbc/issues/1951) ### [`v42.5.4`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4254-2023-02-15-102104--0500) ##### Fixed fix: fix testGetSQLTypeQueryCache by searching for xid type. We used to search for box type but it is now cached. xid is not cached, this nuance is required for the test. fix OidValueCorrectnessTest BOX_ARRAY OID, by adding BOX_ARRAY to the oidTypeName map \[PR [#​2810](https://togithub.com/pgjdbc/pgjdbc/issues/2810)]\([https://github.com/pgjdbc/pgjdbc/pull/2810](https://togithub.com/pgjdbc/pgjdbc/pull/2810)0). fixes [Issue #​2804](https://togithub.com/pgjdbc/pgjdbc/issues/2804). fix: Make sure that github CI runs tests on all(https://togithub.com/pgjdbc/pgjdbc/pull/2809)dbc/pgjdbc/pull/2809\)). ### [`v42.5.3`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4253-2023-02-03-082450--0500) ##### Fixed fix: Add box to TypeInfoCache, fixes [Issue #​2746](https://togithub.com/pgjdbc/pgjdbc/issues/2746) [PR #​2747](https://togithub.com/pgjdbc/pgjdbc/pull/2747) fix: regression in PgResultSet LONG_MIN copy and paste error fixes [Issue #​2748](https://togithub.com/pgjdbc/pgjdbc/issues/2748) [PR#2749](https://togithub.com/pgjdbc/pgjdbc/pull/2749) ### [`v42.5.2`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4252-2023-01-31-143046--0500) ##### Changed regression: This release has 2 known regressions which make it unusable see the notes above. We advise people to use 42.5.3 instead. docs: specify that timeouts are in seconds and there is a maximum. Housekeeping on some tests fixes [#Issue 2671](https://togithub.com/pgjdbc/pgjdbc/issues/2671) [PR #​2686](https://togithub.com/pgjdbc/pgjdbc/pull/2686) docs: clarify binaryTransfer and add it to README [PR# 2698](https://togithub.com/pgjdbc/pgjdbc/pull/2698) docs: Document the need to encode reserved characters in the connection URL [PR #​2700](https://togithub.com/pgjdbc/pgjdbc/pull/2700) feat: Define binary transfer for custom types dynamically/automatically fixes [Issue #​2554](https://togithub.com/pgjdbc/pgjdbc/issues/2554) [PR #​2556](https://togithub.com/pgjdbc/pgjdbc/pull/2556) ##### Added fix: added gssResponseTimeout as part of [PR #​2687](https://togithub.com/pgjdbc/pgjdbc/pull/2687) to make sure we don't wait forever on a GSS RESPONSE ##### Fixed fix: Ensure case of XML tags in Maven snippet is correct [PR #​2682](https://togithub.com/pgjdbc/pgjdbc/pull/2682) fix: Make sure socket is closed if an exception is thrown in createSocket fixes [Issue #​2684](https://togithub.com/pgjdbc/pgjdbc/issues/2684) [PR #​2685](https://togithub.com/pgjdbc/pgjdbc/pull/2685) fix: Apply patch from [Issue #​2683](https://togithub.com/pgjdbc/pgjdbc/issues/2683) to fix hanging ssl connections [PR #​2687](https://togithub.com/pgjdbc/pgjdbc/pull/2687) fix - binary conversion of (very) long numeric values (longer than 4 \* 2^15 digits) [PR #​2697](https://togithub.com/pgjdbc/pgjdbc/pull/2697) fixes [Issue #​2695](https://togithub.com/pgjdbc/pgjdbc/issues/2695) minor: enhance readability connection of startup params [PR #​2705](https://togithub.com/pgjdbc/pgjdbc/pull/2785) ### [`v42.5.1`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4251-2022-11-23-101459--0500) ##### Security - security: StreamWrapper spills to disk if setText, or setBytea sends very large Strings or arrays to the server. createTempFile creates a file which can be read by other users on unix like systems (Not macos). This has been fixed in this version fixes CVE-2022-41946 see the [security advisory](https://togithub.com/pgjdbc/pgjdbc/security/advisories/GHSA-562r-vg33-8x8h) for more details. Reported by [Jonathan Leitschuh](https://togithub.com/JLLeitschuh) This has been fixed in versions 42.5.1, 42.4.3 42.3.8, 42.2.27.jre7. Note there is no fix for 42.2.26.jre6. See the security advisory for work arounds. ##### Fixed - fix: make sure we select array_in from pg_catalog to avoid duplicate array_in functions fixes [#Issue 2548](https://togithub.com/pgjdbc/pgjdbc/issues/2548) [PR #​2552](https://togithub.com/pgjdbc/pgjdbc/issues/2552) - fix: binary decoding of bool values [PR #​2640](https://togithub.com/pgjdbc/pgjdbc/pull/2640) - perf: improve performance of PgResultSet getByte/getShort/getInt/getLong for float-typed columns [PR #​2634](https://togithub.com/pgjdbc/pgjdbc/pull/2634) - chore: fix various spelling errors [PR #​2592](https://togithub.com/pgjdbc/pgjdbc/pull/2592) - chore: Feature/urlparser improve URLParser [PR #​2641](https://togithub.com/pgjdbc/pgjdbc/pull/2592) ### [`v42.5.0`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4250-2022-08-23-112011--0400) ##### Changed - fix: revert change in [PR #​1986](https://togithub.com/pgjdbc/pgjdbc/pull/1986) where float was aliased to float4 from float8. float now aliases to float8 [PR #​2598](https://togithub.com/pgjdbc/pgjdbc/pull/2598) fixes [Issue #​2597](https://togithub.com/pgjdbc/pgjdbc/issues/2597) ### [`v42.4.2`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4242-2022-08-17-103340--0400) ##### Changed - fix: add alias to the generated getUDT() query for clarity (PR [#​2553](https://togithub.com/pgjdbc/pgjdbc/issues/2553))\[https://github.com/pgjdbc/pgjdbc/pull/2553](https://togithub.com/pgjdbc/pgjdbc/pull/2553)3] ##### Added - fix: make setObject accept UUID array [PR #​2587](https://togithub.com/pgjdbc/pgjdbc/pull/2587) ##### Fixed - fix: regression with GSS. Changes introduced to support building with Java 17 caused failures [Issue #​2588](https://togithub.com/pgjdbc/pgjdbc/issues/2588) - fix: set a timeout to get the return from requesting SSL upgrade. [PR #​2572](https://togithub.com/pgjdbc/pgjdbc/pull/2572) - feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads) ### [`v42.4.1`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4241-2022-08-01-162420--0400) ##### Security - fix: CVE-2022-31197 Fixes SQL generated in PgResultSet.refresh() to escape column identifiers so as to prevent SQL injection. - Previously, the column names for both key and data columns in the table were copied as-is into the generated SQL. This allowed a malicious table with column names that include statement terminator to be parsed and executed as multiple separate commands. - Also adds a new test class ResultSetRefreshTest to verify this change. - Reported by [Sho Kato](https://togithub.com/kato-sho) ##### Changed - chore: skip publishing pgjdbc-osgi-test to Central - chore: bump Gradle to 7.5 - test: update JUnit to 5.8.2 ##### Added - chore: added Gradle Wrapper Validation for verifying gradle-wrapper.jar - chore: added "permissions: contents: read" for GitHub Actions to avoid unintentional modifications by the CI - chore: support building pgjdbc with Java 17 - feat: synchronize statement executions (e.g. avoid deadlock when Connection.isValid is executed from concurrent threads) ### [`v42.4.0`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4240-2022-06-09-081402--0400) ##### Changed - fix: added GROUP_STARTUP_PARAMETERS boolean property to determine whether or not to group startup parameters in a transaction (default=false like 42.2.x) fixes [Issue #​2425](https://togithub.com/pgjdbc/pgjdbc/issues/2497) pgbouncer cannot deal with transactions in statement pooling mode [PR #​2425](https://togithub.com/pgjdbc/pgjdbc/pull/2425) ##### Fixed - fix: queries with up to 65535 (inclusive) parameters are supported now (previous limit was 32767) [PR #​2525](https://togithub.com/pgjdbc/pgjdbc/pull/2525), [Issue #​1311](https://togithub.com/pgjdbc/pgjdbc/issues/1311) - fix: workaround JarIndex parsing issue by using groupId/artifactId-version directory namings. Regression since 42.2.13. [PR #​2531](https://togithub.com/pgjdbc/pgjdbc/pull/2531), [issue #​2527](https://togithub.com/pgjdbc/pgjdbc/issues/2527) - fix: use Locale.ROOT for toUpperCase() toLowerCase() calls - doc: add Vladimir Sitnikov's PGP key - fix: return correct base type for domain from getUDTs [PR #​2520](https://togithub.com/pgjdbc/pgjdbc/pull/2520) [Issue #​2522](https://togithub.com/pgjdbc/pgjdbc/issues/2522) - perf: utcTz static and renamed to UTC_TIMEZONE [PR #​2519](https://togithub.com/pgjdbc/pgjdbc/pull/2520) - doc: fix release version for [#​2377](https://togithub.com/pgjdbc/pgjdbc/issues/2377) (it should be 42.3.6, not 42.3.5) ### [`v42.3.6`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4236-2022-05-24-085227--0400) ##### Changed ##### Added ##### Fixed - fix: close refcursors when underlying cursor==null instead of relying on defaultRowFetchSize [PR #​2377](https://togithub.com/pgjdbc/pgjdbc/pull/2377) ### [`v42.3.5`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4235-2022-05-04-084835--0400) ##### Changed - test: polish TimestampUtilsTest - chore: use GitHub Action concurrency feature to terminate CI jobs on fast PR pushes ##### Added - Added KEYS file to allow for verifying artifacts [PR 2499](https://togithub.com/pgjdbc/pgjdbc/pull/2499) ##### Fixed - perf: enable tcpNoDelay by default [PR 2495](https://togithub.com/pgjdbc/pgjdbc/pull/2495). This is a regression from 42.2.x versions where tcpNoDelay defaulted to true - docs: fix readme.md after [PR 2495](https://togithub.com/pgjdbc/pgjdbc/pull/2495) [PR 2496](https://togithub.com/pgjdbc/pgjdbc/pull/249) - feat: targetServerType=preferPrimary connection parameter [PR 2483](https://togithub.com/pgjdbc/pgjdbc/pull/2483) - fix: revert removal of toOffsetDateTime(String timestamp) fixes [Issue #​2497](https://togithub.com/pgjdbc/pgjdbc/issues/2497) [PR 2501](https://togithub.com/pgjdbc/pgjdbc/pull/2501) ### [`v42.3.4`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4234-2022-04-01-141628--0400) ##### Changed - fix: change name of build cache [PR 2471](https://togithub.com/pgjdbc/pgjdbc/pull/2471) - feat: add support for ResultSet#getObject(OffsetTime.class) and PreparedStatement#setObject(OffsetTime.class) [PR 2467](https://togithub.com/pgjdbc/pgjdbc/pull/2467) - fix: Use non-synchronized getTimeZone in TimestampUtils [PR 2451](https://togithub.com/pgjdbc/pgjdbc/pull/2451) - docs: Fix CHANGELOG.md misformatted markdown headings [PR 2461](https://togithub.com/pgjdbc/pgjdbc/pull/2461) - docs: remove loggerLevel and loggerFile from docs and issues [PR 2489](https://togithub.com/pgjdbc/pgjdbc/pull/2489) - feat: use direct wire format -> LocalDate conversion without resorting to java.util.Date, java.util.Calendar, and default timezones [PR 2464](https://togithub.com/pgjdbc/pgjdbc/pull/2464) fixes Issue [#​2221](https://togithub.com/pgjdbc/pgjdbc/issues/2221) ##### Added ##### Fixed - docs: Update testing documentation [PR 2446](https://togithub.com/pgjdbc/pgjdbc/pull/2446) - fix: Throw an exception if the driver cannot parse the URL instead of returning NULL fixes [Issue #​2421](https://togithub.com/pgjdbc/pgjdbc/issues/2421) [PR 2441](https://togithub.com/pgjdbc/pgjdbc/pull/2441) - fix: Use PGProperty instead of the property names directly [PR 2444](https://togithub.com/pgjdbc/pgjdbc/pull/2444) - docs: update changelog, missing links at bottom and formatting [PR 2460](https://togithub.com/pgjdbc/pgjdbc/pull/2460) - fix: Remove isDeprecated from PGProperty. It was originally intended to help produce automated docs. Fixes Issue [#​2479](https://togithub.com/pgjdbc/pgjdbc/issues/2479) [PR 2480](https://togithub.com/pgjdbc/pgjdbc/pull/2480) - fix: change PGInterval parseISO8601Format to support fractional second [PR 2457](https://togithub.com/pgjdbc/pgjdbc/pull/2457) - fix: GSS login to use TGT from keytab fixes Issue [#​2469](https://togithub.com/pgjdbc/pgjdbc/issues/2469) [PR 2470](https://togithub.com/pgjdbc/pgjdbc/pull/2470) - fix: More test and fix for issues discovered by [PR #​2476](https://togithub.com/pgjdbc/pgjdbc/pull/2476) [PR #​2488](https://togithub.com/pgjdbc/pgjdbc/pull/2488) ### [`v42.3.3`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4233-2022-02-15-113224--0500) ##### Changed - fix: Removed loggerFile and loggerLevel configuration. While the properties still exist. They can no longer be used to configure the driver logging. Instead use java.util.logging configuration mechanisms such as `logging.properties`. ##### Added ##### Fixed ### [`v42.3.2`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4232-2022-02-01-073541--0500) ##### Security - CVE-2022-21724 pgjdbc instantiates plugin instances based on class names provided via authenticationPluginClassName, sslhostnameverifier, socketFactory, sslfactory, sslpasswordcallback connection properties. However, the driver did not verify if the class implements the expected interface before instantiating the class. This would allow a malicious class to be instantiated that could execute arbitrary code from the JVM. Fixed in [commit](https://togithub.com/pgjdbc/pgjdbc/commit/f4d0ed69c0b3aae8531d83d6af4c57f22312c813) ##### Changed - perf: read in_hot_standby GUC on connection [PR #​2334](https://togithub.com/pgjdbc/pgjdbc/pull/2334) - test: materialized view privileges [PR #​2209](https://togithub.com/pgjdbc/pgjdbc/pull/2209) fixes [Issue #​2060](https://togithub.com/pgjdbc/pgjdbc/issues/2060) - docs: add info about convenience maven project [PR #​2407](https://togithub.com/pgjdbc/pgjdbc/pull/2407) - docs: Document timezone reversal from POSIX to ISO [PR #​2413](https://togithub.com/pgjdbc/pgjdbc/pull/2413) - fix: we will ask the server if it supports GSS Encryption if gssEncryption is prefer or require [PR #​2396](https://togithub.com/pgjdbc/pgjdbc/pull/2396) remove the need to have a ticket in the cache before asking the server if gss encryptions are supported - docs: remove Java 6 and 7 references from contributing [PR #​2385](https://togithub.com/pgjdbc/pgjdbc/pull/2385) - style: remove Java 8 / JDBC 4.2 checks [PR #​2383](https://togithub.com/pgjdbc/pgjdbc/pull/2383) Remove all remaining checks whether the source is lower than Java 8 or JDBC 4.2. - fix: throw SQLException for #getBoolean BIT(>1) [PR #​2386](https://togithub.com/pgjdbc/pgjdbc/pull/2386) Throw SQLException instead of ClassCastException when calling CallableStatement#getBoolean(int) on BIT(>1). - style: import java.time types in more classes [PR #​2382](https://togithub.com/pgjdbc/pgjdbc/pull/2382) Use imports for java.time types in all remaining classes. - style: import java.time types in TimestampUtils [PR #​2380](https://togithub.com/pgjdbc/pgjdbc/pull/2380) Use imports for java.time types in TimestampUtils. - refactor: Change internal constructors to pass only connection Properties Changes internal constructors for PgConnection and related classes to only accept the connection properties object and remove the user and password arguments. Any locations that required those fields can retrieve them from the properties map. - test: Fix DatabaseMetadataTest to perform mview tests only on 9.3+ - perf: read in_hot_standby GUC on connection [PR #​2334](https://togithub.com/pgjdbc/pgjdbc/pull/2334) - doc: improv doc around binary decoding of numeric data [#​2331](https://togithub.com/pgjdbc/pgjdbc/pull/2331) - Add cert key type checking to chooseClientAlias [PR #​2417](https://togithub.com/pgjdbc/pgjdbc/pull/2417) ##### Added - feat: Add authenticationPluginClassName option to provide passwords at runtime Adds authenticationPluginClassName connection property that allows end users to specify a class that will provide the connection passwords at runtime. Users implementing that interface must ensure that each invocation of the method provides a new char\[] array as the contents will be filled with zeroes by the driver after use.Call sites within the driver have been updated to use the char\[] directly wherever possible. This includes direct usage in the GSS authentication code paths that internally were already converting the String password into a char\[] for internal usage. This allows configuring a connection with a password that must be generated on the fly or periodically changes. [PR #​2369](https://togithub.com/pgjdbc/pgjdbc/pull/2369) original issue [Issue #​2102](https://togithub.com/pgjdbc/pgjdbc/issues/2102) - feat: add tcpNoDelay option [PR #​2341](https://togithub.com/pgjdbc/pgjdbc/pull/2341) fixes [Issue #​2324](https://togithub.com/pgjdbc/pgjdbc/issues/2324) - feat: pg_service.conf and .pgpass support (jdbc:postgresql://?service=my-service) [PR #​2260](https://togithub.com/pgjdbc/pgjdbc/pull/2260) fixes [Issue #​2278](https://togithub.com/pgjdbc/pgjdbc/issues/2278) ##### Fixed - Use local TimestampUtil in PgStatement and PgResultset for thread safety [PR #​2291](https://togithub.com/pgjdbc/pgjdbc/pull/2291) fixes [Issue #​921](https://togithub.com/pgjdbc/pgjdbc/issues/921) synchronize modification of shared calendar - fix: PgObject isNull() was reporting the opposite fixes [Issue #​2411](https://togithub.com/pgjdbc/pgjdbc/issues/2411) [PR #​2414](https://togithub.com/pgjdbc/pgjdbc/pull/2414) - fix: default file name is ".pg_service.conf" on Windows (not "pg_service.conf") [PR #​2398](https://togithub.com/pgjdbc/pgjdbc/pull/2398) fixes [Issue #​2278](https://togithub.com/pgjdbc/pgjdbc/issues/2278) - test: Fix RefCursorFetchTest on older platforms - fix: do not close refcursor after reading if fetchsize has been set fixes [Issue #​2227](https://togithub.com/pgjdbc/pgjdbc/issues/2227) [PR #​2371](https://togithub.com/pgjdbc/pgjdbc/pull/2371) - fix: rework gss authentication to use the principal name to get the credentials fixes [Issue #​2235](https://togithub.com/pgjdbc/pgjdbc/issues/2235) [PR #​2352](https://togithub.com/pgjdbc/pgjdbc/pull/2352) - fix: return getIndexInfo metadata columns in UPPER CASE [PR #​2368](https://togithub.com/pgjdbc/pgjdbc/pull/2368) - fix: Connection leak in ConnectionFactoryImpl#tryConnect [PR #​2350](https://togithub.com/pgjdbc/pgjdbc/pull/2350) [Issue #​2351](https://togithub.com/pgjdbc/pgjdbc/issues/2351) - fix: Fix For IS_AUTOGENERATED Flag [PR #​2348](https://togithub.com/pgjdbc/pgjdbc/pull/2348) - fix: parsing service file tests for windows [PR #​2347](https://togithub.com/pgjdbc/pgjdbc/pull/2347) - fix: The spec says that calling close() on a closed connection is a noop. [PR #​2345](https://togithub.com/pgjdbc/pgjdbc/pull/2345) fixes [Issue #​2300](https://togithub.com/pgjdbc/pgjdbc/issues/2300) - fix: add microsecond precision to getTimestamp() called on sql TIME(6) Currently, "when fetching a value of type TIME(6) through resultSet.getTimestamp() only ms precision is retained, the microsecond fractional digits are lost." This change will retain the microsecond precision when .getTimestamp() is called on TIME(6). [PR #​2181](https://togithub.com/pgjdbc/pgjdbc/pull/2181) Closes [Issue #​1537](https://togithub.com/pgjdbc/pgjdbc/issues/1537) - test: materialized view privileges [PR #​2209](https://togithub.com/pgjdbc/pgjdbc/pull/2209) add and drop a materialized view Add to TestUtil and also to DatabaseMetaData setup and teardown fixes [Issue #​2060](https://togithub.com/pgjdbc/pgjdbc/issues/2060) - fix: typo in connect.md [PR #​2338](https://togithub.com/pgjdbc/pgjdbc/pull/2238) `OutOfMemoryException` => `OutOfMemoryError` - fix: use local TimestampUtil in PgStatement and PgResultset for thread safety TimestampUtil is not thread safe. It raises exceptions when multiple threads use ResultSets of one connection. [PR #​2291](https://togithub.com/pgjdbc/pgjdbc/pull/2291) fixes [Issue #​921](https://togithub.com/pgjdbc/pgjdbc/issues/921) If PgStatement and PgResultSet use their own TimestampUtil no synchronize is needed. - fix: typo in CONTRIBUTING.md [PR #​2332](https://togithub.com/pgjdbc/pgjdbc/pull/2332) seccion => section ### [`v42.3.1`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4231-2021-10-29) ##### Changed - improv: Arrays in Object\[] [PR 2330](https://togithub.com/pgjdbc/pgjdbc/pull/2330) when an Object\[] contains other arrays, treat as though it were a multi-dimensional array the one exception is byte\[], which is not supported. - improv: Use jre utf-8 decoding [PR 2317](https://togithub.com/pgjdbc/pgjdbc/pull/2317) Remove use of custom utf-8 decoding. - perf: improve performance of bytea string decoding [PR 2320](https://togithub.com/pgjdbc/pgjdbc/pull/2320) improve the parsing of bytea hex encoded string by making a lookup table for each of the valid ascii code points to the 4 bit numeric value - feat: intern/canonicalize common strings [PR 2234](https://togithub.com/pgjdbc/pgjdbc/pull/2234) ##### Added ##### Fixed - numeric binary decode for even 10 thousands [PR #​2327](https://togithub.com/pgjdbc/pgjdbc/pull/2327) fixes [Issue 2326](https://togithub.com/pgjdbc/pgjdbc/issues/2326) binary numeric values which represented integers multiples of 10,000 from 10,000-9,990,000 were not decoded correctly - \[typo] typo in certdir/README.md [PR #​2309](https://togithub.com/pgjdbc/pgjdbc/pull/2309) certificatess => certificates - \[typo] typo in TimestampUtils.java [PR #​2314](https://togithub.com/pgjdbc/pgjdbc/pull/2314) Change `Greagorian` to `Gregorian`. - remove check for negative pid in cancel request. Apparently pgbouncer can send one fixes [Issue 2317](https://togithub.com/pgjdbc/pgjdbc/issues/2317) [PR #​2319](https://togithub.com/pgjdbc/pgjdbc/pull/2319) ### [`v42.3.0`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#4230-2021-10-18) ##### Changed - No longer build for Java 6 or Java 7 - If assumeMinServerVersion is not defined and server is at least 9.0, group startup statements into a single transaction PR [#​1977](https://togithub.com/pgjdbc/pgjdbc/pull/1977) ##### Added - Support for pg_service.conf file and jdbc URL syntax: "jdbc:postgresql://?service=service1". Resource can be provided using 1) property "-Dorg.postgresql.pgservicefile=file1" 2) environment variable PGSERVICEFILE=file2 3) default location "$HOME/.pg_service.conf" 4) environment variable PGSYSCONFDIR=dir1 looks for file "dir1/pg_service.conf". - Support for .pgpass file. Resource can be provided using 1) property "-Dorg.postgresql.pgpassfile=file1" 2) environment variable PGPASSFILE=file2 3) default location "$HOME/.pgpass" ##### Fixed - Rework OSGi bundle activator so it does not rely on exception message to check DataSourceFactory presence PR [#​507](https://togithub.com/pgjdbc/pgjdbc/pull/507) - Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified [PR #​2174](https://togithub.com/pgjdbc/pgjdbc/pull/2174) - Fix refreshRow made the row readOnly. \[PR [#​2195](https://togithub.com/pgjdbc/pgjdbc/issues/2195)]\[https://github.com/pgjdbc/pgjdbc/pull/2195](https://togithub.com/pgjdbc/pgjdbc/pull/2195)5 Fixes [Issue #​2193](https://togithub.com/pgjdbc/pgjdbc/issues/2193) - Fix do not add double quotes to identifiers already double quoted [PR #​2224](https://togithub.com/pgjdbc/pgjdbc/pull/2224) Fixes [Issue #​2223](https://togithub.com/pgjdbc/pgjdbc/issues/2223) Add a property `QUOTE_RETURNING_IDENTIFIERS` which determines if we put double quotes around identifiers that are provided in the returning array. - Fix Provide useful error message for empty or missing passwords for SCRAM auth [PR #​2290](https://togithub.com/pgjdbc/pgjdbc/pull/2290) fixes [Issue #​2288](https://togithub.com/pgjdbc/pgjdbc/issues/2288) ### [`v42.2.24`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#42224-2021-09-23) ##### Fixed - Fix startup regressions caused by [PR #​1949](https://togithub.com/pgjdbc/pgjdbc/pull/1949). Instead of checking all types by OID, we can return types for well known types [PR #​2257](https://togithub.com/pgjdbc/pgjdbc/pull/2257) - Backport [PR #​2148](https://togithub.com/pgjdbc/pgjdbc/pull/2148) Avoid leaking server error details through BatchUpdateException when logServerErrorDetail [PR #​2254](https://togithub.com/pgjdbc/pgjdbc/pull/2254) - Backpatch [PR #​2247](https://togithub.com/pgjdbc/pgjdbc/pull/2247) QueryExecutorImpl.receiveFastpathResult did not properly handle ParameterStatus messages. This in turn caused failures for some LargeObjectManager operations. Closes [Issue #​2237](https://togithub.com/pgjdbc/pgjdbc/issues/2237) Fixed by adding the missing code path, based on the existing handling in processResults. [PR #​2253](https://togithub.com/pgjdbc/pgjdbc/pull/2253) - Backpatch [PR #​2242](https://togithub.com/pgjdbc/pgjdbc/pull/2242) PgDatabaseMetaData.getIndexInfo() cast operands to smallint [PR#2253](https://togithub.com/pgjdbc/pgjdbc/pull/2253) It is possible to break method PgDatabaseMetaData.getIndexInfo() by adding certain custom operators. This PR fixes it. - Backpatching [PR #​2251](https://togithub.com/pgjdbc/pgjdbc/pull/2251) into 42.2 Clean up open connections to fix test failures on omni and appveyor use older syntax for COMMENT ON FUNCTION with explicit no-arg parameter parentheses as it is required on server versions before v10. Handle cleanup of connection creation in StatementTest, handle cleanup of privileged connection in DatabaseMetaDataTest - Backpatch [PR #​2245](https://togithub.com/pgjdbc/pgjdbc/pull/2245) fixes case where duplicate tables are returned if there are duplicate descriptions oids are not guaranteed to be unique in the catalog [PR #​2248](https://togithub.com/pgjdbc/pgjdbc/pull/2248) - Change to updatable result set to use correctly primary or unique keys [PR #​2228](https://togithub.com/pgjdbc/pgjdbc/pull/2228) fixes issues introduced in [PR #​2199](https://togithub.com/pgjdbc/pgjdbc/pull/2199) closes [Issue #​2196](https://togithub.com/pgjdbc/pgjdbc/issues/2196) - Fix NPE calling getTypeInfo when alias is null [PR #​2220](https://togithub.com/pgjdbc/pgjdbc/pull/2220) - Backpatch [PR #​2217](https://togithub.com/pgjdbc/pgjdbc/pull/2217) to fix [Issue #​2215](https://togithub.com/pgjdbc/pgjdbc/issues/2215). OIDs are unsigned integers and were not being handled correctly when they exceeded the size of signed integers ### [`v42.2.23`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#42223-2021-07-06) ##### Changed - Renewed the SSL keys for testing ##### Fixed - getColumnPrecision for Numeric when scale and precision not specified now returns 0 instead of 131089 fixes: Issue [#​2188](https://togithub.com/pgjdbc/pgjdbc/issues/2188) - Calling refreshRow on an updateable resultset made the row readOnly. Fixes Issue [#​2193](https://togithub.com/pgjdbc/pgjdbc/issues/2193) - results should be updateable if there is a unique index available [PR#2199](https://togithub.com/PR/pgjdbc/issues/2199) Fixes Issue [#​2196](https://togithub.com/pgjdbc/pgjdbc/issues/2196) - Rework sql type gathering to use OID instead of typname. This does not have the issue of name shadowing / qual-names, and has the added benefit of fixing [#​1948](https://togithub.com/pgjdbc/pgjdbc/issues/1948). ### [`v42.2.22`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#42222-2021-06-16) ##### Fixed - Regression caused by https://github.com/pgjdbc/pgjdbc/commit/4fa2d5bc1ed8c0086a3a197fc1c28f7173d53cac. Unfortunately due to the blocking nature of the driver and issues with seeing if there is a byte available on a blocking stream when it is encrypted this introduces unacceptable delays in returning from peek(). At this time there is no simple solution to this. ### [`v42.2.21`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#42221-2021-06-10) ##### Changed - Update docs to reflect deprecated DataSource API setServerName backpatch [PR#2057](https://togithub.com/pgjdbc/pgjdbc/pull/2057) [PR #​2105](https://togithub.com/pgjdbc/pgjdbc/pull/2105) ##### Fixed - make sure the table has defined primary keys when using updateable resultset backpatch [PR#2101](https://togithub.com/pgjdbc/pgjdbc/pull/2101) fixes [Issue 1975](https://togithub.com/pgjdbc/pgjdbc/issues/1975) [PR #​2106](https://togithub.com/pgjdbc/pgjdbc/pull/2106) - backpatch [PR #​2143](https://togithub.com/pgjdbc/pgjdbc/pull/2143) read notifies or errors that come in asynchronously after the ready for query [PR #​2168](https://togithub.com/pgjdbc/pgjdbc/pull/2168) - backpatch [PR #​507](https://togithub.com/pgjdbc/pgjdbc/pull/507) which reworks OSGI bundle activator fixes [ISSUE #​2133](https://togithub.com/pgjdbc/pgjdbc/issues/2133) - Fix database metadata getFunctions() and getProcedures() to ignore search_path when no schema pattern is specified. backpatch [PR #​2174](https://togithub.com/pgjdbc/pgjdbc/pull/2174) fixes [Issue 2173](https://togithub.com/pgjdbc/pgjdbc/issues/2173) ### [`v42.2.20`](https://togithub.com/pgjdbc/pgjdbc/blob/HEAD/CHANGELOG.md#42220-2021-04-19) ##### Fixed - Partitioned indexes were not found fixes [#​2078](https://togithub.com/pgjdbc/pgjdbc/issues/2078) PR [#​2087](https://togithub.com/pgjdbc/pgjdbc/pull/2087) - isValid() timeout should not be blocked [#​1943](https://togithub.com/pgjdbc/pgjdbc/pull/1943) Cherry-picked [#​2076](https://togithub.com/pgjdbc/pgjdbc/pull/2076) The usage of `setQueryTimeout();` with the same value as the `setNetworkTimeout();` is blocking the current transaction timeout. The timeouts are blocking each other with this approach. - DatabaseMetaData.getTables returns columns in UPPER case as per the spec [PR #​2092](https://togithub.com/pgjdbc/pgjdbc/pull/2092) fixes [Issue #​830](https://togithub.com/pgjdbc/pgjdbc/issues/830)

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

This PR has been generated by Mend Renovate. View repository job log here.