Re: Database table column order

2011-11-07 Thread Michael Gentry
Hi Joel, Cayenne Modeler alphabetizes the column names for display, but databases can order them however they want. Usually it is the order you add the columns. Some databases, such as MySQL, allow you to specify where to add columns, though. However, this is kind of outside of what Cayenne Mod

Database table column order

2011-11-07 Thread Becker, Joel
Is there a way to specify the order of database table column order? It seems that the modeler always alphabetizes the db-attributes. (I'm using modeler v 3.0.2)

Re: Selecting relationships without restriction

2011-11-07 Thread Michael Gentry
Hi Christian, As others pointed out, getPrices() will return all of the prices. What I usually do for things like this is write a helper method to filter the historic ones out. Create a getCurrentPrices() which returns calls getPrices() and filters based upon historic = true and return a new list

Problem querying vertical inheritance

2011-11-07 Thread Mark Rigby-Jones
Hi all, I've used Cayenne on few projects, and I'm now attempting to use inheritance for the first time. Whilst the current scope is fairly limited, I'm expecting that the inheritance tree will grow considerably in the future and thus am trying to use some amount of vertical inheritance for sub