[
https://jira.jboss.org/jira/browse/JBESB-2235?page=com.atlassian.jira.plu...
]
Daniel Bevenius commented on JBESB-2235:
----------------------------------------
Please ignore my last comment. This was a configuration mistake on my part.
I'm now getting the following error while running the bpm_orchestration4 quickstart:
2009-01-14 10:07:24,301 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not insert:
[org.jbpm.context.exe.variableinstance.StringInstance] [/* insert
org.jbpm.context.exe.variableinstance.StringInstance */ insert into JBPM_VARIABLEINSTANCE
(ID_, VERSION_, NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_,
STRINGVALUE_, CLASS_) values (null, ?, ?, ?, ?, ?, ?, ?, 'S')]
org.h2.jdbc.JdbcSQLException: Value too long for column STRINGVALUE_:
STRINGDECODE('<Order orderId=\"2\" orderDate=\"Wed Nov 15 13:45:28
EST 2006\" statusCode=\"0\" \nnetAmount=\"59.97\" totalAmount...
[90005-79]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:299)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:560)
at org.h2.command.dml.Insert.update(Insert.java:93)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:206)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:137)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:126)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
at
org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at
org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:431)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:265)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at org.jbpm.logging.db.DbLoggingService.log(DbLoggingService.java:50)
at org.jbpm.svc.save.SaveLogsOperation.save(SaveLogsOperation.java:47)
at org.jbpm.svc.Services.save(Services.java:176)
at org.jbpm.JbpmContext.save(JbpmContext.java:464)
at
org.jbpm.command.NewProcessInstanceCommand.execute(NewProcessInstanceCommand.java:101)
at
org.jboss.soa.esb.services.jbpm.cmd.CommandExecutor$AsyncStartProcessInstanceCommand.execute(CommandExecutor.java:289)
at org.jbpm.command.impl.CommandServiceImpl.execute(CommandServiceImpl.java:71)
at
org.jboss.soa.esb.services.jbpm.cmd.CommandExecutor.executeJbpmCommand(CommandExecutor.java:238)
at
org.jboss.soa.esb.services.jbpm.cmd.CommandExecutor.access$100(CommandExecutor.java:55)
at
org.jboss.soa.esb.services.jbpm.cmd.CommandExecutor$NewProcessInstancePerformer.perform(CommandExecutor.java:229)
at
org.jboss.soa.esb.services.jbpm.cmd.CommandExecutor$NewProcessInstancePerformer.execute(CommandExecutor.java:172)
at org.jboss.soa.esb.services.jbpm.actions.BpmProcessor.process(BpmProcessor.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.soa.esb.listeners.message.ActionProcessorMethodInfo.processMethods(ActionProcessorMethodInfo.java:102)
at
org.jboss.soa.esb.listeners.message.OverriddenActionLifecycleProcessor.process(OverriddenActionLifecycleProcessor.java:74)
at
org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.processPipeline(ActionProcessingPipeline.java:520)
at
org.jboss.soa.esb.listeners.message.ActionProcessingPipeline.process(ActionProcessingPipeline.java:392)
at
org.jboss.soa.esb.listeners.message.MessageAwareListener$TransactionalRunner.run(MessageAwareListener.java:546)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
2009-01-14 10:07:24,301 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 90005,
SQLState: 90005
2009-01-14 10:07:24,301 ERROR [org.hibernate.util.JDBCExceptionReporter] Value too long
for column STRINGVALUE_: STRINGDECODE('<Order orderId=\"2\"
orderDate=\"Wed Nov 15 13:45:28 EST 2006\" statusCode=\"0\"
\nnetAmount=\"59.97\" totalAmount... [90005-79]
This is the create table statement from jbpm.esb/jbpm-sql/jbpm.jpdl.hsqldb.sql:
create table JBPM_VARIABLEINSTANCE (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, VERSION_ integer not null, NAME_ varchar(255),
CONVERTER_ char(1), TOKEN_ bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint,
BYTEARRAYVALUE_ bigint, DATEVALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_
varchar(255), LONGVALUE_ bigint, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000),
TASKINSTANCE_ bigint, primary key (ID_));
As you can see the STRINGVALUE_ column should be able to store this string without a
problem.
This issue sounds similar to:
https://jira.jboss.org/jira/browse/JBESB-1435.
As mentioned in the above jira I updated updated the following files in jbpm-jpdl.jar
1. org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml:
<subclass name="org.jbpm.context.exe.variableinstance.StringInstance"
extends="org.jbpm.context.exe.VariableInstance"
discriminator-value="S">
<property name="value" type="text"
column="STRINGVALUE_" length="4000"/>
</subclass>
Here I added the length attribute which did not exist.
2. org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml:
<subclass
name="org.jbpm.context.exe.variableinstance.HibernateStringInstance"
extends="org.jbpm.context.exe.VariableInstance"
discriminator-value="I">
<any name="value" id-type="string"
cascade="save-update">
<column name="STRINGIDCLASS_" />
<column name="STRINGVALUE_" length="4000"/>
</any>
</subclass>
Same here, I added the length attribute.
The quickstart can now be run. Going to see if I can run the integration tests now.
Upgrade jBPM to version 3.3.0
-----------------------------
Key: JBESB-2235
URL:
https://jira.jboss.org/jira/browse/JBESB-2235
Project: JBoss ESB
Issue Type: Task
Security Level: Public(Everyone can see)
Components: Process flow
Affects Versions: 4.4
Reporter: Kevin Conner
Assignee: Daniel Bevenius
Fix For: 4.5
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira