Replace JPAStorageService with JDBCStorageService for upgrade IdP to v5.0.0

[Noriyuki TAKEI]

I also encountered a similar error and resolved it by taking the following
measures:

I changed the SQL for creating the table to the following:

CREATE TABLE StorageRecords (
    context varbinary(255) NOT NULL,
    id varbinary(255) NOT NULL,
    expires bigint DEFAULT NULL,
    value text NOT NULL,
    version bigint NOT NULL,
    PRIMARY KEY (context, id)
);

The difference is that I changed context and id from varchar to varbinary.
This makes the column names case-sensitive.

On Wed, Feb 28, 2024 at 11:42 AM 板東 孝文 <bandou.takafumi at tokushima-u.ac.jp>
wrote:

> Hello,
>
> I'm trying to replace JPAStorageService with JDBCStorageService prior to
> upgrading the IdP.
> I refer to the following web page(
> https://shibboleth.atlassian.net/wiki/spaces/IDPPLUGINS/pages/2989096970/JDBCStorageService
> ).
>
> But, when I restarted tomcat, I got the following message.
>
> catalina.out
> ======================================================================
> 2024-02-28 10:58:50.981 [ERROR] :
> org.springframework.web.context.ContextLoader: Context initialization failed
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'JDBCStorageService' defined in file
> [/opt/shibboleth-idp/conf/global.xml]:
> Invocation of init method failed; nested exception is
> net.shibboleth.utilities.java.support.component.ComponentInitializationException:
>
> net.shibboleth.utilities.java.support.component.ComponentInitializationException:
> Key Column is Case Insensitive
> ======================================================================
>
> Here are the settings I changed and my environment.
>
>  JVM Version:           17.0.9+9-LTS
>  Server version name:   Apache Tomcat/10.1.16
>  shibboleth-identity-provider-4.3.1
>
> conf/global.xml
> ======================================================================
> <bean id="JDBCStorageService" parent="shibboleth.JDBCStorageService"
>           p:cleanupInterval="%{idp.storage.cleanupInterval:PT10M}"
>           p:dataSource-ref="MyDataSource"
>           p:transactionIsolation="4"
>           p:retryableErrors="40001"
>     />
> ======================================================================
>
> conf/idp.properties.xml
> ======================================================================
> #idp.consent.StorageService = shibboleth.JPAStorageService
> idp.consent.StorageService = JDBCStorageService
> ======================================================================
>
> Of course, I installed the latest plugin version supported on my IdP
> version with.
>
> -----------------------------------------------------------------------
> # sh /opt/shibboleth-idp/bin/plugin.sh -l
>
> Plugin: net.shibboleth.plugin.storage.jdbc      Current Version: 1.0.4
> -----------------------------------------------------------------------
>
>
> 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.
> I don't find the right configuration yet.
>
> Many thanks by advance for your time and help,
>
> Best regards,
>
> ----------------------------------------------------------------
> Tokushima University
> Takafumi Bando
>
> --
> For Consortium Member technical support, see
> https://shibboleth.atlassian.net/wiki/x/ZYEpPw
> To unsubscribe from this list send an email to
> users-unsubscribe at shibboleth.net
>

--
・‥…━━━━━━━━━━━━━━━━━━━━━━━…‥
サイオステクノロジー株式会社
技術1部
OSS & Cloud インテグレーショングループ
武井 宜行
〒106-0047  東京都港区南麻布二丁目 12 番 3 号 サイオスビル
TEL：070-6569-1211 (直通) 03-6401-5117 (部代表)
URL：http://www.sios.com/

■SIOSの最新情報はこちらから！「いいね！」をお待ちしています■
(SIOS Technology)：http://www.facebook.com/SIOSTechnology
(OSSよろず相談室)：http://www.facebook.com/OSSyorozu

■Twitter公式アカウント■
https://twitter.com/#!/SIOS_Technology
・‥…━━━━━━━━━━━━━━━━━━━━━━━…‥
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20240228/53a95d0d/attachment.htm>