Re: missing links in 1.2 documentation

2007-06-06 Thread Aristedes Maniatis
On 07/06/2007, at 12:45 AM, Peter Schröder wrote: there are several pages which dont have direct links to child- articles: Because this is a manual process, those links haven't been added to the 1.2 pages. But if you are able to use the version 2 docs, they are all there. The docs are ide

Re: Cayenne web application tutorial

2007-06-06 Thread Robert Zeigler
Sorry for the delayed response... My basic thought for the "SecurityManager" idea was: gee, wouldn't it be nice if any time a dataobject was "unsqueezed", I could call into a service that would look at the object, the current user, and the request context, and figure out if the user has per

Re: Remove Foreign Keys Mapped as Object Attributes

2007-06-06 Thread Mike Kienenberger
Yes, you generally want to do this. It means that you are going to let Cayenne manage the foreign and primary keys for the entities involved. Then, instead of having to deal with table2.setFk2pk1Field(Table1.somehowGetPrimaryKeyWhichMightNotBeComputedYet()) all you need to do is table2.set

Remove Foreign Keys Mapped as Object Attributes

2007-06-06 Thread Fredrik Liden
When I synch the dbentity with the object I get the following prompt: "Remove foreign keys mapped as Object Attributes." Could someone explain what this one does? What are the pros and cons of removing the foreign keys? This is a 1-many relationship. Table 1 Pk1 Field1 Table 2 Pk2 Field2 Fk2_p

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Michael Gentry
It's not a hijacking. It is interesting to point out that JPA does not support tables without PKs -- I really should learn more about JPA soon. I can understand why, too (need to know what to update and how to make joins, etc). I'm kind of curious if Cayenne supports PK-less for read-only data

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Michael Gentry
We have a group here doing updates through views (with Oracle, at least), so that is still a valid practice. Also, Cayenne doesn't know if it is a view or an actual table. /dev/mrg On 6/6/07, Dave Merrin <[EMAIL PROTECTED]> wrote: Sorry, I forgot to mention againthese are views, not tabl

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Dave Merrin
Cheers, I'll give it a try. Dave Michael Gentry wrote: The only thing I can think of trying (and maybe Andrus/Tore/Mike/etc would have better ideas) is to model that ObjEntity (and perhaps others it relates to?) as read-only and see if Cayenne stops caring about missing a PK. Just a thought

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Dave Merrin
Sorry, I forgot to mention againthese are views, not tables. Dave Craig L Russell wrote: I don't want to hijack this thread, but just point out that JPA does not support tables without primary key; JDO does (including updates) as an optional feature. Craig On Jun 6, 2007, at 8:41 AM, Da

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Craig L Russell
I don't want to hijack this thread, but just point out that JPA does not support tables without primary key; JDO does (including updates) as an optional feature. Craig On Jun 6, 2007, at 8:41 AM, Dave Merrin wrote: Sorry, I forgot to mention that I won't be updating the data. I would like

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Michael Gentry
The only thing I can think of trying (and maybe Andrus/Tore/Mike/etc would have better ideas) is to model that ObjEntity (and perhaps others it relates to?) as read-only and see if Cayenne stops caring about missing a PK. Just a thought -- I've not tried it. /dev/mrg On 6/6/07, Dave Merrin <[E

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Dave Merrin
Sorry, I forgot to mention that I won't be updating the data. I would like to move round the database using relationships though. Apart from changing the database are there any hacks I could try to get round this problem. Cheers, Dave Michael Gentry wrote: Cayenne needs PKs in order to do U

Re: Select Query on Table with no Primary Key

2007-06-06 Thread Michael Gentry
Cayenne needs PKs in order to do UPDATEs. If you aren't modifying the data, you might try fetching as data rows instead of CayenneDataObjects. I'm not certain if that would work, but has a much higher chance. Of course, you still won't be able to make a CayenneDataObject out of it. /dev/mrg

missing links in 1.2 documentation

2007-06-06 Thread Peter Schröder
hi, there are several pages which dont have direct links to child-articles: f.e.: http://cayenne.apache.org/doc12/performance-tuning.html http://cayenne.apache.org/doc12/stored-procedures.html there are also some broken links: http://cayenne.apache.org/api/cayenne/org/objectstyle/cayenne/query/P

AW: Select Query on Table with no Primary Key

2007-06-06 Thread Peter Schröder
perhaps it helps to set fetchDataRows to true http://cayenne.apache.org/doc12/data-rows.html its just a guess -Ursprüngliche Nachricht- Von: Dave Merrin [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 6. Juni 2007 16:12 An: user@cayenne.apache.org Betreff: Select Query on Table with no P

Re: getter/setters for PKs in generated objects

2007-06-06 Thread Michael Lepine
Excellent. Thanks for the help. On 6/5/07, Michael Gentry <[EMAIL PROTECTED]> wrote: By default, the Modeler doesn't map the PK/FK attributes into the ObjEntity (the Java-class portion in the Modeler), but if you map the PK/FK attributes into the ObjEntity manually, it should "stick" and should

Select Query on Table with no Primary Key

2007-06-06 Thread Dave Merrin
Hi, I'm trying to run a SelectQuery on a table with no primary key. Unfortunately it's not working. Can anybody help? I have no control over the database so I can't add in primary keys. Cheers, Dave INFO QueryLogger: SELECT t0.ID, t0.KIND, t0.TIMESTAMP FROM MPS.STATETABLE_CPT t0 INFO Qu

[ann] Click Framework 1.3 released

2007-06-06 Thread Malcolm Edgar
Click Framework version 1.3 is now available This release includes: * a new PickList control, * changes to Page event execution order * improved logging * lots of bug fixes and minor improvements * new introduction documentation and examples Online examples are available at: http://www.avoka.co