The Ultimate Guide to High Availability with MariaDB

Comments - About MariaDB Connector/J

7 years, 6 months ago Diego Dupin
Re: About MariaDB Connector/J
This comment has the status of 'removed' and can only be seen by you.

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 those informations : _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) key1 with value "value1" key2 with value "value2"

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.