Copy Page

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account. You can also Sign Up for a new account.

<hr /><p>This page is intended for people to share knowledge about running Activiti on particular databases</p><h1>Problem with nullable columns on Sybase and Informix</h1><p><span style="color: rgb(0,0,0);"><a href="http://forums.activiti.org/en/viewtopic.php?t=1207&amp;p=4976#p4976">http://forums.activiti.org/en/viewtopic.php?t=1207&amp;p=4976#p4976</a></span></p><h1>Postgres jdbc vs. DB version mismatch</h1><p>Be sure to use the appropriate postgres version of JDBC-driver for your database, Postgres is sensitive to this.</p><p>Know exceptions when version mismatch:</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-default-parameter="java" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6amF2YX0&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>Caused by: org.activiti.engine.ActivitiException: couldn't parse 'XXX.bpmn20.xml': Content is not allowed in prolog.
	at org.activiti.engine.impl.util.xml.Parse.execute(Parse.java:136)
	at org.activiti.engine.impl.bpmn.parser.BpmnParse.execute(BpmnParse.java:160)
	at org.activiti.engine.impl.bpmn.deployer.BpmnDeployer.deploy(BpmnDeployer.java:76)
	at org.activiti.engine.impl.db.DbRepositorySession.deploy(DbRepositorySession.java:65)
	at org.activiti.engine.impl.db.DbRepositorySession.resolveProcessDefinition(DbRepositorySession.java:195)
</pre></td></tr></table><h1>Beware of handling CLOB/BLOBS on postgres</h1><p>When handling CLOB and BLOB's on postgres, default CLOB MyBatis type cannot be used, BINARY should be used instead.</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-default-parameter="xml" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6eG1sfQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>&lt;result property="bytes" column="BYTES_" jdbcType="BINARY"/> 
</pre></td></tr></table><p>This exception occurs when type not handled properly</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-default-parameter="java" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6amF2YX0&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>## Error querying database.  Cause: org.postgresql.util.PSQLException: Bad value for type long : XXXXXXX
</pre></td></tr></table><p>*Be sure to check all statements that have postgres-specific counterparts (or any other DB) aren't referenced from within other mapped statements. These aren't aware of our database-specific bahaviour. Here you<br /> should create an postgres-specific statement for the statement using it. Eg. association-select for byte-array entity using selectByteArrayById_postgres: *</p><table class="wysiwyg-macro" data-macro-name="code" data-macro-default-parameter="xml" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2NvZGU6eG1sfQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>&lt;resultMap id="historicVariableUpdateResultMap" extends="historicDetailResultMap" type="org.activiti.engine.impl.history.HistoricVariableUpdateEntity">
    &lt;result property="name" column="NAME_" javaType="String" jdbcType="VARCHAR" />
    ...
    &lt;result property="longValue" column="LONG_" jdbcType="BIGINT" />
    &lt;association property="byteArrayValue" 
                 column="BYTEARRAY_ID_" 
                 javaType="org.activiti.engine.impl.runtime.ByteArrayEntity" 
                 select="selectByteArrayById" />
&lt;/resultMap>
&lt;resultMap id="historicVariableUpdateResultMap_postgres" extends="historicDetailResultMap" type="org.activiti.engine.impl.history.HistoricVariableUpdateEntity">
    &lt;result property="name" column="NAME_" javaType="String" jdbcType="VARCHAR" />
    ....
    &lt;result property="longValue" column="LONG_" jdbcType="BIGINT" />
    &lt;association property="byteArrayValue" 
                 column="BYTEARRAY_ID_" 
                 javaType="org.activiti.engine.impl.runtime.ByteArrayEntity" 
                 select="selectByteArrayById_postgres" />
  &lt;/resultMap>
</pre></td></tr></table><h1>Tuning history</h1><p>If you're using history, it can be tuned by adding the following index (oracle dialect)</p><pre>create index ACT_IDX_HI_EXEC_ACT_ID on ACT_HI_ACTINST (EXECUTION_ID_, ACT_ID_)
  tablespace PRODF;</pre><p>If you think this index should be added to the installation scripts, vote for <a href="https://jira.codehaus.org/browse/ACT-1231">ACT-1231</a></p>