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

Solution Verified - Updated -

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)

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
  • Red Hat Single Sign-On (RH-SSO)
  • Microsoft SQL Server Database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In