vertx-jdbc-client: UpdateResult.getKeys() returns a PGobject instead of a String

I found this issue while trying to upgrade from vert.x 3 to vert.x 4.3.3. After some testing, I noticed that it works correctly in 4.3.0 but starts failing in 4.3.1.

I have many tables with a text id and a jsonb data column. After running updateWithParams and getting the keys, I used to be able to get the data column with result.getKeys().getString(1) but that now throws an error, as the key is a PGobject instead of a string.

This can be easily reproduced by simply running the documentation code found here on vert.x 4.3.0 and again on 4.3.1+ with a jsonb column. result.getKeys() contains different values between the two.

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Comments: 25 (12 by maintainers)

Commits related to this issue

Most upvoted comments

can we revert the commit partially ?

@colinchilds thanks for the heads up, and so sorry for the late response. let me re-check it. Do you mind sharing your environment

  • vertx version
  • pgJDBC version
  • PostgreSQL server version
  • Which datasource library and version? hikari/agroal or c3p0?

As your description, I understand you are using legacy JDBCClient, right?