Java JDBC driver causes serious performance issue with Microsoft SQL Server when setting property sendStringParametersAsUnicode to true

Issue

• Java JDBC driver causes serious performance issue with Microsoft SQL Server when setting property sendStringParametersAsUnicode to true.
• Performance degradation in RH-SSO Database where it is observed that implicit conversion is heavily impacting read times during queries (e.g 1400 reads vs. 3 reads if done without conversion)
• We are observing performance issue in RH-SSO, where looking closely we found out large number of CONVERT_IMPLICIT events in our SQL database. These events are happening because the system is incorrectly supplying userID with type NVARCHAR to SQL database, when the USER_ID column is in fact of type VARCHAR.