In my trigger un Role with all access , i have this code
var res = rbv_api.selectQuery("SELECT label_fr,label_en,id_message,id FROM applicationmessage Where id_message='M0000000003'", 1); rbv_api.println(res[0][1]);
when show log , rollbase make this error: (in french) :
"Error L'accès à la classe Java "com.ddtek.jdbc.openedgebase.ddx" est prohibé. (line #4) in formula:
var rbv_api = new Packages.com.rb.core.services.api.ServerSideAPI(1, 12002);
var res = rbv_api.selectQuery("SELECT label_fr,label_en,id_message,id FROM applicationmessage Where id_message='M0000000003'", 1);
rbv_api.println(res[0][1]);"
In English : Error Acess to java class "com.ddtek.jdbc.openedgebase.ddx" is prohibited.
I have you a idea?
Just to verify.
- so you have an On-Premises Private install.
- you are using the default install for the underlying storage database (I.e. OpenEdge)
What version of Rollbase is this? 2.2?=
Yes , i am on private cloud 2.2,
and on default storage database
It should work.
Do other rbv_api.selectQuery statements work,not is it only this one that fails. ? (Different table, or select different fields$=
If query USER , is ok, now is only this query fail.
I found , the error message appear if i ask label_fr value. the field label_fr is textarea. When i get value i have a exeception but when get value by rbv_api.getFieldValue('applicationmessage' ,id, 'label_fr'); i don't have exception
It's a bug ? i don't found in help for retreive text area field?
I hope you do not mind, but I edited the POST title to be more descriptive. Feel free to edit it again if you find my changes are not accurate.
My first glance at this suggests that yes, the behavior for this should not give this exception.
Oki i call progress hotline.
We should allow access to com.ddtek.jdbc.openedgebase classes. Will be fixed in the next release.