Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
3.7.0, 3.7.3
-
None
Description
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.