Re: Switching DB at runtime?
Re: Switching DB at runtime?
- Subject: Re: Switching DB at runtime?
- From: Farrukh Ijaz <email@hidden>
- Date: Wed, 7 Jul 2010 15:11:07 +0300
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 <email@hidden> 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
>> <email@hidden> 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 (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
>
> --
> 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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden