pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

From: vwassan (@vwassan) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: [pgjdbc/pgjdbc] PR #3796: Add configurable boolean-to-numeric conversion for ResultSet getters
Date: Fri, 12 Sep 2025 20:30:13 +0000
Message-ID: <[email protected]> (raw)

Addresses: https://github.com/pgjdbc/pgjdbc/issues/367

### Problem:
  When calling numeric getters (getByte(), getInt(), getLong(), getShort(), getFloat(), getDouble(), getBigDecimal()) on PostgreSQL boolean columns, the driver
  throws PSQLException: Bad value for type byte : f. 

  ### Solution:
  Added a new connection property `convertBooleanToNumeric` that enables automatic conversion of PostgreSQL boolean values to numeric types:
  - 't' → 1
  - 'f' → 0
  - Works with boolean columns
  - Property cached per connection for optimal performance
  - Boolean column type detection prevents false positive conversions

  ### Usage:
  // JDBC URL
  jdbc:postgresql://host:5432/db?convertBooleanToNumeric=true

  // HikariCP
  config.addDataSourceProperty("convertBooleanToNumeric", "true");

  // Spring Boot
  spring.datasource.hikari.data-source-properties.convertBooleanToNumeric=true

  ### Backward Compatibility:
  - Default: false (maintains existing behavior)
  - getBoolean() continues working regardless of property setting
  - No changes to existing application behavior unless explicitly enabled


### All Submissions:

* [x] Have you followed the guidelines in our [Contributing](https://github.com/pgjdbc/pgjdbc/blob/master/CONTRIBUTING.md) document?
* [x] Have you checked to ensure there aren't other open [Pull Requests](../../pulls) for the same update/change?

<!-- You can erase any parts of this template not applicable to your Pull Request. -->

### New Feature Submissions:

1. [x] Does your submission pass tests?
2. [x] Does `./gradlew styleCheck` pass ?
3. [x] Have you added your new test classes to an existing test suite in alphabetical order?

### Changes to Existing Features:

* [x] Does this break existing behaviour? If so please explain.
* [x] Have you added an explanation of what your changes do and why you'd like us to include them?
* [x] Have you written new tests for your core changes, as applicable?
* [x] Have you successfully run tests with your changes locally?

view thread (11+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: github://pgjdbc/pgjdbc
  Cc: [email protected], [email protected]
  Subject: Re: [pgjdbc/pgjdbc] PR #3796: Add configurable boolean-to-numeric conversion for ResultSet getters
  In-Reply-To: <<[email protected]>>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox