[jboss-user] [JBoss jBPM] - Selecting non-string valued variable instances

[pbrewer_uk]

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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4063141#4063141

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4063141