Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-218

Switch value of the sendStringParametersAsUnicode query parameter for SQL Server database connections

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.0.0
    • 2.5.0
    • None

    Description

      Current Situation

      • The JOC Cockpit setup and examples for hibernate configuration files specify the sendStringParametersAsUnicode query parameter in a JDBC URL for a database connection with the value false.
      • This is acceptable if no Unicode support is required, for example if object names in the JS7 inventory are created within the scope of the latin1 character set.
      • This is wrong if Unicode support is required.
      • Users can modify the value to true by editing the hibernate.cfg.xml configuration file.

      Desired Behavior

      • The JOC Cockpit setup should use the correct value when suggesting JDBC URLs for hibernate configuration files.
      • Example
      jdbc:sqlserver://sqlserversrv:1433;sendStringParametersAsUnicode=true;selectMethod=cursor;databaseName=jobscheduler
      

      Attachments

        Activity

          People

            oh Oliver Haufe
            ap Andreas PĆ¼schel
            Kanika Agrawal Kanika Agrawal
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: