Comments - About MariaDB Connector/J

I may have not been clear.

There is in fact 2 differents way to achieve that : standard JDBC : using connection , you can add some specific informations:

Properties properties = new Properties();
properties.setProperty("ApplicationName", "your application");
properties.setProperty("ClientUser", "your user");
properties.setProperty("ClientHostname", "myhost");

connection.setClientInfo(properties); and so after that, you will be able to retrieve those informations : String currentHost = connection.getClientInfo("myhost");

other solution is the first explain : If performance_schema variable is activated on server, in Table performance_schema.session_connect_attrs, for each connection, you will have :

• _client_name (example : MariaDB connector/J)
• _client_version ( 1.5.4-SNAPSHOT)
• _os (example : Windows 10)
• _pid (example : 1636)
• _thread (example : 13)
• _java_vendor (example : Oracle Corporation)
• _java_version (example : 1.8.0_91)

You can add specific information using option "connectionAttributes" . Example connecting with url "jdbc:mariadb:localhost/db?user=xxx&connectionAttributes=key1:value1,key2,value2"

you will have then have 2 additionnals informations :

• key1 with value "value1"
• key2 with value "value2"

It works great, thank you so mcuh for the help and for all the fast responses!