Perfect Thanks! The type I use would be: j<http://tomcat.apache.org/tomcat-5.5-doc/config/globalresources.html> avax.sql.DataSource
(I was using untokenized reference in my example) Thanks for your help. Regards Anurag ------------------------------------------------------------------ Anurag Kapur Associate - Technology, Sapient Corporation. http://www.linkedin.com/in/anuragkapur http://www.google.com/profiles/anuragkapur ------------------------------------------------------------------ Sent from Poplar, Greater London, United Kingdom On Wed, Dec 9, 2009 at 6:15 PM, Mark Thomas <ma...@apache.org> wrote: > Anurag Kapur wrote: > > Thanks Mark. > > > > Can you confirm that I can have one data source "shared" across all > contexts > > with the following configurations: > > > > In CATALINA_BASE/conf/server.xml, I define a GlobalNamingResource as > > follows: > > > > <GlobalNamingResources> > > ... > > ... > > Resource name=*"@tomcat.context.ece.read.ds.resource@"* > auth=*"Container" > > type="@tomcat.context.driver.type@" driverClassName= > > "@tomcat.context.driver.class@" url="@tomcat.context.db.url@" > > connectionProperties= > > "{validateconnecti...@tomcat.context.validate.connection@ > > ,connectionwaittimeo...@tomcat.context.connection.wait.timeout@}" > username= > > "@tomcat.context.db.user@" password="@tomcat.context.db.password@" > > validationQuery="@tomcat.context.validation.query@" initialSize= > > "@tomcat.context.initial.size@" minIdle="@tomcat.context.min.idle@" > > maxActive="@tomcat.context.max.active@ > "maxIdle="@tomcat.context.max.idle@" > > maxWait="@tomcat.context.max.wait@"removeAbandonedTimeout="60" > > removeAbandoned="true" logAbandoned="true"/>* > > > > </GlobalNamingResources> > > > > I then reference it in CATALINA_BASE/conf/context.xml as follows: > > > > <Context> > > <ResourceLink name="@tomcat.context.ece.read.ds.resource@" > > global="@tomcat.context.ece.read.ds.resource@" > > type="@tomcat.context.driver.type@"/> > > </Context> > > The type looks odd but if it is correct then that should work. > > Mark > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
