How to use #result with extended enumerations in SQLTemplate?

2009-06-18 Thread Michael Shea
Hi guys, I'm trying to use a SQLTemplate to retrieve some objects from my database. The objects in question use an ExtendedEnumeration object to map from integers to an enum. eg: public enum TaskType implements ExtendedEnumeration { TYPE_1( 1), TYPE_2(2), ... ... public Object g

DbLoader incompatible SQLite and lowercase-named tables?

2009-06-18 Thread Scott Anderson
I'm using 3.0M6 with SQLite v056. In DBLoader.java, line 408, the loader is trying to check if the table is named correctly using String.equals(), but the SQLite metadata is returning the table name in uppercase, and it's defined in the map in lowercase. Can equals() be replaced with equalsIgno

Re: Cayenne Fetch Limit behaviour ?

2009-06-18 Thread Michael Gentry
Well ... welcome back. :-) On Thu, Jun 18, 2009 at 7:18 AM, Malcolm Edgar wrote: > I think I forgot. > > regards Malcolm

Re: Foreign key constraint problem.

2009-06-18 Thread Michael Shea
I've actually already tried using a non-meaningful primary key, but I still want to have a unique constraint on the columns in question if I do that, because it should not be possible to have an Email assigned to the same Task twice Doing it with a unique constraint results in the same prob

Re: Object Validation Auto Increment Problem

2009-06-18 Thread Michael Gentry
I'm going to take a guess that the isMandatory="true" is firing first before the PK is generated and assigned. Try turning that off and see if it works. Cayenne should know that PKs are mandatory, anyway. mrg On Wed, Jun 17, 2009 at 5:17 PM, Mark Fraser wrote: > Hello, > > I am using Cayenne 2

Re: Cayenne Fetch Limit behaviour ?

2009-06-18 Thread Malcolm Edgar
I think I forgot. regards Malcolm On Thu, Jun 18, 2009 at 8:35 PM, Andrus Adamchik wrote: > Hi Malcolm, > > you are a committer :-). Nothing wrong with asking for a patch review, but > at the end you can just commit it yourself. > > Btw, we do have generic tests for fetch limit, you just need to

Re: Cayenne Fetch Limit behaviour ?

2009-06-18 Thread Andrus Adamchik
Hi Malcolm, you are a committer :-). Nothing wrong with asking for a patch review, but at the end you can just commit it yourself. Btw, we do have generic tests for fetch limit, you just need to run them against SQLServer: http://cayenne.apache.org/running-unit-tests.html Andrus On Jun

Re: Cayenne Fetch Limit behaviour ?

2009-06-18 Thread Malcolm Edgar
Hi Robert, JIRA and patch below. This does not include an automated unit test, however we have been testing it successfully on our servers. https://issues.apache.org/jira/browse/CAY-1244 regards Malcolm Edgar On Wed, Jun 17, 2009 at 12:20 PM, Robert Zeigler wrote: > setFetchLimit has been aroun