These are in the same EOEditingContext transaction, but they're not in a single database transaction ... EOF does not (currently) use JTA across connections in multiple databases.
ms On Jun 29, 2010, at 11:12 PM, Farrukh Ijaz wrote: > On 2010-06-30, at 5:56 AM, Andrew Lindesay wrote: > >> Hello; >> >> I have 5-6 models in an application. Thus far this has worked out fine >> because many database servers were employed and a socket or two to each was >> not a problem. Now the database servers have been consolidated and with >> each model requiring a database connection, the number of connections to one >> database server from all of the instances is actually quite large! >> >> I have been reading the java-doc for the JDBC*/EO* classes trying to get my >> head around how things work at the JDBC connection / transaction level. >> What I would like to do is to modify the "Table Name" in the models to be >> prefixed with the schema name and then to somehow see if I could use one >> connection and hence coalesce each transaction commit/rollback across all of >> the models. >> > > As far as I heard (may be wrong), it's possible to have EOModels connecting > to different databases. They have to fall under the same EOModelGroup only > then it can be treated under single transaction. (Correct me if I'm wrong). > > For each model, the jdbc connection properties can be setup individually. > > dbConnectURLGLOBAL > dbConnectUserGLOBAL > dbConnectPasswordGLOBAL > > I don't remember but I guess they are used like > > dbConnectURL.Model1 > dbConnectUser.Model1 > dbConnectPassword.Model1 > > Or something similar. Someone experienced out there can point out the exact > properties. > > Farrukh > >> My guess is that this concept is not how EOF works and I'm probably not >> going to be able to do it without also coalescing the models together. >> >> Has anybody any insights? >> >> cheers. >> >> ___ >> Andrew Lindesay >> www.silvereye.co.nz >> >> _______________________________________________ >> 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/farrukh.ijaz%40fuegodigitalmedia.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/mschrag%40pobox.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/archive%40mail-archive.com This email sent to [email protected]
