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

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

Here is the global.xml I’d used:

{{   <bean id="shibboleth.JPAStorageService" }}
parent="shibboleth.JDBCStorageService"
{{       p:cleanupInterval="%

{idp.storage.cleanupInterval:PT10M}

" }}
{{       p:dataSource-ref="shibboleth.MSSQLDataSource"/> }}

{{   <bean id="shibboleth.MSSQLDataSource" }}
{{         class="com.zaxxer.hikari.HikariDataSource" destroy-method="close" lazy-init="true" }}
{{         p:driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" }}
{{         p:jdbcUrl="%

{mssql.url}

" }}
{{         p:username="%

{mssql.username}

" }}
{{         p:password="%

{mssql.password}

" />}}

I don’t know the SQL Server version, however the driver version is mssql-jdbc-11.2.0.jre11.jar.

We’ve used the DB like this: grep JPA conf/idp.properties
{{idp.session.StorageService=shibboleth.JPAStorageService }}
idp.consent.StorageService=shibboleth.JPAStorageService

I have sent you the logs directly.

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

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:2202fee )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/895a248b/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-comment-icon-8a642a7f-5480-4f10-80df-18cc3632e3b2
Type: image/png
Size: 1084 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/895a248b/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-avatar-cb2720f7-dfe5-4749-b8f0-f3d7a8624ad0
Type: image/png
Size: 425 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/895a248b/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jira-generated-image-static-footer-desktop-logo-3cb96be8-e607-44f3-8bd2-bd02c61b0cf2
Type: image/png
Size: 10805 bytes
Desc: not available
URL: <http://shibboleth.net/pipermail/commits/attachments/20220908/895a248b/attachment-0005.png>