Re: Getting DataSource from non-Struts class

2004-10-20 Thread Sean Schofield
I agree with this. We use Tomcat to set up the connection pool and reference it in our Struts apps as Craig suggests above. Take a look at the Tomcat documentation, there is quite a bit on JNDI and datasources. Good luck, sean On Wed, 20 Oct 2004 11:00:11 -0700, Craig McClanahan <[EMAIL PROTEC

Re: Getting DataSource from non-Struts class

2004-10-20 Thread Craig McClanahan
More modern advice suggests that you don't use a Struts-provided connection pool at all ... use the JNDI factilities provided by your servlet container or app server. Then, you gain access to a connection pool provided by the server, like this: InitialContext ic = new InitialContext(); DataSo

Re: Getting DataSource from non-Struts class

2004-10-20 Thread DGraham
Found this at  http://www2.real-time.com/rte-tomcat/2000/Jun/msg01487.html -- The suggested approach is to store your connection pool object itself as a servlet context attribute, like this:     ConnectionPool pool = new ConnectionPool( ... );     getServletContext().setAttribute("pool", pool);