Re: Multiple Models, Coalesced Transactions - is it possible?
Hi Mike; Whatever I'm doing works with that so don't worry about those keys -- thanks again. Regards; > If it's easy for you to take a quick look for me and let me know then that > would be really great thanks -- just so I know. .. >> It's not strictly .equals, but if they are .equals that's good enough ... >> there are a handful of keys that JDBCPlugIn cares about (url, username, >> couple others -- i can look them up if you really care) that determine when >> you get a new eodatabasecontext. ___ Andrew Lindesay www.silvereye.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
EOF currently doesn't do any 2PC. ms On Jun 29, 2010, at 11:28 PM, Karl wrote: > Does WO / EOF implement its own form of TPC or is it a case of buyer-be-aware > / technology stack dependent? > > Karl > > On 2010-06-29, at 11:26 PM, Mike Schrag wrote: > >> 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com This email sent to farrukh.i...@fuegodigitalmedia.com >>> >>> ___ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com >>> >>> This email sent to msch...@pobox.com >> >> ___ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com >> >> This email sent to kgret...@mac.com > ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
Does WO / EOF implement its own form of TPC or is it a case of buyer-be-aware / technology stack dependent? Karl On 2010-06-29, at 11:26 PM, Mike Schrag wrote: > 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 (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com >>> >>> This email sent to farrukh.i...@fuegodigitalmedia.com >> >> ___ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com >> >> This email sent to msch...@pobox.com > > ___ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/kgretton%40mac.com > > This email sent to kgret...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
Hi Mike; If it's easy for you to take a quick look for me and let me know then that would be really great thanks -- just so I know. cheers. > It's not strictly .equals, but if they are .equals that's good enough ... > there are a handful of keys that JDBCPlugIn cares about (url, username, > couple others -- i can look them up if you really care) that determine when > you get a new eodatabasecontext. ___ Andrew Lindesay www.silvereye.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
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 (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com >> >> This email sent to farrukh.i...@fuegodigitalmedia.com > > ___ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com > > This email sent to msch...@pobox.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
It's not strictly .equals, but if they are .equals that's good enough ... there are a handful of keys that JDBCPlugIn cares about (url, username, couple others -- i can look them up if you really care) that determine when you get a new eodatabasecontext. ms On Jun 29, 2010, at 11:19 PM, Andrew Lindesay wrote: > Hi Chuck; > > Ah; that's the key piece of information –– if two models' connection > dictionaries are equals() then the same JDBC connection is used for the two > models. > > cheers. > >> Are these models using different logins and schemas? If not, they should >> all share the same connection if their connection dictionaries are >> .equals(). If they are all different, then EOF is going to want to consider >> them to be different. Putting the schema name in the table name and >> ensuring that the connection dictionaries are .equals() may work, I have >> never tried that. > > ___ > Andrew Lindesay > www.silvereye.co.nz > > ___ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com > > This email sent to msch...@pobox.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
Hi Chuck; Ah; that's the key piece of information –– if two models' connection dictionaries are equals() then the same JDBC connection is used for the two models. cheers. > Are these models using different logins and schemas? If not, they should all > share the same connection if their connection dictionaries are .equals(). If > they are all different, then EOF is going to want to consider them to be > different. Putting the schema name in the table name and ensuring that the > connection dictionaries are .equals() may work, I have never tried that. ___ Andrew Lindesay www.silvereye.co.nz ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
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 (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com > > This email sent to farrukh.i...@fuegodigitalmedia.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: Multiple Models, Coalesced Transactions - is it possible?
On Jun 29, 2010, at 7:56 PM, 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. > > 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? Are these models using different logins and schemas? If not, they should all share the same connection if their connection dictionaries are .equals(). If they are all different, then EOF is going to want to consider them to be different. Putting the schema name in the table name and ensuring that the connection dictionaries are .equals() may work, I have never tried that. Chuck -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects smime.p7s Description: S/MIME cryptographic signature ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Multiple Models, Coalesced Transactions - is it possible?
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. 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com