Adrian Bucher created JAMES-3875:

             Summary: JDBCMailRepository MSSQL Insert failures
                 Key: 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

To unsubscribe, e-mail:
For additional commands, e-mail:

Reply via email to