Identify iDempiere JDBC connections in DBeaver or other session administration software
Description
At this moment when checking iDempiere connections on DBeaver it just shows "JDBC connection".
It would be good to add some way to identify which connections are coming from iDempiere.
Environment
None
Attachments
1
Activity
Show:
Nicolas Micoud October 7, 2021 at 10:19 AM
Ok I get it - so indeed iDempiere is fine Thanks for clarifying this
Carlos Ruiz October 7, 2021 at 10:14 AM
It’s nothing related to end-users, this is the DBeaver screenshot:
So, instead of showing “PostgreSQL JDBC Driver” - which is shown for any other JDBC connection too, it shows “iDempiere” when the connection is coming from our system.
Nicolas Micoud October 7, 2021 at 9:49 AM
Ah I see
And what about trying to read a value from idempiereInit.properties? And if not set, use “iDempiere” instead? nb: I don’t know how to use this new value, so maybe having an hardcoded value ‘iDempiere’ is good enough
Carlos Ruiz October 7, 2021 at 9:42 AM
As this code is precisely before opening a connection to the database, it is not possible to use a value from the database.
Nicolas Micoud October 7, 2021 at 5:04 AM
Hi ,
Haven’t tested but instead of using “iDempiere” as value, is it possible to show AD_System.Name?
At this moment when checking iDempiere connections on DBeaver it just shows "JDBC connection".
It would be good to add some way to identify which connections are coming from iDempiere.