Home » Search

About setParameter

31-40 of 94Refresh
Forum
3

Possible issue with timestamps

, 0, 0);         query.setParameter("startdate", startDate);         Calendar endDate = new GregorianCalendar(2012, Calendar.MARCH, 29, 1, 0);         query.setParameter("enddate", endDate ... , 29, 11, 0);         query.setParameter("startdate", startDate);         endDate = new
Issue
3

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 ... :     Query backupQuery = em.createQuery("objectdb backup"); backupQuery.setParameter("target
Forum
3

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
Forum
2

"where in" query

FROM MyEntity e WHERE e.name MEMBER OF :names");         query.setParameter("names", Arrays.asList ... ", Prez.class); prezs.setParameter("ids", Arrays ... OF :ids", Prez.class);         prezs.setParameter("ids", Arrays.asList(1L,3L));         List
Forum
2

Error 363 - Failed to read value of inverse relationship

WHERE upper(p.playerName) = upper(:name)", Player.class); return query.setParameter ... )", Player.class);             return query.setParameter("name", name).getSingleResult ... ); //            return query.setParameter("name", playerName).getResultList(); //        } //        catch
Forum
2

Geospatial functions

);         List resultList = query             .setParameter("latitude", location.getLatitude())             .setParameter("longitude", location.getLongitude())             .setParameter("radius
Forum
2

Problem of query With an aggregate function

')"); listClassRepHost.setParameter("host",choix.getHost() ); listClassRepHost.setParameter("startDate", convert.convertDateTime(choix.getStartdate()) ); listClassRepHost.setParameter("endDate
Forum
2

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
Issue
2

Update query bug

"); query.setParameter("code", personalCode); List> list = query.getResultList ... SET p.transports = :list WHERE p.personalCode = :code", Person.class); query2.setParameter("list", list); query2.setParameter("code", personalCode); query2.executeUpdate
Forum
2

JPA - ExceptionInInitializerError when creating EntityManager

).setMaxResults(1); EmailSettings smtp, port, from; smtp = emailSettings.setParameter("name", "SMTP").getSingleResult(); port = emailSettings.setParameter("name", "Port").getSingleResult(); from = emailSettings.setParameter("name", "EMAILFROM").getSingleResult