[
https://issues.apache.org/jira/browse/JAMES-3875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17678546#comment-17678546
]
Adrian Bucher commented on JAMES-3875:
--------------------------------------
Hello,
Yes I am aware of this, but JPA repository forces me to FileMailRepository,
what is the state of JAMES-2656 would this address this issue, I also could
look into adding a JpaMailRepository.
Regards
Adrian
> 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: [email protected]
For additional commands, e-mail: [email protected]
