Re: Host level JNDI Variable

[Parsons Technical Services]

To use pooling provided by Tomcat, one way to do it is to set up four 
Globalresources in the server.xml

Then from your apps call the one you want. You will need the resource link 
in the context for each app for the matching Globalresource.

So set up four globals: dataDev, dataSit, dataUat and dataProd
Place links in the context for apps in the DEV to dataDev
for apps in SIT to dataSit and so on.
Since the connections are established to the database and not the engine, 
each pool is dedicated to that database. So in effect you will be creating a 
pool for each database and then connecting to the appropriate pool. And in 
order to create the pool the database must be specified, so it cannot be 
selected at any point later in the process.

Doug
----- Original Message ----- 
From: "Gurumoorthy" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <tomcat-user@jakarta.apache.org>
Sent: Tuesday, April 05, 2005 8:28 PM
Subject: Host level JNDI Variable

Hi,
       The senario
       I have 4 VIRTUAL HOST on tomcat dev / sit / uat / prod
       Based on host information i need to access different database 
instance
       jdbc:..../DEV : for dev
       jdbc:..../SIT : for sit
       and so on...
Can anyone let me know how to set the JNDI variable at host level or service 
level ?

Many thanks
Guru 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]