topic Long string stored as serialised byte array in Alfresco Archive

Long string stored as serialised byte array

kethur — Wed, 30 Oct 2013 09:06:36 GMT

Hi,in my workflow i have a long string (around 1000 characters) and when i use the below statement it stores the value in ge_byte_array table. I really need to read this value using HQL query in my java code.execution.setVariable("", "Long string with some special characters");Why is it storing a s

Re: Long string stored as serialised byte array

trademak — Thu, 31 Oct 2013 09:03:56 GMT

Can you post the code you are actually using? Are you sure it's a string?

Best regards,

Re: Long string stored as serialised byte array

kethur — Thu, 31 Oct 2013 10:37:36 GMT

Yes, its a string in a groovy script task.
<code>
      def details = "User Id:${userId}; Actioned by = ${actionedBy}; Role:${matchRole}; Access Right: ${accessRole}; Group:${groupId}; Request Type:${requestTypeM}; Priority:${priorityM}; <br>Reason Text:${reasonM};Request#:${workflowItemId.minus('_TEMP')}; ";
      execution.setVariable("recDetails", details);
</code>

recDetails is the one that is stored in GE_BYTE_ARRAY.

Re: Long string stored as serialised byte array

trademak — Tue, 05 Nov 2013 13:36:49 GMT

Okay, could you create a unit test for this and attach it to a JIRA?

Thanks,

Re: Long string stored as serialised byte array

kethur — Wed, 06 Nov 2013 22:46:03 GMT

I have figured out that the string i am defining has other variables concatinated to it. That makes my string a GString object. Hence thats stored as byte array. to avoid this i had to use toString method on Gstring object which returns a string in groovy.

Raj