Re: dbentity attribute catalog/schema

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed May 06 2009 - 09:03:41 EDT

  • Next message: Borut Bolčina: "Re: dbentity attribute catalog/schema"

    "Catalog" and "schema" are interpreted by Cayenne the way JDBC does
    it, i.e. as an abstracted concept of a DB namespace. Each individual
    DB may have different terms for them (or may not even support either
    of them at all).

    "Catalog" has really no significance to Cayenne, so it can be deleted
    safely from the mapping. "Schema" is a different beast (a different
    level of namcespacipng), and may be important in some cases. Cayenne
    will prefix all table names with schema in the queries. E.g.: "select
    * from myschema.mytable". So just changing catalog to schema is
    probably not what you want.

    If no explicit schema is specified, and you application works, I guess
    just keep it this way.

    Andrus

    On May 6, 2009, at 8:44 AM, Borut Bolčina wrote:

    > Hi,
    >
    > I am looking at my mapping file which was initially developed with
    > 3.0M4. I am seeing some dbentity elements having an attribute
    > 'catalog'. Can I remove them by hand and is this attribute now
    > replaced with 'schema'? I am using M5, Cayenne, not the BMW :-)
    >
    > Thanks,
    > Borut
    >



    This archive was generated by hypermail 2.0.0 : Wed May 06 2009 - 09:04:13 EDT