Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: two different databases at same time?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: two different databases at same time?

Subject: Re: two different databases at same time?
From: "Cheong Hee" <email@hidden>
Date: Fri, 2 Apr 2010 11:17:27 +0800

Apparently I have complicated it by thinking of using multi ec to handle respective database connections. Thanks for clarification..

Cheers

Cheong Hee

----- Original Message ----- From: "David LeBer" <email@hidden> To: "Cheong Hee" <email@hidden> Cc: "WO Dev Group" <email@hidden> Sent: Thursday, April 01, 2010 8:23 PM Subject: Re: two different databases at same time?

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 References: >Re: two different databases at same time? (From: David LeBer <email@hidden>) Prev by Date: Re: Are you using scala + webobjects ? Next by Date: Re: Can an entity be promoted in single table inheritance? Previous by thread: Re: two different databases at same time? Next by thread: Re: Snapshots mysteriously vanishing? Index(es): Date Thread