I do it in another different way: First - I have a JavaBean that sets my connection pools Second - My main servlet' init method uses this Java Bean instance to get an data source pool object Third - create my sql... I guess it's right. Euclides. -----Mensagem original----- De: Emerson Cargnin [mailto:[EMAIL PROTECTED] Enviada em: quinta-feira, 5 de junho de 2003 16:42 Para: Tomcat Users List Assunto: Re: Sharing a connection pool among contexts
I do it in a different way : I have a servlet in charge to set all pools, and I have a class with statics methods to manage the pools, creating, test, and show their use. This class is shared with all contexts through a jar in common/lib. So I have a servlet, with all configuration of the pools in param in the web.xml. this servlet can create pools (in its init method), test and show it, and show statistics. I works great, and I can share a pool among contexts. I use the bitmechanic connection pool, a little old, but still works. http://www.bitmechanic.com/projects/jdbcpool/dist/jdbcpool-1.0b1.zip I put the jar of the pool in the common/lib dir. I f anyone is interested in the ConnectionManager, I can share it, it's an eclipse project with ant build file that generates both war and the lib jar. Hope it can help :) Emerson Scott wrote: > Hi, I have configured the commons-dbcp datasource as a JNDI resource > for MSSQL and Oracle and all is working as expected. However, as I > understand, it is only possible to keep a factory as a resource and so > a new datapool must be created everytime a JNDI lookup is done. I > would like to share a single connection pool among different contexts. > > My first attempt was to create a listener that put a single instance > of a pool into the JNDI only to find that it is read-only. For my next > attempt I am thinking of creating a javabean with a static collection > of datasources and name keys that can be gotten as a JNDI resource so > that the different applications can just retrieve the bean and do a > lookup of the datasource that way. > > Am I missing an easier or better way to do this? I do not have any > experience with Javabeans and based on the stuff I've seen on the web > beans are usually graphic oriented. Is this an appropriate use of a > bean (or perhaps an Enterprise Javabean)? > > Thank you in advance, > Scott > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Emerson Cargnin Analista de Sitemas Setor de Desenvolvimento de Sistemas - TRE-SC tel : (048) - 251-3700 - Ramal 3181 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]