On 2010-04-01, at 12:07 AM, Cheong Hee wrote:

> Is there any pointers or sample code how these could be done to initiate 
> connection and save changes in respective ec?

You don't need multiple ec's unless you want them. Other than that it's 
transparent.
        
        EOEditingContext ec = ERXEC.newEditingContext();
        Person p = (Person)EOUtitlites.createAndInsertInstance(ec, 
Person.ENTITY_NAME); // Person entity persists in database A
        Horse h = (Horse)EOUtitlites.createAndInsertInstance(ec, 
Horse.ENTITY_NAME); // Horse entity persists in database B
        // make chagnes to h and p
        ec.saveChanges(); // p saved to database A, h saved to database B

You can model cross database relationships as long as you don't try and create 
a fetch based on them.

> 
> Cheers
> 
> Cheong Hee
> 
> ----- Original Message ----- From: "Mark Ritchie" <[email protected]>
> To: "James Cicenia" <[email protected]>
> Cc: "WO Dev Group" <[email protected]>
> Sent: Thursday, April 01, 2010 1:05 AM
> Subject: Re: two different databases at same time?
> 
> 
>> On 31/Mar/2010, at 8:15 AM, James Cicenia wrote:
>>> Is it possible to use two different databases, I guess via two different 
>>> models?
>>> I will need to connect to an Oracle big database on a remote server and was
>>> wondering if I could also use a mySQL or postgres database for user control
>>> on local server.
>> 
>> Yes, yes!  You can have multiple concurrent connections!  One for each 
>> EOModel!
>> Just make sure that the entity names are unique across all EOModels!
>> Good luck!
>> M.
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list      ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/chng34%40gmail.com
>> 
>> This email sent to [email protected] 
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/dleber_wodev%40codeferous.com
> 
> This email sent to [email protected]

;david

--
David LeBer
Codeferous Software
'co-def-er-ous' adj. Literally 'code-bearing'
site:   http://codeferous.com
blog:   http://davidleber.net
profile:        http://www.linkedin.com/in/davidleber
twitter:        http://twitter.com/rebeld
--
Toronto Area Cocoa / WebObjects developers group:
http://tacow.org




 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to