Re: Selecting against postgres sequence

2014-01-08 Thread Rick Bonnett
Thanks Mike, that did the trick On Jan 8, 2014, at 3:13 PM, Mike Kienenberger wrote: > Well, it's trying to convert your returned sequence result into an > EdiProfile object. Is that compatible? It might make more sense to > read the sequence as a data row -- setFetchingDataRows(true); > > H

Re: Selecting against postgres sequence

2014-01-08 Thread Mike Kienenberger
Well, it's trying to convert your returned sequence result into an EdiProfile object. Is that compatible? It might make more sense to read the sequence as a data row -- setFetchingDataRows(true); Here's code I used to fetch a sequence number (from an old Cayenne 2.0 project, so some things may

Selecting against postgres sequence

2014-01-08 Thread Rick Bonnett
I’m trying to directly fetch the nextval form a postgres sequence using Cayenne, and am baffled but why I am getting nothing back. I’m using SqlTemplate to build my query, since the modeler does;t seem to let me model a sequence DB object directly. Code snippets: 1) using performQuery SQLTempl