Hi,
I have a problem when I run my query if I use the database table name, I get the error that the table is not mapped. And if I use the Entity class I have a null pointer as you can see. This is my first update request, did I miss something? Thanks in advance :
My code :
String queryTrue = "";
String query2True = "";
String queryFalse = "";
String query2False = "";
Integer countUpdate = 0;
Integer countUpdate2 = 0;
// Requete SQL
queryTrue =
String.format(
"UPDATE Project SET archived = true WHERE Project.contractE = :idContrat");
queryFalse =
String.format(
"UPDATE Project SET archived = false WHERE Project.contractE = :idContrat");
if (etatArchive) {
javax.persistence.Query q = JPA.em().createQuery(queryTrue);
q.setParameter("idContrat", idContrat);
countUpdate = q.executeUpdate();
} else {
javax.persistence.Query q = JPA.em().createQuery(queryFalse);
q.setParameter("idContrat", idContrat);
countUpdate = q.executeUpdate();
}
My Error :
2022-06-16 21:31:22.132 ERROR 11532 --- [nio-8080-exec-5] com.axelor.meta.ActionHandler : null
java.lang.reflect.InvocationTargetException: null
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.axelor.meta.ActionHandler.call(ActionHandler.java:256)
at com.axelor.meta.schema.actions.ActionMethod.evaluate(ActionMethod.java:76)
at com.axelor.meta.schema.actions.Action.execute(Action.java:100)
at com.axelor.meta.schema.actions.Action.wrap(Action.java:109)
at com.axelor.meta.schema.actions.ActionGroup.evaluate(ActionGroup.java:231)
at com.axelor.meta.schema.actions.Action.execute(Action.java:96)
at com.axelor.meta.schema.actions.Action.wrap(Action.java:109)
at com.axelor.meta.ActionHandler.execute(ActionHandler.java:524)
at com.axelor.meta.ActionExecutor.execute(ActionExecutor.java:57)