You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Julian Reschke (Jira)" <ji...@apache.org> on 2023/09/13 07:40:00 UTC

[jira] [Comment Edited] (OAK-8915) RDBDocumentStore: use setNString() for columns known to be of type N*CHAR

    [ https://issues.apache.org/jira/browse/OAK-8915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17040960#comment-17040960 ] 

Julian Reschke edited comment on OAK-8915 at 9/13/23 7:39 AM:
--------------------------------------------------------------

trunk: (1.26.0) [fcd6d7d175|https://github.com/apache/jackrabbit-oak/commit/fcd6d7d1755e1fa0cef51b3b230855d3e91c52b2]
1.22: (1.22.2) [c27aeb4bc8|https://github.com/apache/jackrabbit-oak/commit/c27aeb4bc8b6b44df3543f02b4e3c4aadcd6e84a]

...in retired branches:
1.10: [fd60b0f0c3|https://github.com/apache/jackrabbit-oak/commit/fd60b0f0c360b79de558451ed2fb83379cc7620a]
1.8: (1.8.21) [9306dc7464|https://github.com/apache/jackrabbit-oak/commit/9306dc74649c6695f2e772471b29ed9627fe6221]
1.6: (1.6.21) [9b2c2f5e0c|https://github.com/apache/jackrabbit-oak/commit/9b2c2f5e0ce5e38d5bd97b5fa2d6de7dbe60ddf5]



was (Author: reschke):
trunk: [r1874249|http://svn.apache.org/r1874249]
1.22: (1.22.2) [r1874825|http://svn.apache.org/r1874825]
1.10: [r1875251|http://svn.apache.org/r1875251]
1.8: (1.8.21) [r1875260|http://svn.apache.org/r1875260]
1.6: [r1875423|http://svn.apache.org/r1875423]


> RDBDocumentStore: use setNString() for columns known to be of type N*CHAR
> -------------------------------------------------------------------------
>
>                 Key: OAK-8915
>                 URL: https://issues.apache.org/jira/browse/OAK-8915
>             Project: Jackrabbit Oak
>          Issue Type: Technical task
>          Components: rdbmk
>            Reporter: Julian Reschke
>            Assignee: Julian Reschke
>            Priority: Minor
>              Labels: candidate_oak_1_22
>             Fix For: 1.26.0, 1.8.21, 1.6.21, 1.22.2
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)