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

[Rod Widdowson (Jira)]

Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) *commented* on JJDBC-17 ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiY2EwNzEyZmZmYjMzNDIyZjhlYWM1YzQ3NmU1NzY2ZjIiLCJwIjoiaiJ9 )

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

with value ntext NOT NULL I still succeed

2022-09-07 10:35:38,015 - 127.0.0.1 - TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:553] - Create [Insert]:: 'INSERT INTO StorageRecords(context, id, expires, value, version) VALUES (?, ?, ?, ?, 1)'  1: 'intercept/attribute-release' ; 2: 'jdoe:https://sp.example.org' ; 3 'null' ; 4 '[{"id":307},{"id":308},{"id":"mail"},{"id":"schacHomeOrganization"},{"id":"uid"}]'
.....
2022-09-07 15:38:36,605 - 127.0.0.1 - TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:641] - Read:: 'SELECT version, expires, value FROM StorageRecords WHERE context =? AND id=?' 1: 'intercept/attribute-release' ; 2: 'jdoe:https://sp.example.org'
2022-09-07 15:38:46,373 - 127.0.0.1 - TRACE [net.shibboleth.plugin.storage.jdbc.impl.JDBCStorageService:652] - Considering Version '1', Expires '[{"id":307},{"id":308},{"id":"mail"},{"id":"schacHomeOrganization"},{"id":"uid"}]', Value 'null''

Slightly stumped about where to go now. I’ll do some more research

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

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:e474d8f )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220907/e44a0c59/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-337c92d4-ad2a-4d13-a0be-1c9b7518bedb
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220907/e44a0c59/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-69cd4451-747a-4fa2-ae08-6159853a82dd
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220907/e44a0c59/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-db3e77f7-85fb-4c7e-9bf7-b4be7198d281
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220907/e44a0c59/attachment-0005.png>