[Cayenne-user] select over PKs

	Sheldon
	Apr 2, 2012 at 7:49 am

If I specify a pageSize than I get any PK of objects.
I want, that I know a list of PKs and get their Objects.

Sheldon

--
View this message in context: http://cayenne.195.n3.nabble.com/select-over-PKs-tp3870305p3876993.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Search Discussions

Michael Gentry: Hi Sheldon, I guess I don't understand why you can't specify a page size (say 100 or 1000) on your query (unless you are getting the list of PKs from an external source), especially since you want actual Java objects in the end. mrg

Follow ups

Aristedes Maniatis: I suspect that the suggestion here is to think about using Cayenne in a different way. What you are trying to do often suggests that you are working against the ORM rather than with it. Of course it is certainly possible you have a legitimate use for this approach, but often when people ask this question the answer is "Think about how you got that list of PKs in the first place and what you are wanting to do with them. Instead of passing PKs around your application, just use objects that these
Gilbertoca: Sheldon wrote You can add a NamedQuery[1] in the modeler, for example: Then [2]: /** * Test of Vehicle.findInLicensePlate named query. */ @Test public void findInLicensePlate() { System.out.println("\nGetting an Vehicle IN Vehicle.findInLicensePlate.\n"); //JPA-->Query query = em.createNamedQuery("Vehicle.findInLicensePlate"); //JPA-->query.setParameter("licensePlate", new String[]{"LC101","LC102"}); //JPA-->int size = query.getResultList().size(); ObjectContext context = runtime.getContext()

Discussion Navigation

view	thread \| post
posts	‹ prev \| 8 of 10 \| next ›

Discussion Overview

font	variable	Hotkey: f
user style	avatars	Hotkey: a