[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 ) *created* an issue

Plugin - JDBC StorageService ( https://shibboleth.atlassian.net/browse/JJDBC?atlOrigin=eyJpIjoiMTJmNWIyMmM0OGJlNGY4OWFmYWUwYzY2OTBlNGU3ZWIiLCJwIjoiaiJ9 ) / Bug ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMTJmNWIyMmM0OGJlNGY4OWFmYWUwYzY2OTBlNGU3ZWIiLCJwIjoiaiJ9 ) JJDBC-17 ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMTJmNWIyMmM0OGJlNGY4OWFmYWUwYzY2OTBlNGU3ZWIiLCJwIjoiaiJ9 ) ERROR when JSON Parsing with MS SQL Server ( https://shibboleth.atlassian.net/browse/JJDBC-17?atlOrigin=eyJpIjoiMTJmNWIyMmM0OGJlNGY4OWFmYWUwYzY2OTBlNGU3ZWIiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 1.0.4 Assignee: Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) Created: 31/Aug/22 10:01 AM Environment:

IdP 4.2.1 on Ubuntu 22

Priority: Trivial Reporter: Martin Hitschel ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=60ad392346b55100698aa768 )

We’ve had the task to migrate the DB from mySQL to MS SQL Server. After having invested quite some time on research of the subtle SQL dialect changes, the IdP will not work correctly in the end. Here is what happens:

* After accepting Attribute Consent, the IdP spits out: *Uncaught runtime exception javax.json.stream.JsonParsingException: Unexpected char 92 at (line no=1, column no=2, offset=1)*
* However, the Record with the accepted consent values will get saved to the database correctly, because…
* …this does not happen upon second login, so obviously the IdP can read the consent record and skip the consent screen.

I am happy to provide the complete DEBUG log out-of-band, however, the error looks like there might be an issue with escaping the “quote” character: char 92 is the backslash, and the JSON to-be-saved-and-read starts with these characters:

[{"id":"bwidmOrgId"

Which in a database dump looks like:

[{\"id\":\"bwidmOrgId\"

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

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/4973831b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-790a8ecb-c266-4eb1-9263-6b6263e2f947
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/4973831b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-trivial-f23410e3-13fe-46b1-9547-8d50db7c29ca
Type: image/png
Size: 563 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/4973831b/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-bbb6bcc8-ca19-4523-afe8-741af9efd907
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/4973831b/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-d375ae3f-c4f5-47ab-bdbb-c628000141f3
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220831/4973831b/attachment-0007.png>