Re: Multiple Database

From: Sami Mohammed (SMOHAMME..ndependenthealth.com)
Date: Thu Apr 28 2005 - 14:53:31 EDT

  • Next message: Mike Kienenberger: "Reattaching a serialized DataObject to a DataContext"

    Hi mike

    Thank you. i will try first with different nodes with single domain. if
    it wont work i will go for muliple domains.

    Thanks
    sami

    CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may
    contain confidential information which is privileged and protected from
    disclosure by Federal and State
    confidentiality laws rules and regulations. This e-mail and
    attachments, if any, are intended for the designated addressee only. If
    you are not the designated addressee, you
    are hereby notified that any disclosure, copying, or distribution of
    this e-mail and its attachments, if any, may be unlawful and may subject
    you to legal consequences. If you
    have received this e-mail and attachments in error, please contact
    Independent Health immediately at (716) 631-3001 and delete the e-mail
    and its attachments from your
    computer. Thank you for your attention

    >>> mkienen..laska.net 04/28/05 02:39PM >>>
    Sami Mohammed <SMOHAMME..ndependenthealth.com> wrote:
    > can one answer the query below?

    I don't know the answer, and since no one else has commented, I'd
    suggest go
    ahead and try doing it that way.

    It'll either work or not. If, not, then make multiple Domains by
    moving
    your DataNodes and DataMaps around.

    -Mike

    > I am using multiple databases at the same time in single
    application.
    >
    > i am creating multiple dataNodes under one domain name
    (STESTMultipleDataBase)
    >
    > with different DataMaps (map location ="STESTOracleMap.map.xml", map
    name
    ="STESTMapSqlserver.map.xml" ),
    >
    > and differnet DataNodes (STESTOracleNode,"STESTSqlServerNode)
    >
    > is it correct to create muliple DataMaps under one domain name with

    muliple DataNodes ?
    >
    >
    > see my cayenne file below
    >
    > <?xml version="1.0" encoding="utf-8"?>
    > <domains project-version="1.1">
    > <domain name="STESTMultipleDataBase">
    > <map name="STESTOracleMap" location="STESTOracleMap.map.xml"/>
    > <map name="STESTMapSqlserver"
    location="STESTMapSqlserver.map.xml"/>
    >
    > <node name="STESTOracleNode"
    > datasource="jdbc/EDWDORACLE"
    >
    adapter="org.objectstyle.cayenne.dba.oracle.OracleAdapter"
    >
    factory="org.objectstyle.cayenne.conf.JNDIDataSourceFactory">
    > <map-ref name="STESTOracleMap"/>
    > </node>
    > <node name="STESTSqlServerNode"
    > datasource="jdbc/EDWDSQLSERVER"
    >
    adapter="org.objectstyle.cayenne.dba.sqlserver.SQLServerAdapter"
    >
    factory="org.objectstyle.cayenne.conf.JNDIDataSourceFactory">
    > <map-ref name="STESTMapSqlserver"/>
    > </node>
    > </domain>
    > </domains>
    >
    > Thanks
    > sami
    >
    >
    > CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may
    contain
    confidential information which is privileged and protected from
    disclosure
    by Federal and State
    > confidentiality laws rules and regulations. This e-mail and
    attachments,
    if any, are intended for the designated addressee only. If you are not
    the
    designated addressee, you
    > are hereby notified that any disclosure, copying, or distribution of
    this
    e-mail and its attachments, if any, may be unlawful and may subject you
    to
    legal consequences. If you
    > have received this e-mail and attachments in error, please contact
    Independent Health immediately at (716) 631-3001 and delete the e-mail
    and
    its attachments from your
    > computer. Thank you for your attention
    >



    This archive was generated by hypermail 2.0.0 : Thu Apr 28 2005 - 14:53:50 EDT