topic about the history variables insert sql exception in Alfresco Archive

about the history variables insert sql exception

fuhang — Tue, 29 Sep 2015 07:25:18 GMT

I have a problem about engine saving history variable causing exception.this is my configuration：<blockcode><bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration"> <property name="dataSource" ref="dataSourceDBCP"/>

Re: about the history variables insert sql exception

trademak — Wed, 30 Sep 2015 14:27:59 GMT

Which version of Activiti are you using? Did you try to set the databaseType property of the process engine config to oracle?

Best regards,

Re: about the history variables insert sql exception

fuhang — Thu, 08 Oct 2015 04:55:30 GMT

yes,I set the databaseType to 'oracle', the same exception was throwed as same as MySQL.
Error updating database. Cause: java.sql.SQLException: Invalid column type.
The error may involve org.activiti.engine.impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle-Inline
I found that exception caused by calling spring dao interface problem, but I can't modify the activity source code for some reason. there something to notice is my spring framework version is -3.0.5, I tried to the lasted spring framework and lasted database（oracle 11g/12c, MySQL 5.6.x）jdbc drivers, not used. I can't figure out how to fix it .

Re: about the history variables insert sql exception

jbarrez — Thu, 08 Oct 2015 09:26:47 GMT

Which Oracle version? Can you try with setBulkInsertEnabled(false) on the processEngineCOnfiguration?

I'm not really following your comment about Spring DAO/Activiti source … can you describe your config setup a bit more?

Re: about the history variables insert sql exception

fuhang — Fri, 16 Oct 2015 01:31:51 GMT

Your suggestion solved my problem, it's working now. Thanks a lot.
My Oracle version is Oracle 11g Release 2, spring dao framework version is 3.0.5 and hibernate uses 3.6 version.
I uploaded my config files.

Re: about the history variables insert sql exception

swamy2156 — Tue, 03 Nov 2015 16:50:20 GMT

I am also facing the similar problem like fuhang and my database version is Oracle 11g Release 2, spring dao framework version is 3.0.5. setBulkInsertEnabled(false) means disabling bulk inserts. Can't we do bulk inserts to oracle database? What are the databases suports bulk inserts by Activiti?

thanks,
Swamy.

Re: about the history variables insert sql exception

ak1801 — Thu, 06 Oct 2016 20:41:02 GMT

I was facing same issue after upgrading to activiti-5.21 with postgres db 9.6. I am using SpringProcessEngineConfiguration to create process engine.
As suggested by jbarrez, it got resolved by setting setBulkInsertEnabled(false). But not clear why this issue arises at first place and how does bulk insert cause this. Do share your thoughts if you get any insights.

Thanks,
Akshit.