[jira] [Commented] (JAMES-4174) Removed JDBCMailRepository still referenced in sqlResources.xml

    [ https://issues.apache.org/jira/browse/JAMES-4174?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18059655#comment-18059655 ] 

Jean Helou commented on JAMES-4174:
-----------------------------------

Hello, 

JDBCMailRepository's deprecation was planned and discussed on the mailling list in october 2022, it was announced in the 3.8 release notes  https://github.com/apache/james-project/blob/master/CHANGELOG.md#380---2023-05-17 (deprecation section)
The deprecation status  was made explicit in the code at the time (october 2022) see https://github.com/apache/james-project/pull/1237 including a link to the mailing list discussion 

You are right that it is missing from the 3.9 release note. I fixed that 

To migrate you would use james 3.8 and configure both jdbc and jpa mail repositories, setting jpa as the default mail repository implementation 
then you can use the webmin to force reprocess mails from the JDBC mail repository, this should put result in the mails being stored in theJPA mail repository

You can read a bit about this in  https://james.staged.apache.org/james-project/3.9.0/servers/postgres/operate/webadmin.html#_reprocessing_mails_from_a_mail_repository

> Removed JDBCMailRepository still referenced in sqlResources.xml
> ---------------------------------------------------------------
>
>                 Key: JAMES-4174
>                 URL: https://issues.apache.org/jira/browse/JAMES-4174
>             Project: James Server
>          Issue Type: Bug
>          Components: James Core
>    Affects Versions: 3.9.0
>            Reporter: df
>            Priority: Major
>
> As '<artifactId>james-server-data-jdbc</artifactId>' got removed via https://github.com/apache/james-project/pull/1590 the JDBCMailRepository is still referenced:
> https://github.com/apache/james-project/blob/james-project-3.9.0/server/apps/spring-app/src/main/resources/sqlResources.xml#L1
> https://github.com/apache/james-project/blob/james-project-3.9.0/server/apps/spring-app/src/main/resources/mailrepositorystore.xml#L44
> https://github.com/apache/james-project/blob/james-project-3.9.0/server/apps/spring-app/src/main/resources/mailrepositorystore.xml#L61
> https://github.com/apache/james-project/blob/james-project-3.9.0/server/data/data-api/src/test/resources/mailrepositorystore.xml#L32
> https://github.com/apache/james-project/blob/james-project-3.9.0/server/data/data-api/src/test/resources/mailrepositorystore.xml#L40
> https://github.com/apache/james-project/blob/james-project-3.9.0/mpt/impl/imap-mailbox/core/src/main/resources/org/apache/james/mailboxmanager/testdata/MixedMailstores.xml#L82
> https://github.com/apache/james-project/blob/james-project-3.9.0/mpt/impl/imap-mailbox/core/src/main/resources/org/apache/james/mailboxmanager/testdata/MixedMailstores.xml#L115
> It should be its successor JPAMailRepository, see JAMES-2656?
> Also, the corresponding info is missing in the changelog or release notes. How shall we migrate?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)