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.
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 the problem? I'm in the same situation and there's no more than 1 BDM.
Regards,
Comments
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,