You could have separate dao managers, this would work well if as you say they have the same tables/procedures but need to call them with different database parameters. Also, to add a new group, you would only need to create a new ibatis config file pointing to the common sql map.
-ed On 7/26/05, Ludovic Lambrechts <[EMAIL PROTECTED]> wrote: > Hi there! I'am new to iBatis Data Mapper, which i'am > testing for futur use in a new project. > > I've read the docs and tutorials and made some tests > to see how it could help me. I'm pretty impressed by > this framework! > > Now, I'd like to know if it's possible to access > multiple databases from, lets say, a servlet in Tomcat > (and of course, the best way to do it)? Ideally, the > framework shouldn't be initialized for each request, > but only once, during the first load of the servlet. > > My application will be a "single point of access" for > all the users. The db structure and the queries are > the same but, depending on the user's department, I > have to query different instances of the db, possibly > located on different servers. > > Of course, I don't want to make one servlet for each > db. At first sight, I tought of building an array of > SqlMapClient's or, better (? ;-)), using instances of > DaoManager... but I've no clue :-( > > Since I'm only a beginner, somebody can please help? > > Thanks > > Ludovic > > [developer, 28 years old, brussel, > belgium] > > > > > > > ___________________________________________________________________________ > Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger > Téléchargez cette version sur http://fr.messenger.yahoo.com >
