[ https://issues.apache.org/jira/browse/JAMES-3875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
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 (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org For additional commands, e-mail: server-dev-h...@james.apache.org