I tried another query

entityManager.createQuery("SELECT task.execution.variables from org.jbpm.api.task.Task task where index(task.execution.variables[0])='invoiceId' and task.execution.variables[0].l=23").getResultList()

Which gives me no results. That is expected because there is no varialbe with value 23

But when I changed the value to 16 it is giving me the following error. The value 16 is actually existing in the database. Can anyone help to correct this query?

Thanks

Thomas

Thank you very much for your reply.

I do not think it has anything to do with JPA. I tried the options you suggested but still did not work.

But now I changed my query a little but I am joining the task, with variables explicitly then it works.

Hi HuiSheng Xu,

Thank you very much for replying to my post.

The way in which it works is described below.

I added the jbpm mappings to my persistence.xml. Please see the configuration below. So that my persistence unit contains the jbpm tables also. So I can use jbpm objects along with my domain objects in JPA.

The query is given below

entityManager.createQuery("SELECT new com.imagitek.prodagioap.workflow.invoice.InvoiceTask(task, invoice) from org.jbpm.api.task.Task task, org.jbpm.pvm.internal.type.Variable var, com.imagitek.prodagioap.entity.ImInvoice invoice  where var.execution=task.execution and invoice.id=var.l").getResultList();

This works because I know my variable will be a long data type.

? Right now I have a separate jbpm.hibernate.cfg.xml which is supplied by jbpm4. I am using this configuration also. Ultimately I want to use only the JPA configuration for everything. I want to get rid of the jbpm.hibernate.cfg.xml file. While creating the process engine I was able to supply hibernateSessionFactory which is provided by jpa/seam to the process engine. Then I was able to get rid of the jbpm.hibernate.cfg.xml. but the problem was that no data was persisted to the database. But all the rules, events etc were getting fired. I assume I am missing some transaction related stuff. Can please tell me what are the things I need to do to persist the data.

Thanks & Regards

Thomas Victor

Hi,

I figured it out. I commented out the hibernate-configuration and hibernate-session-factory from the file jbpm.tx.jta.cfg.xml.

While creating the process engine I use the following code to get the session factory from entitymanager. It works fine.

Each time when I do some some operation that needs database persistence like start a workflow, signal a task etc. I need to add the entitymanager to the transaction. Then I am able to persist the data and it works.

entityManager.joinTransaction();

pi = super.startWorkflow("InvoiceProcessing", variables, workflowKey);

? Right now I extracted the hbpm.jar, then modified the bpm.tx.jta.cfg.xml then jarred it back. Is there any way to add the configuration on the jbpm.cfg.xml. I mean any way to leave the jar file as it is and do configurations out side?

Thank you very much for your reply. I will try that.