Re: JDBC URL on a per session basis
Re: JDBC URL on a per session basis
- Subject: Re: JDBC URL on a per session basis
- From: Ken Anderson <email@hidden>
- Date: Tue, 17 Feb 2009 09:37:53 -0500
Personally, I think this is the better solution, as long as your
clients don't care that their data is sharing a table with someone
else. Of course, you don't necessarily have to tell them :)
On Feb 16, 2009, at 9:40 PM, Richard Stephens wrote:
Hi Chuck, Andrew, and Cheong,
Thanks heaps for your advice. There won't be any objects in common
between the sessions. I'm basically trying to avoid deploying a new
version of the application for each customer. However after
speaking with my colleagues we have decided that it will be easier
to modify the upstream application to log everything into one table
than to venture into uncharted territory with WebObjects and try to
make this work.
--
Regards,
Richard Stephens
Ph: 07 3136 3426
Mob: 0410 111 570
Email: email@hidden
On 17/02/2009, at 5:33 AM, Chuck Hill wrote:
On Feb 15, 2009, at 2:19 AM, Andrew Lindesay wrote:
Hello Richard;
I've not done anything like this, but maybe you might be able to
create a new model-group for each session somehow and then change
the connection dictionary on the model in the model group, but I'm
not sure on the mechanics of that as I've not done anything like
this.
You will also need a separate EOF stack for each. That can eat up
a lot of memory if there are a lot of objects in common in each
session. You probably should do this on a per-customer basis not a
per session basis (unless each customer is only a user or two).
Wonder has some code that creates a pool of EOF stacks. That is
probably good starting point.
Chuck
Is it possible to set the JDBC URL for one of my models on a per
session basis? I need to connect to a different database based on
which customer is logged in, and i'd rather not have to deploy a
new copy of my app for each customer.
___
Andrew Lindesay
www.lindesay.co.nz
_______________________________________________
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
_______________________________________________
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