4 Replies Latest reply on Jul 13, 2007 10:59 AM by Johan Parent

    Selecting non-string valued variable instances

    Peter Brewer Novice

      I'm using Hibernate 3.2.2 and jBPM 3.1.4 in a Seam 1.2.1GA environment.

      I have a problem with a query that should return VariableInstance entities based on a particular name and value. The variable instance is actually an instance of org.jbpm.context.exe.variableinstance.LongInstance.

      The following query returns lots of rows and one of these results shows the value as 1654.

      SELECT
       vi
      FROM
       org.jbpm.context.exe.VariableInstance vi
      WHERE
       vi.name = 'memberId'
      

      However, when I then run the following query, no results are returned.
      SELECT
       vi
      FROM
       org.jbpm.context.exe.VariableInstance vi
      WHERE
       vi.name = 'memberId'
      AND
       vi.value = 1654
      


      How can I select a variable instance based on a long value? Any hints or suggestions would be greatly appreciated, as I really have run out of ideas!

      Thanks in advance, Pete.