Re: Different connections to aDatabase
Re: Different connections to aDatabase
- Subject: Re: Different connections to aDatabase
- From: Mark Morris <email@hidden>
- Date: Wed, 12 Oct 2005 22:11:50 -0500
Sorry, I always seem to jump one step too far without thinking when
it comes to this subject. I'm so used to altering the connection
dictionary *on application startup* that I'm way too anxious to share
how easy it is. So anxious that I forget the context in which I'm
doing it!
It IS easy to alter the connection dictionary per instance, so
Chuck's first suggestion would work. Each school could get their own
URL, but there would really only be one copy of the application to
maintain. You could also perhaps have a login app, or instance of
the same app, that redirects to the specific school instance, but
there are a few security issues to overcome with that approach....
(FYI, I always update the connection dictionary so that production
passwords aren't in my EOModel file.)
Regards,
Mark
On Oct 12, 2005, at 12:36 PM, Chuck Hill wrote:
Hi,
Yes, if you create a copy of the schema from the EOModel under a
different user for each school and then alter the JDBC URL to
connect as that user. The user for a school can be defined in the
application properties. Done like this, each school will need its
own instance(s) of the application running. If you also need to
share instances, then you are better off modifying the model, as
someone pointed out, to have an indication of which data is for
which school.
If you want to change the connection dictionary at application
start based on a property or command line value, search the
archives, www.wocode.com, or www.wodev.com for "connection
dictionary". You should find several solutions. A complete
description of functionality and tested code is also found in
Practical WebObjects (see my sig) starting on page 53.
Chuck
On Oct 12, 2005, at 12:53 AM, Frank Stock wrote:
Hi,
I have a few projects we use in our school. I would like other
schools to use the same projects.
We use Frontbase as our local database, so I would like to make
new users in the database (one for each school).
Is it possible to control at login and connect to the school you
want in your application?
Thanks,
Frank Stock
Sint-Pieterscollege
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Coming in 2006 - an introduction to web applications using
WebObjects and Xcode http://www.global-village.net/wointro
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:
40onpointsoftware.com
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