Multiple Databases
Multiple Databases
- Subject: Multiple Databases
- From: Support <email@hidden>
- Date: Sun, 7 Mar 2004 08:24:33 -0700
We are just starting down the road of WO development. I am sure this
has been asked before, but after looking through a variety of sources
we are still at a loss.
We will be maintaining our list of users in one database for single
sign-on capability. Then each user when they login will access
information from their database. So that we have one login database and
multiple databases. We have to maintain different databases for each
group of users for security reasons.
So far from reading, the secret seems to be in the connection
dictionaries?
When a user logs in ideally we want this to happen:
1. Authenticate against the user db. In other places in the application
this authentication is required again. So the connection should either
be active OR easy to call at any time.
2. The authentication returns the name of the database assigned to that
user, and stores it as a session variable so that it is passed from
page to page until the session has expired or the user logs out.
3. The connection is made to the users database.
Everywhere we look it seems that it is One EO model to one instance of
WO.
We don't want to create multiple instances of the application since
most session are left to expire and this will be a memory hog? But this
has to be easy to do in WO, since it seems to be for other tools,
right?
So we need to assign EO Models to sessions, at least that is how we do
it now and it works great.
Thanks for help in advance,
Brin
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.