Summary of several problems of esgyndb using JDBC UDR to access remote trafodion

In the previous article Trafodion adopt TMUDF Access remote Oracle database In this article, we introduce how to use TMUDF Access to access the remote database , Such as Oracle、MySQL Even remote Trafodion database .
Coincidentally, you need to use... In an environment today TMUDF To access remote Trafodion database , And encountered several small problems in the process of use , Below we describe several problems and solutions , For your reference when you encounter problems later .

Question 1 ： Remote access with multi tenancy

Error message ：tenant name invalid

Solution
Access with multi tenancy needs to be in JDBC URL add to tenantName=xxx Information

Question two

Error message ：Unable to obtain privileges

Solution
Add the corresponding SQL_OPERATIONS jurisdiction

grant component privilege MANAGE_LIBRARY ON SQL_OPERATIONS to xxx;

Question 3

Error message ： It's actually a warning message , because EsgynDB In the new version "_LIBMGR_" It's already brought with it jdbc UDR function , So it's recommended to use your own jdbc UDR function .

Solution
In the sentence jdbc It is amended as follows TRAFODION."_LIBMGR_".jdbc, As shown in the figure below