mysql/mariadb protocol doesn't know auto_increment column name when inserting data.
mysql driver return by default "GENERATED_KEY" while mariadb driver return "insert_id".

The only solution would be to parse command, extract table name and search for auto_increment field. That would be costly in terms of performance.

Since MariaDB/MySQL can have only one auto_increment field, retrieving value using getLong(0) or getLong("insert_id") in place of getLong("<my real column name>") with connector command parsing + an additional round trip seems a bit too much just to be rigorous.

I understand that this is not perfect, but better than the alternative

Hi Diego,

Failing to know the name of the column, would it not be possible to know its index (ie: from 1 to n)?

index is always 1.
example:

stmt.executeUpdate("INSERT INTO MyTable (test) VALUES ('somevalue')",

            java.sql.Statement.RETURN_GENERATED_KEYS);

ResultSet rsGen = stmt.getGeneratedKeys();

rsGen.next();

long generatedId = rsGen.getLong(1);