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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net

This email sent to [EMAIL PROTECTED]



--
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/markm% 40onpointsoftware.com

This email sent to [EMAIL PROTECTED]


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to