13 | New to Product & Having An Issue.createNamedQuery("Department.findByPK", Department.class); q.setParameter("id ... .setParameter("aid", this.departmentId.getAccountId()); q.setParameter("oid", this.departmentId ... = em.createNamedQuery("Department.findByPK", Department.class); q.setParameter("id |
13 | Query results are not up to date for entities, not primitives" + " WHERE person.personID == :personID") .setParameter( "personCode", personData .getPersonCode()) .setParameter( "personName", personData .getPersonName()) .setParameter( "personEmail", personData .getPersonEmail()) .setParameter( "personID |
13 | JPA JPQL WHERE clause for IN :variable not working if variable is a list of Enums: public enum MyEnumType { VALUE1, VALUE2, VALUE3, VALUE4 } and I call: query.setParameter ... ) OR (enumField = :enumField2)" with: query.setParameter("enumField1", MyEnumType.VALUE1); query.setParameter("enumField2", MyEnumType.VALUE2); Then the matching objects are returned. I |
11 | JPA - ExceptionInInitializerError when creating EntityManager(1); EmailSettings smtp, port, from; smtp = emailSettings.setParameter("name", "SMTP").getSingleResult(); port = emailSettings.setParameter("name", "Port").getSingleResult(); from = emailSettings.setParameter("name", "EMAILFROM").getSingleResult |
11 | "where in" query.setParameter("names", Arrays.asList("a", "c")); List resultList = query.getResultList ... .class); prezs.setParameter("ids", Arrays.asList(1,3)); results = prezs.getResultList(); (Prez ... .setParameter("ids", Arrays.asList(1L,3L)); List results = prezs.getResultList |
11 | Strange behaviour with ORDER BY and IN Location l where l.id IN :ids order by l.id desc", Location.class) .setParameter("ids ... ) .setParameter("towns", locations.stream().map(l -> l.getTown()).collect(Collectors.toList ... ", Location.class) .setParameter("towns", locations.stream().map(l -> l.getTown |
11 | Error 363 - Failed to read value of inverse relationship(p.playerName) = upper(:name)", Player.class); return query.setParameter("name", name ... .playerName) = upper(:name)", Player.class); return query.setParameter("name", name ... ", Message.class); // return query.setParameter("name", playerName).getResultList |
11 | Problem of query With an aggregate function')"); listClassRepHost.setParameter("host",choix.getHost() ); listClassRepHost.setParameter("startDate", convert.convertDateTime(choix.getStartdate()) ); listClassRepHost.setParameter("endDate |
11 | Geospatial functions", Location.class); List<Location> resultList = query .setParameter("latitude", location.getLatitude()) .setParameter("longitude", location.getLongitude()) .setParameter("radius", radius) .getResultList(); System.out.println |
2 | user defined backup file: backupQuery.setParameter("targetfile", new java.io.File("/User/Backup/test.objectdb ... .setParameter("targetdir", new java.io.File("/User/Backup/")); wich should create a backupfile ... .setParameter("target", "/User"); backupQuery.setParameter("name", "Backup"); backupQuery |
