Re: Generation of primary keys

2018-10-22 Thread Andrus Adamchik
If you don't set the adapter, Cayenne will auto-detect the DB type in runtime and install a proper adapter. Modeler doesn't do auto-detection, but the runtime does. In fact I don't remember when was the last time I had to specify an adapter explicitly. Andrus > On Oct 23, 2018, at 12:38 AM, T

Generation of primary keys

2018-10-22 Thread Tony Giaccone
I understand that the kind of PK support that Cayenne uses depends on the adaptor you use. When you use: org.apache.cayenne.dba.postgres.PostgresAdapter you get sequences, not the pk_auto table. I see where you can pick the adaptor as part of a database schema generation. What's less clear to me

Large Results sets..

2018-10-22 Thread Tony Giaccone
I asked this question once before, and I've looked but cant' find the answer. We're going to be using queries that would normally bring back large numbers of objects, 100's of thousand potentially. I know there's a facility in Cayenne to essentially use a "cursor" like fetch. But I can't remember