[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=eyJpIjoiYjhkNzZiYWMzZGQ1NDg0NmE3ODY3YTUxMDVlZWY2YmEiLCJwIjoiaiJ9 )

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

Rod Widdowson ( https://shibboleth.atlassian.net/secure/ViewProfile.jspa?accountId=59fb32bbc24efb3c4ed3c977 ) actually today I wanted to close this, since I got feedback from the customer. We’ve tested and yes the plugin is working as intended.

One needs to ensure that the backslashes before quotes are removed before feeding the table data to the SQL Server.

Plus the table definitions and the JDBC url are quite different from mySQL as well, of course, but that is documented on the Web elsewhere.

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

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#100212- sha1:99773b8 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20221212/419e9d5d/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-f6b2a03a-8174-46dd-b5dc-7338c799ebc5
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20221212/419e9d5d/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-017befef-e3c4-40fc-8c2d-8bb78bc3cea7
Type: image/png
Size: 345 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20221212/419e9d5d/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-c7bd2bbd-0fdb-410f-8a27-e1bf2bf90475
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20221212/419e9d5d/attachment-0005.png>