Thanks Guys for your suggestions. Chuck, I have various applications. Among their models, few entities are common. I need to connect to these applications and inspect the data of these common entities. If I implement Web Services infrastructure, I need to modify all my applications so they can provide interfacing for my inspection application. Another thing is I need to take care of the OSC to avoid locking issues if I implement web services. Third, they will over load the application for XML/JSON transformation and transportation. To avoid all this over head, I can simply do a remote DB connection and inspect the common entities. This application may reside on a different server running inside GlassFish container participating in a BPEL process where different events may trigger the application to establish connection to the remote db, do the inspection, prepare a report and dispatch email or log to server.
At one pirticular instance I can afford to discard the snapshots but I think this would be the easiest pattern. Thanks, Farrukh Sent from my iPad On 06-Jul-2010, at 10:57 PM, Chuck Hill <ch...@global-village.net> wrote: > > On Jul 6, 2010, at 12:52 PM, Greg Bartnick wrote: > >> Farrukh, >> >> Take a look at the setConnectionDictionary method of the >> com.webobjects.eoaccess.EOModel class. Using that you would be able >> to change the DB connection settings. Right now I can't remember if >> it will change an already connected db connection, but I know I use >> that on start up of my apps to override settings. > > It won't affect the current connections. You would need to close the > channels, and discard parts of the EOF stack. I think you would also lose > all the snapshots. I am not sure what would happen, but my guess is that > this is not intended and "bad things" would likely result. > > I am not sure what you are trying to achieve, but I would spend time thinking > of a different way rather than trying to make his work. > > Chuck > > > >> On Sat, Jul 3, 2010 at 1:25 AM, Farrukh Ijaz >> <farrukh.i...@fuegodigitalmedia.com> wrote: >>> Question! >>> >>> Is it possible to switch the DB settings of a running application using API >>> (not the properties file) and the application start using the new DB from >>> the next transaction. The DBs in this case are identicle in structure but >>> data may differ. >>> >>> Farrukh >>> >>> Sent from my iPad _______________________________________________ >>> 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/gbartnick%40gmail.com >>> >>> This email sent to gbartn...@gmail.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/chill%40global-village.net >> >> This email sent to ch...@global-village.net > > -- > 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 > > > > > > > _______________________________________________ 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
