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

[Martin Hitschel (Jira)]

Martin Hitschel ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=60ad392346b55100698aa768 ) *commented* on JJDBC-17 ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiZjg1YmZhNWU0NTQ4NGE4M2FlNGUwODY3ZmRiNzM3NWYiLCJwIjoiaiJ9 )

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

FWIF, the table declaration I found out “working” with SQL Server (before trying a login) was:

CREATE TABLE StorageRecords (
 context varchar(255) collate Latin1_General_CS_AS NOT NULL,
 id varchar(255) collate Latin1_General_CS_AS NOT NULL,
 expires bigint DEFAULT NULL,
 value ntext NOT NULL,
 version bigint NOT NULL,
 PRIMARY KEY (context,id)
);

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

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:e4fd81d )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/ca6cc575/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-91b79f42-6061-41de-9810-55aaf0933541
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/ca6cc575/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-0585d08a-6cd8-41b2-a3a4-387dd6a4a2a7
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/ca6cc575/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-871a49eb-96e9-4553-aabd-e587be16b8c3
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/ca6cc575/attachment-0005.png>