UpdateResult getKeys method is retuning empty

[jgutierreznab]

Hi guys, first, thank you so much for this amazing framework.

updateWithParams UpdateResult getKeys methods is returning an empty array, not sure if this is important => vert-x3/vertx-jdbc-client#113 from 2017

I'm currently under <vertx.version>3.8.3</vertx.version>

     <dependency>
	 <groupId>io.vertx</groupId>
	 <artifactId>vertx-mysql-postgresql-client</artifactId>
	</dependency>

connection type is SQLConnection

String execQuery = "INSERT INTO users(username, email, password) VALUES (?, ?, ?) RETURNING (id)";

the query is valid and is inserting properly in the Pg table

connection.updateWithParams(execQuery, queryParams, h -> {
  if (h.succeeded()) {
							
	 UpdateResult result = h.result();
	 System.out.println("result.getUpdated() => " + result.getKeys());
	
        someFuture.complete(result.getKeys().getValue(0));
	connection.close();
 }
})

also tried with .setOptions(new SQLOptions().setAutoGeneratedKeys(true)) with no luck

connection.setOptions(new SQLOptions().setAutoGeneratedKeys(true)).updateWithParams(execQuery, queryParams, h -> {

thank you very much for the amazing work

[garrydias]

Same problem here.
setAutoGeneratedKeys(true) is unsupported operation and raises an exception.
The version i'm using is 3.8.5.
Is there any workarounds?

[jgutierreznab]

@garrydias probably using the ReactiveJDBC will solve it