Details
-
Bug
-
Resolution: Fixed
-
Medium
-
None
-
3.0 Standard Beta
-
3
-
Description
The JIRA mail service extracts attachments from mails it reads, and adds them as issue attachments. Apparently this parsing breaks on Oracle if attachments are over 32k, and probably also 4k (see JRA-4361):
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while setting value: (setString can only process strings of
less than 32766 chararacters)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:684)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:601)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:436)
at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:114)
at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
at com.atlassian.jira.issue.managers.DefaultActionManager.createEmail(DefaultActionManager.java:158)
at com.atlassian.jira.service.util.handler.EmailHandler.handleMessage(EmailHandler.java:39)
at com.atlassian.jira.service.services.pop.PopService.run(PopService.java:110)
at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:53)
at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)
java.sql.SQLException: setString can only process strings of less than 32766 chararacters
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4575)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4546)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
at org.ofbiz.core.entity.jdbc.SQLProcessor.setValue(SQLProcessor.java:452)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:636)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:601)
at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:436)
at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:114)
at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:88)
at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:470)
at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:450)
at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:61)
at com.atlassian.jira.issue.managers.DefaultActionManager.createEmail(DefaultActionManager.java:158)
at com.atlassian.jira.service.util.handler.EmailHandler.handleMessage(EmailHandler.java:39)
at com.atlassian.jira.service.services.pop.PopService.run(PopService.java:110)
at com.atlassian.jira.service.JiraServiceContainer.run(JiraServiceContainer.java:53)
at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:50)
at org.quartz.core.JobRunShell.run(JobRunShell.java:147)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:387)
Attachments
Issue Links
- is related to
-
JRASERVER-6421 Workflow Overflow if workflow greater than 32k in Oracle.
- Closed