Adrian Bucher updated JAMES-3875:
    Fix Version/s: 3.8.0

> 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
>             Fix For: 3.8.0
>          Time Spent: 20m
>  Remaining Estimate: 0h
> 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

To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org

Reply via email to