Named parameter in query

Hi all,

Still discovering Bonita and I got stuck into a small problem. I am trying to update a specific line of my bdm. I have been building my app getting ideas from the “Modify Pending Vacation Request process” of the vacation management example .

org.hibernate.QueryException: Not all named parameters have been set: [persistenceId] [SELECT c
FROM Cases c
WHERE c.persistenceId= :persistenceId
]

Do I miss anything?

Using Bonita 7.4.2 and happily provide you more information upon request.

Ok, problem solved.
My business variable was just not using the right bdm.

How exactly did you resolve the problem? I’m in the same situation and there’s no more than 1 BDM.

Regards,

Hi Edouard, thanks for your reply… anyway, i already fix this issue about two days ago, you are right about the lack of understanding in Bonita and BDM interaction, in my case the solution was completely diferent as yours. I understand that this is not on your interest but i know that someone else will try to find this issue fix later, so… this is how i fix the problem.

1- I have only 1 BDM Object, and 4 processes
2- The process to create a new registry was perfect… but modify or delete the same registry was the problem because it create a new one taking the same data that below one.
3- So, how to point the old registry was an issue. Finally i realice that in the data apart → Process Variables → Business Variables, select the Business Variable and edit the Groovy instruction to point and persistence ID, again taken from selection grid (Like vacation request example).
4- And this is it, with the right registry selected, then i create an operation to delete (Is deteled) or modify (take the value), and make sure the value is taken in the contract.

The Groovy script i use was the default generated to enumerate from persistenceID

SELECT r
FROM “YourBDMNameHere” r
WHERE r.persistenceId= :persistenceId

how exactly did you resolve this issue? I’m in the same situation an only have 1 BDM… also using the Vacation Request Example avaible in the Bonita Community.

Regards,

:slight_smile: :slight_smile: :slight_smile:

Sorry Alvaro, I gave up with Bonitasoft almost a year ago (professional reasons) and don’t remember much of it.
I remember that this issue was due to my lack of understanding of bonitasoft and bdm. Try checking all the steps of the creation of a bdm again.