• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Different connections to aDatabase
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >Different connections to aDatabase (From: Frank Stock <email@hidden>)
 >Re: Different connections to aDatabase (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: Direct to Web java problem
  • Next by Date: Web Services and Axis
  • Previous by thread: Re: Different connections to aDatabase
  • Next by thread: Tomcat By SW 5.5.12
  • Index(es):
    • Date
    • Thread