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 <ludoviclambrechts-dev@xxxxxxxx> 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
>
|
