Adrian Bucher created JAMES-3875:
------------------------------------
Summary: 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
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]
