topic Type mismatches when querying executions with variables in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/type-mismatches-when-querying-executions-with-variables/m-p/195845#M148975 <HTML><HEAD></HEAD><BODY><SPAN>I found a behaviour that I may not classify as bug, but that creates quite a bit of headaches in certain situations.</SPAN><BR /><BR /><SPAN>The problem arises when querying (process) Executions and checking for specific variable values. Especially with all Number and relative primitive types.</SPAN><BR /><BR /><SPAN>Scenario is this:</SPAN><BR /><SPAN>- I start a process</SPAN><BR /><SPAN>- the process (in a service task) will set a certain variable (say "varName") to a Long (as in java.lang.Long) value of (say) 12345.</SPAN><BR /><SPAN>- later I receive an external "something" that requires me to pick the process(es) which have such varName variable with 12345 value.</SPAN><BR /><SPAN>-&gt; this "something" will actually be the result of a JSON deserialization into a generic Map (I can't use a value object as I should be flexible enough to work with value objects that may evolve and I don't want to/can't have hard dependencies to other systems in my software)</SPAN><BR /><BR /><SPAN>Now the problem: the JSON serializer (Jackson actually, but I think others may do the same), when not forced to match a particular type will choose the "right sized" java type based on the value received, like this</SPAN><BR /><SPAN>numbers &lt;= 2^31-1 –&gt; java.lang.Integer</SPAN><BR /><SPAN>numbers &gt;= 2^31&nbsp; –&gt; java.lang.Long</SPAN><BR /><SPAN>(think it may also use BigInteger when appropriate, and the same widening will happen with Float, Double and BigDecimal even though I haven't tested it)</SPAN><BR /><BR /><SPAN>I think you easily see when this is going.</SPAN><BR /><BR /><SPAN>When receiving such 12345 value, it will be Integer and ExecutionQueryBuilder.processVariableValueEquals("varName", 12345) will result in the lookup of an variable on the ACT_RU_VARIABLE with TYPE = "integer" and LONG = 12345, resulting in no process picked up.</SPAN><BR /><BR /><SPAN>As I was saying, this is not a bug, but a corner case behaviour, that requires some choices (we "banned" the use of Integers and Floats on&nbsp; execution.setVariable()).</SPAN><BR /><BR /><SPAN>Point is that the ACT_RU_VARIABLE uses the same column (LONG) for Integer/Long and another (DOUBLE) for Float/Double, while having 4 different values for the TYPE column (integer, long, float, double), resulting in possible mismatches when these "uncontrollable conversions" happen.</SPAN><BR /><BR /><SPAN>Wouldn't it be simpler to use the same TYPE value for the couples Long/Integer and Float/Double (yes, it may screw up the unmarshalling) or else not checking the type for the numeric types?</SPAN></BODY></HTML> Thu, 14 Aug 2014 15:21:41 GMT lmollea 2014-08-14T15:21:41Z Type mismatches when querying executions with variables https://connect.hyland.com/t5/alfresco-archive/type-mismatches-when-querying-executions-with-variables/m-p/195845#M148975 I found a behaviour that I may not classify as bug, but that creates quite a bit of headaches in certain situations.The problem arises when querying (process) Executions and checking for specific variable values. Especially with all Number and relative primitive types.Scenario is this:- I start a pr Thu, 14 Aug 2014 15:21:41 GMT https://connect.hyland.com/t5/alfresco-archive/type-mismatches-when-querying-executions-with-variables/m-p/195845#M148975 lmollea 2014-08-14T15:21:41Z Re: Type mismatches when querying executions with variables https://connect.hyland.com/t5/alfresco-archive/type-mismatches-when-querying-executions-with-variables/m-p/195846#M148976 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>If you want to use "less" types, configure them in ProcessEngineConfiguration .</SPAN><BR /><SPAN>By default following types are used:</SPAN><BR /><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new NullType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new StringType(4000));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new LongStringType(4001));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new BooleanType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new ShortType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new IntegerType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new LongType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new DateType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new DoubleType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new UUIDType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new ByteArrayType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new SerializableType());<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new CustomObjectType("item", ItemInstance.class));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new CustomObjectType("message", MessageInstance.class))<BR /></CODE><BR /><SPAN>Regards</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Fri, 15 Aug 2014 05:31:58 GMT https://connect.hyland.com/t5/alfresco-archive/type-mismatches-when-querying-executions-with-variables/m-p/195846#M148976 martin_grofcik 2014-08-15T05:31:58Z