topic unable to get values from database in Alfresco Archive

unable to get values from database

vijayd — Wed, 05 Mar 2014 10:31:13 GMT

I am working with some code it was working. But after executing the application for 5-6 times it starts giving following Error :Mar 05, 2014 3:55:36 PM org.activiti.engine.impl.interceptor.CommandContext closeSEVERE: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceExceptio

Re: unable to get values from database

vijayd — Thu, 06 Mar 2014 07:22:13 GMT

I found why its giving an error i increase the size of column VALUE_ in table act_ge_property and its working fine, but the table will update after few executions. So it will give an error again. Is there any other option to deal with this error?

Re: unable to get values from database

vijayd — Fri, 07 Mar 2014 11:46:10 GMT

was it happening because I put two jar of activiti engine?

Re: unable to get values from database

frederikherema1 — Mon, 10 Mar 2014 09:31:42 GMT

If you're planning on using big strings as process-variables, consider storing them as a byte[] instead of a String. Alternatively, you can store it as a class that implements Serializable, eg:


public class LongString implements Serializable {
    protected String stringValue;

   getStringValue() …

   setStringValue(…) …
}

Storing as serializable OR byte[] will use a BLOB in the DB, having nearly unlimited size support

Re: unable to get values from database

vijayd — Mon, 10 Mar 2014 10:03:59 GMT

Thank You Frederik, For your reply. My problem was different but I got the solution.