You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Norman Maurer (JIRA)" <se...@james.apache.org> on 2010/03/02 20:09:27 UTC
[jira] Created: (IMAP-114) Used Column for storing the message
content is to small
Used Column for storing the message content is to small
-------------------------------------------------------
Key: IMAP-114
URL: https://issues.apache.org/jira/browse/IMAP-114
Project: JAMES Imap
Issue Type: Bug
Components: JPA Mailbox
Reporter: Norman Maurer
Assignee: Norman Maurer
Fix For: 0.1
Tim posted on ml:
Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
FailedObject: org.apache.james.imap.jpa.mail.model.JPAMessage@1126d91
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:82)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
... 31 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1586)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
... 41 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Commented: (IMAP-114) Used Column for storing the message
content is to small
Posted by "Tim-Christian Mundt (JIRA)" <se...@james.apache.org>.
[ https://issues.apache.org/jira/browse/IMAP-114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12842246#action_12842246 ]
Tim-Christian Mundt commented on IMAP-114:
------------------------------------------
Unfortunately - while increasing column size fixes the problem - the annotation @Column(length=1048576000) doesn't make OpenJPA create a LONGBLOB column. I tried adding a columnDefinition="LONGBLOB" to it, but also no success, I always get a simple BLOB column. Could this be an issue with OpenJPA? At least it was once: https://issues.apache.org/jira/browse/OPENJPA-740 (still open).
> Used Column for storing the message content is to small
> -------------------------------------------------------
>
> Key: IMAP-114
> URL: https://issues.apache.org/jira/browse/IMAP-114
> Project: JAMES Imap
> Issue Type: Bug
> Components: JPA Mailbox
> Reporter: Norman Maurer
> Assignee: Norman Maurer
> Fix For: 0.1
>
>
> Tim posted on ml:
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> FailedObject: org.apache.james.imap.jpa.mail.model.JPAMessage@1126d91
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:82)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> ... 31 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1586)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
> ... 41 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Resolved: (IMAP-114) Used Column for storing the message
content is to small
Posted by "Norman Maurer (JIRA)" <se...@james.apache.org>.
[ https://issues.apache.org/jira/browse/IMAP-114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Norman Maurer resolved IMAP-114.
--------------------------------
Resolution: Fixed
please update to trunk or add the following line in the persistence.xml:
<property name="openjpa.jdbc.DBDictionary" value="blobTypeName=LONGBLOB"/>
This is needed till openjpa 1.3 or 2.0.0 was released.
> Used Column for storing the message content is to small
> -------------------------------------------------------
>
> Key: IMAP-114
> URL: https://issues.apache.org/jira/browse/IMAP-114
> Project: JAMES Imap
> Issue Type: Bug
> Components: JPA Mailbox
> Reporter: Norman Maurer
> Assignee: Norman Maurer
> Fix For: 0.1
>
>
> Tim posted on ml:
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> FailedObject: org.apache.james.imap.jpa.mail.model.JPAMessage@1126d91
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:82)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> ... 31 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1586)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
> ... 41 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Resolved: (IMAP-114) Used Column for storing the message
content is to small
Posted by "Norman Maurer (JIRA)" <se...@james.apache.org>.
[ https://issues.apache.org/jira/browse/IMAP-114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Norman Maurer resolved IMAP-114.
--------------------------------
Resolution: Fixed
Fixed in revision 918157
> Used Column for storing the message content is to small
> -------------------------------------------------------
>
> Key: IMAP-114
> URL: https://issues.apache.org/jira/browse/IMAP-114
> Project: JAMES Imap
> Issue Type: Bug
> Components: JPA Mailbox
> Reporter: Norman Maurer
> Assignee: Norman Maurer
> Fix For: 0.1
>
>
> Tim posted on ml:
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> FailedObject: org.apache.james.imap.jpa.mail.model.JPAMessage@1126d91
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:82)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> ... 31 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1586)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
> ... 41 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Issue Comment Edited: (IMAP-114) Used Column for storing the
message content is to small
Posted by "Norman Maurer (JIRA)" <se...@james.apache.org>.
[ https://issues.apache.org/jira/browse/IMAP-114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12842287#action_12842287 ]
Norman Maurer edited comment on IMAP-114 at 3/6/10 6:25 PM:
------------------------------------------------------------
Hi Tim,
you are right and after diggin in the openjpa source code the bug still seems to exists :( I just edit the jira ticket, set it to "blocker" and changed it from "improvment" to "bug".
https://issues.apache.org/jira/browse/OPENJPA-740
Thx,
Norman
was (Author: norman):
Hi Tim,
you are right and after diggin in the openjpa source code the bug still seems to exists :( I just edit the jira ticked and set it to "blocker" and changed it from "improvment" to "bug".
https://issues.apache.org/jira/browse/OPENJPA-740
Thx,
Norman
> Used Column for storing the message content is to small
> -------------------------------------------------------
>
> Key: IMAP-114
> URL: https://issues.apache.org/jira/browse/IMAP-114
> Project: JAMES Imap
> Issue Type: Bug
> Components: JPA Mailbox
> Reporter: Norman Maurer
> Assignee: Norman Maurer
> Fix For: 0.1
>
>
> Tim posted on ml:
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> FailedObject: org.apache.james.imap.jpa.mail.model.JPAMessage@1126d91
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:82)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> ... 31 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1586)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
> ... 41 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
[jira] Reopened: (IMAP-114) Used Column for storing the message
content is to small
Posted by "Norman Maurer (JIRA)" <se...@james.apache.org>.
[ https://issues.apache.org/jira/browse/IMAP-114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Norman Maurer reopened IMAP-114:
--------------------------------
Hi Tim,
you are right and after diggin in the openjpa source code the bug still seems to exists :( I just edit the jira ticked and set it to "blocker" and changed it from "improvment" to "bug".
https://issues.apache.org/jira/browse/OPENJPA-740
Thx,
Norman
> Used Column for storing the message content is to small
> -------------------------------------------------------
>
> Key: IMAP-114
> URL: https://issues.apache.org/jira/browse/IMAP-114
> Project: JAMES Imap
> Issue Type: Bug
> Components: JPA Mailbox
> Reporter: Norman Maurer
> Assignee: Norman Maurer
> Fix For: 0.1
>
>
> Tim posted on ml:
> Caused by: <openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> FailedObject: org.apache.james.imap.jpa.mail.model.JPAMessage@1126d91
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
> at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:82)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
> at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
> at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> ... 31 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'content' at row 1 {prepstmnt 23802890 INSERT INTO Message (id, bodyStartOctet, content, contentOctets, mediaType, subType, textualLineCount) VALUES (?, ?, ?, ?, ?, ?, ?) [params=(long) 2501, (int) 786, (InputStream) java.io.ByteArrayInputStream@125bbd3, (long) 396202, (String) multipart, (String) mixed, (null) null]} [code=1406, state=22001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1586)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
> at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
> ... 41 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org