Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-1266 DocumentStore implementation for relational databases
  3. OAK-8915

RDBDocumentStore: use setNString() for columns known to be of type N*CHAR

    XMLWordPrintableJSON

    Details

    • Type: Technical task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.26.0, 1.8.21, 1.6.21, 1.22.2
    • Component/s: rdbmk
    • Labels:
      None

      Description

      Microsoft's JDBC driver supports a connection property "sendStringParametersAsUnicode" (<https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15>). When set to false, RDBDocumentStore would fail as the DATA column indeed requires Unicode.

      The fix is to detect the type of the DATA column (similar on how we special-case ID), and use setNString() for these cases.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                reschke Julian Reschke
                Reporter:
                reschke Julian Reschke
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: