pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: dkozlov-de (@dkozlov-de) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #3926: ResultSetMetaData.getColumnClassName is broken for jsonb
Date: Tue, 10 Mar 2026 13:34:18 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
I would like to clarify my point first. I do not have any problems with treating JSONB column data as a String. It is your call and I respect it. The problem is with resultset still returning PGobject.
We use org.apache.commons.beanutils.RowSetDynaClass and related classes to dynamically retrieve typed data from a resultset. This library uses column metadata to figure out what the type of a column is. Then when we ask for the column data, it tries to cast the data in resultset to the type provided by the metadata. At this point it fails because metadata says it is a String, but what the resultset returns is still PGobject.
My point is that if you change the type reported by metadata to String, you should be consistent and change the real type the resultset returns to String as well. Otherwise, the metadata column class information is wrong/misleading and prevents from proper data evaluation.
view thread (10+ 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] issue #3926: ResultSetMetaData.getColumnClassName is broken for jsonb
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