The main problem if you are using apache or not, is the "connector". I don't know if you are using apache but if you are using apache with tomcat DON'T USE the WebApp connector, is not maintained anymore and does not work correctly with apache 1.*, 2.*. USE mod_jk2 it works fine with the pool connection. I had the same problem a few days ago and I resolve the problem changing connectors.
I hope this help. Quoting Manavendra Gupta <[EMAIL PROTECTED]>: > I am surprised with the number of ppl facing this problem, including > myself. > And it makes me wonder how others on this list have been able to use > DataSource/Connection Pooling with tomcat. It seems to be one feature where > majority of ppl have been facing problems, yet there is not much of > information on this (including the JNDI HOW-TO). It would be interesting to > hear from someone who had faced and subsequently resolved this problem. > > Manav. > > -----Original Message----- > From: Hari Venkatesan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 7:27 PM > To: Tomcat Users List > Subject: RE: Connection Pooling Help > > > > Try changing the following parameter value in server.xml file > > <value>jdbc:as400://10.0.0.1</value> > > <value>jdbc:as400://{name of your machine} </value> instead of the ip > address of the as400 > > Hari > > -----Original Message----- > From: Kevin Passey [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 09, 2002 8:40 AM > To: 'Tomcat Users List' > Subject: RE: Connection Pooling Help > > Eric, > > It's the same - DS == null. :-( > > Thanks anyway. > > Kevin > > -----Original Message----- > From: Roberts, Eric [mailto:[EMAIL PROTECTED]] > Sent: 09 December 2002 13:33 > To: Tomcat Users List > Subject: RE: Connection Pooling Help > > > Kevin, > > Try: > > Context ctx = new InitialContext(); > Context envCtx = (Context) ctx.lookup("java:/comp/env/"); > DataSource ds = (DataSource) envCtx.lookup("/jdbc/shiltonDB"); > > > -----Original Message----- > From: Kevin Passey [mailto:[EMAIL PROTECTED]] > Sent: Montag, 09. Dezember 2002 14:25 > To: Tomcat Users List (E-mail) > Subject: Connection Pooling Help > > > Hi, > > Can somebody point out my mistake for me - I'm starting to bang my > head.. > > I am trying to get connection pooling working on my AS/400 using the > Commons-DBCP. > > I have placed this JAR in <TOMCAT_HOME>/common/lib along with the > JT400.JAR > > I have added the context entries to my server.xml file - thus:- > > <!-- AS400 Connection Pooling Test --> > <Context path="/shilton" docBase="shilton" debug="5" > reloadable="true" crossContext="true"> > <Resource name="jdbc/shiltonDB" auth="Container" > type="javax.sql.DataSource" /> > > <ResourceParams name="jdbc/shiltonDB"> > <parameter> > <name>factory</name> > > > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > > <parameter> > <name>maxActive</name> > > <value>100</value> > </parameter> > > <parameter> > <name>maxIdle</name> > > <value>30000</value> > </parameter> > > <parameter> > <name>maxWait</name> > > <value>100</value> > </parameter> > > <parameter> > <name>username</name> > > <value>INTERNET</value> > </parameter> > > <parameter> > <name>password</name> > > <value>INTERNET</value> > </parameter> > > <parameter> > <name>driverClassName</name> > > <value>com.ibm.as400.access.AS400JDBCDriver</value> > </parameter> > > <parameter> > <name>url</name> > > <value>jdbc:as400://10.0.0.1</value> > </parameter> > </ResourceParams> > </Context> > > I have added this to my WEB-INF web.xml file:- > > <resource-ref> > > <description> > > Resource reference to a factory for java.sql.Connection > > instances that may be used for talking to a particular > > database that is configured in the server.xml file. > > </description> > > <res-ref-name> > > jdbc/shiltonDB > > </res-ref-name> > > <res-type> > > javax.sql.DataSource > > </res-type> > > <res-auth> > > Container > > </res-auth> > > </resource-ref> > > And I have this java program to test the connection > > import javax.naming.*; > import javax.sql.*; > import javax.servlet.http.HttpServlet; > import javax.servlet.http.HttpServletRequest; > import javax.servlet.http.HttpServletResponse; > import javax.servlet.ServletOutputStream; > import java.sql.*; > > public class DBCPServlet extends HttpServlet { > > public void doGet(HttpServletRequest req, > HttpServletResponse res) { > > try { > ServletOutputStream out = res.getOutputStream(); > out.println("<html><body>"); > out.println("<h2>Using Tomcat Connection Pooling with > DBCP</h2>"); > > Context ctx = new InitialContext(); > if (ctx == null) > out.println("Something is wrong with Tomcat"); > > DataSource ds = (DataSource) > ctx.lookup("java:comp/env/jdbc/shiltonDB"); > > if (ds != null) { > Connection conn = ds.getConnection(); > > if (conn != null) { > out.println("<b>Got Connection:</b> " + conn.toString() + > "<p>"); > Statement stmt = conn.createStatement(); > String sql = "select * from BSSTYL"; > ResultSet rst = stmt.executeQuery(sql); > if (rst.next()) { > out.println("<b>Value of HDCUST on first record:</b> > "+ > rst.getString("dbfield1")+ "<p>"); > } > out.println("This was our little database-access > servlet..."); > conn.close(); > } > } > } catch (Exception e) { > e.printStackTrace(); > } > } > > /** > * if somebody does a http-post, we do an interal dispatch to doGet() > */ > public void doPost(HttpServletRequest req, > HttpServletResponse res) { > doGet(req, res); > } > } > > "ds" is alway null - what am I missing. > > Thanks in advance. > > > > Kevin > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- = Roberto Bouza Fraga = =================================== Research & Development Engineer Ella Cisneros Fontanals Holdings Ph: (305)-860-0116 / Fax:(305)-860-9401 =================================== e-Mail:[EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
