<div dir="ltr"><div dir="ltr">I also encountered a similar error and resolved it by taking the following measures:<br><br>I changed the SQL for creating the table to the following:<br></div><div dir="ltr"><br></div><div dir="ltr">CREATE TABLE StorageRecords (<br> context varbinary(255) NOT NULL,<br> id varbinary(255) NOT NULL,<br> expires bigint DEFAULT NULL,<br> value text NOT NULL,<br> version bigint NOT NULL,<br> PRIMARY KEY (context, id)<br>);<br></div><div dir="ltr"><br></div><div dir="ltr">The difference is that I changed context and id from varchar to varbinary. This makes the column names case-sensitive.</div><div dir="ltr"><br></div><div dir="ltr">On Wed, Feb 28, 2024 at 11:42 AM 板東 孝文 <<a href="mailto:bandou.takafumi@tokushima-u.ac.jp">bandou.takafumi@tokushima-u.ac.jp</a>> wrote:<br></div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
I'm trying to replace JPAStorageService with JDBCStorageService prior to upgrading the IdP.<br>
I refer to the following web page(<a href="https://shibboleth.atlassian.net/wiki/spaces/IDPPLUGINS/pages/2989096970/JDBCStorageService" rel="noreferrer" target="_blank">https://shibboleth.atlassian.net/wiki/spaces/IDPPLUGINS/pages/2989096970/JDBCStorageService</a>).<br>
<br>
But, when I restarted tomcat, I got the following message.<br>
<br>
catalina.out<br>
======================================================================<br>
2024-02-28 10:58:50.981 [ERROR] : org.springframework.web.context.ContextLoader: Context initialization failed<br>
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'JDBCStorageService' defined in file [/opt/shibboleth-idp/conf/global.xml]: <br>
Invocation of init method failed; nested exception is net.shibboleth.utilities.java.support.component.ComponentInitializationException: <br>
net.shibboleth.utilities.java.support.component.ComponentInitializationException: Key Column is Case Insensitive<br>
======================================================================<br>
<br>
Here are the settings I changed and my environment.<br>
<br>
JVM Version: 17.0.9+9-LTS<br>
Server version name: Apache Tomcat/10.1.16<br>
shibboleth-identity-provider-4.3.1<br>
<br>
conf/global.xml<br>
======================================================================<br>
<bean id="JDBCStorageService" parent="shibboleth.JDBCStorageService"<br>
p:cleanupInterval="%{idp.storage.cleanupInterval:PT10M}"<br>
p:dataSource-ref="MyDataSource"<br>
p:transactionIsolation="4"<br>
p:retryableErrors="40001"<br>
/><br>
======================================================================<br>
<br>
conf/idp.properties.xml<br>
======================================================================<br>
#idp.consent.StorageService = shibboleth.JPAStorageService<br>
idp.consent.StorageService = JDBCStorageService<br>
======================================================================<br>
<br>
Of course, I installed the latest plugin version supported on my IdP version with.<br>
<br>
-----------------------------------------------------------------------<br>
# sh /opt/shibboleth-idp/bin/plugin.sh -l<br>
<br>
Plugin: net.shibboleth.plugin.storage.jdbc Current Version: 1.0.4<br>
-----------------------------------------------------------------------<br>
<br>
<br>
I suspected bean id "JDBCStorageService" duplication, so I unziped idp.war and checked the contents of "WEB-INF/lib/*.jar", but didn't be there.<br>
I don't find the right configuration yet.<br>
<br>
Many thanks by advance for your time and help, <br>
<br>
Best regards,<br>
<br>
----------------------------------------------------------------<br>
Tokushima University<br>
Takafumi Bando<br>
<br>
-- <br>
For Consortium Member technical support, see <a href="https://shibboleth.atlassian.net/wiki/x/ZYEpPw" rel="noreferrer" target="_blank">https://shibboleth.atlassian.net/wiki/x/ZYEpPw</a><br>
To unsubscribe from this list send an email to <a href="mailto:users-unsubscribe@shibboleth.net" target="_blank">users-unsubscribe@shibboleth.net</a><br>
</blockquote></div><br clear="all"><div><span class="gmail_signature_prefix">--</span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">・‥…━━━━━━━━━━━━━━━━━━━━━━━…‥<br> サイオステクノロジー株式会社<br> 技術1部<br> OSS & Cloud インテグレーショングループ<br> 武井 宜行<br> 〒106-0047 東京都港区南麻布二丁目 12 番 3 号 サイオスビル<br> TEL：070-6569-1211 (直通) 03-6401-5117 (部代表)<br> URL：<a href="http://www.sios.com/" target="_blank">http://www.sios.com/</a><br><br> ■SIOSの最新情報はこちらから！「いいね！」をお待ちしています■<br> (SIOS Technology)：<a href="http://www.facebook.com/SIOSTechnology" target="_blank">http://www.facebook.com/SIOSTechnology</a><br> (OSSよろず相談室)：<a href="http://www.facebook.com/OSSyorozu" target="_blank">http://www.facebook.com/OSSyorozu</a><br><br> ■Twitter公式アカウント■<br> <a href="https://twitter.com/#!/SIOS_Technology" target="_blank">https://twitter.com/#!/SIOS_Technology</a><br>・‥…━━━━━━━━━━━━━━━━━━━━━━━…‥</div></div></div></div></div></div></div></div></div></div>