[
https://issues.jboss.org/browse/JBPM-2138?page=com.atlassian.jira.plugin....
]
Alejandro Guizar edited comment on JBPM-2138 at 12/9/10 12:55 PM:
------------------------------------------------------------------
JBPM-2488 trims stack traces to 4000 characters for databases other than MySQL and
Sybase.
The exception column is mapped to TEXT columns under MySQL and Sybase, providing more
capacity. Under MySQL, the limit is 2^16-1, whereas Sybase can hold up to 2^31-1
characters, which is also the limit for a Java String.
The article "jBPM3 Text Columns" documents how to customize the long string
column mappings.
http://community.jboss.org/wiki/jBPM3TextColumns
was (Author: alex.guizar(a)jboss.com):
JBPM-2488 trims stack traces to 4000 characters for databases other than MySQL and
Sybase.
The exception column is mapped to TEXT columns under MySQL and Sybase, providing more
capacity. Under MySQL, the limit is 2^16-1, whereas Sybase can hold up to 2^31-1
characters, which is also the limit for a Java String.
JBPM_LOG table column 'exception' is too small, throws RE:
ORA-01461: can bind a LONG value only for insert into a LONG column
------------------------------------------------------------------------------------------------------------------------------
Key: JBPM-2138
URL:
https://issues.jboss.org/browse/JBPM-2138
Project: jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Affects Versions: jBPM 3.2.5 GA , jBPM-3.2.5.SP1, jBPM-3.2.5.SP2, jBPM 3.2.6 GA ,
jBPM-3.2.5.SP3, jBPM 3.2.6.SP1, jBPM-3.2.5.SP4, jBPM 3.2.5.SP5
Environment: jbpm 3.2.6 on an oracle server, any application server or OS
Reporter: George Mournos
Assignee: Alejandro Guizar
Labels: column, exception, jbpm3, log
Attachments: Patch per JBTM-2138.patch
If an action throws an exception, the stack trace is logged in the JBPM_LOG table.
However, in case of a very long stack trace (longer than 4000 characters), this throws an
oracle Exception.
"RE: ORA-01461: can bind a LONG value only for insert into a LONG column"
The bug is difficult to trace, since the exception is only thrown at hibernate
session.flush() and not at the actual insert...
Actual exception stacktrace that presented the problem was the exception stacktrace of
weblogic, 7200 chars. (the jbpm action was executing business logic running in its own
transaction).
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira