Re: Cayenne vs EOF: How to questions?

From: Dov Rosenberg (dov.rosenber..onviveon.com)
Date: Thu Feb 10 2005 - 22:37:22 EST

  • Next message: Mike Kienenberger: "Re: Cayenne vs EOF: How to questions?"

    I assume then the DBAdaptor gets chosen at runtime or does it have to
    manually configured? I guess either way that is a good fit for the way we
    deal with prototypes.

    Is there anyway to store or model indexes for a database in cayenne? That
    always bugged me with EOF that I could model the tables and relationships
    but would have to manually recreate all of the indexes for every db we
    supported. It would be nice to store that info with the source code.

    Thanks again 

    -- 
Dov Rosenberg
Conviveon Corporation
http://www.conviveon.com

    On 2/10/05 8:50 PM, "Andrus Adamchik" <andru..bjectstyle.org> wrote:

    > 
> On Feb 10, 2005, at 5:52 PM, Dov Rosenberg wrote:
> 
>> 2.   I understand that Cayenne does not currently support
>> EOPrototypes to make it easier to switch between databases, what is
>> the Cayenne preferred method for supporting multiple databases?
> 
> Unlike EOF Cayenne uses datatypes defined in the JDBC standard for DB
> columns mapping - so to switch from Oracle to Sybase you need to change
> ... umm ... exactly nothing - can't be any easier than that ;-)
> 
> The only time when proprietary DB types come to play is when you want
> to use modeler to generate DB schema (so runtime is not affected)...
> Still this is addressed by mapping JDBC types to DB types in a
> types.xml file that is shipped with each Cayenne DbAdapter. You can
> modify this file if you want to, but no changes in your custom mapping
> (DataMap) will be needed. I think that's cleaner than EOF.
> 
> Andrus
>

    This archive was generated by hypermail 2.0.0 : Thu Feb 10 2005 - 22:37:26 EST