[
https://issues.apache.org/jira/browse/JAMES-3875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17678315#comment-17678315
]
Benoit Tellier commented on JAMES-3875:
---------------------------------------
Hello,
Thanks to report these issues.
Please be aware that JDBCMailRepository is deprecated and will be dropped after
the 3.8.x release line. The community will likely not improve this component.
Contributions welcome anyway,but migration to another repository implementation
(the JPA one?) is strongly advised.
Regards,
Benoit TELLIER
> JDBCMailRepository MSSQL Insert failures
> ----------------------------------------
>
> Key: JAMES-3875
> URL: https://issues.apache.org/jira/browse/JAMES-3875
> Project: James Server
> Issue Type: Bug
> Components: JDBC, MailStore & MailRepository
> Affects Versions: 3.7.0, 3.7.3
> Reporter: Adrian Bucher
> Priority: Major
>
> JDBCMailRepository has two errors in the insert prepared statement if working
> with MSSQL:
> *1. Error Message can not be stored in the JDBC if it is longer then 200
> chars, this causes a new exception, and the email can be lost.*
> The error field of the email table is only 200 char long, if you try to store
> a longer error message (i.e. an exception) this will fail as the driver does
> not cut the message, and the inster statement will throw an exception.
> *2. MSSQL Server does throw "cannot convert nvarchar to image" in case of
> per_recipient_headers is null.*
> In the case that the per_recipient_header is null the field is stored as
> object, mssql can not handle this and gets a type convertion error.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org
