java - JPA Select Query with composite primary key leads an exception -


i have tried below code getting single notificationsubtype object. finding exception " org.apache.openjpa.persistence.argumentexception: encountered "from" @ character 1, expected: ["delete", "select", "update"]."

please me on given problem. code given below : ... ...

try {      query query = this.em.createquery("from notificationsubtype conc conc.id.alerttyc = ?1 , conc.id.alertsubtyc = ?2");      query.setparameter(1, "mpprint");     query.setparameter(2, "rein");      notificationsubtype trackidreslst = (notificationsubtype)query.getsingleresult();      if (null != trackidreslst) {         system.out.println("true");     } else{         system.out.println("false");     }    } catch (exception e) {     notificationlogger.errorwiththrowable(e);     throw new notificationserviceexception(e.getmessage()); } 

...

why not read exception? , read jpa spec ?

jpql statements have start select, update or delete. other illegal (and yours starts from reason). put select , candidate alias in front of more chance of success

yes hibernate bastardises jpql standard hql (which allows omit select plus alias) using openjpa need use jpa compliant queries, , besides practice when using hibernate obey standard!


Comments