[JIRA] (JJDBC-17) ERROR when JSON Parsing with MS SQL Server

[Scott Cantor (Jira)]

Scott Cantor ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A5b78efc9-1379-42cc-a3f6-56c6ea3a0007 ) *commented* on JJDBC-17 ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMTBlMWE0ZTI4ZDljNGJlMWI0Yjc2NGI2MWQ2M2Q5MjYiLCJwIjoiaiJ9 )

Re: ERROR when JSON Parsing with MS SQL Server ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMTBlMWE0ZTI4ZDljNGJlMWI0Yjc2NGI2MWQ2M2Q5MjYiLCJwIjoiaiJ9 )

Your table there is using varchar, which is too small. You typically need ntext or some kind of BLOB type to store the data values, as they’re unbounded. The SP had the notion of short and long test for efficience but the IdP doesn’t.

( https://shibboleth.atlassian.net/browse/JJDBC-17#add-comment?atlOrigin=eyJpIjoiMTBlMWE0ZTI4ZDljNGJlMWI0Yjc2NGI2MWQ2M2Q5MjYiLCJwIjoiaiJ9 ) Add Comment ( https://shibboleth.atlassian.net/browse/JJDBC-17#add-comment?atlOrigin=eyJpIjoiMTBlMWE0ZTI4ZDljNGJlMWI0Yjc2NGI2MWQ2M2Q5MjYiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100206- sha1:40f823c )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220906/9aa3c0f0/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-158fbccc-a3a4-438e-9f34-9f26c670f0d5
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220906/9aa3c0f0/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-f55f4964-13e1-45fd-98e1-ab3880c46f5c
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220906/9aa3c0f0/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-a2ba6aec-2249-45bb-9946-6b9fa5e46e75
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220906/9aa3c0f0/attachment-0005.png>