Re: two different databases at same time?
Re: two different databases at same time?
- Subject: Re: two different databases at same time?
- From: David LeBer <email@hidden>
- Date: Thu, 1 Apr 2010 08:23:39 -0400
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@hidden>
> To: "James Cicenia" <email@hidden>
> Cc: "WO Dev Group" <email@hidden>
> 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@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
;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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden