Furthermore, Tomcat 4.1.x makes this even easier by allowing you to put a context.xml file into the webapps directory, rather than putting a context entry in servlet.xml. This makes it even easier to setup your app on a new server. I have an ant task called "setup-tomcat" that copies my jdbc-driver to $CATALINA_HOME/common/lib and my-app.xml to $CATALINA_HOME/webapps and tomcat is ready to go!
Matt > -----Original Message----- > From: mech [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 22, 2003 1:33 PM > To: 'Struts Users Mailing List' > Subject: RE: db connection pool question > > > It's not really conform to the idea that the deploying administrator > shouldn't have to touch the webapp to make it run. In case you want to > configure your .war packed webapp you would have to unpack, edit > struts-config.xml and so on. > One idea behind J2EE was "write once, run everywhere, as long > as you can > deploy it" ;-) > And thus the deployment should be independent from the webapp > internals. > > So server.xml is the cleaner solution even if it won't make a big > difference in many cases. > > Development must be non-container specific (specs), deployment is > container specific and shouldn't be webapp specific. > > Michael > > > -----Original Message----- > > From: David Graham [mailto:[EMAIL PROTECTED]] > > Sent: Mittwoch, 22. Januar 2003 20:40 > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: RE: db connection pool question > > > > > > What is tricky about setting up a datasource in struts-config for > > deployment? The advantage is that you don't need to worry > > about container > > specific datasource setup. > > > > David > > > > > > > > > > > > > > >From: "mech" <[EMAIL PROTECTED]> > > >Reply-To: <[EMAIL PROTECTED]> > > >To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> > > >Subject: RE: db connection pool question > > >Date: Wed, 22 Jan 2003 20:09:55 +0100 > > > > > >I can't tell for Oracle, but for MySQL and the Struts > > Connection Pool > > >you have to set some kind of "autoReconnect=true" for your > > connection > > >url setup. Otherwise your connection pool will contain only stale > > >connections after a certain timeout. MySQL kicked me out > > after 8 hours > > >of inactivity. Without autoreconnect you will just pick a "dead" > > >connection out of this pool, get an exception, most likely > > even close > > >the broken connection in your finally-block and put it > back into the > > >pool. Next time you grab another dead connection and so on > and forth. > > > > > >By the way... Are the certain pro and cons for the struts > connection > > >pool vs. the tomcat datasource connection pool? As far as > I know the > > >tomcat connection pool works only via jndi setup whereas struts > > >utilized the "oldfashioned" way. And moreover you have to > > set it up in > > >struts-config.xml which is a bit tricky for deployment. > > > > > >Michael > > > > > > > -----Original Message----- > > > > From: Raible, Matt [mailto:[EMAIL PROTECTED]] > > > > Sent: Mittwoch, 22. Januar 2003 17:18 > > > > To: 'Struts Users Mailing List' > > > > Subject: RE: db connection pool question > > > > > > > > > > > > After waiting 24 hours, I'm still experiencing the same > > problem with > > > > Oracle and a connection pool (DBCP) in Tomcat. I guess I'll try > > > > configuring Oracle's connection pool?? > > > > > > > > Matt > > > > > > > > > -----Original Message----- > > > > > From: Raible, Matt > > > > > Sent: Tuesday, January 21, 2003 8:22 AM > > > > > To: 'Struts Users Mailing List' > > > > > Subject: RE: db connection pool question > > > > > > > > > > > > > > > Actually, the solution that I had only works for MySQL. I'm > > > > > having the same problem with Oracle. Funny - I just posted a > > > > > message to the commons-user group asking this same > > question. I'll > > > > > try adding the validationQuery parameter: > > > > > > > > > > <parameter> > > > > > <name>validationQuery</name> > > > > > <value>SELECT 'CRAP' FROM DUAL</value> </parameter> > > > > > > > > > > Thanks, > > > > > > > > > > Matt > > > > > > > > > > > -----Original Message----- > > > > > > From: Pani, Gourav [mailto:[EMAIL PROTECTED]] > > > > > > Sent: Tuesday, January 21, 2003 7:58 AM > > > > > > To: 'Struts Users Mailing List' > > > > > > Subject: RE: db connection pool question > > > > > > > > > > > > > > > > > > please look at the thread with subject "Problem with JDBC > > > > & Struts > > > > > > Connection Pool (possible to recon nect?)". Matt > > Raible had a > > > > > > solution to that by setting autoReconnect=true > > > > > > > > > > > > -----Original Message----- > > > > > > From: david chan [mailto:[EMAIL PROTECTED]] > > > > > > Sent: Tuesday, January 21, 2003 9:56 AM > > > > > > To: Struts Users Mailing List > > > > > > Subject: db connection pool question > > > > > > > > > > > > > > > > > > Hi, > > > > > > I am using a connection pool from > > > > > > org.apache.commons.dbcp.BasicDataSourceFactory and > > the driver is > > > > > > oracle.jdbc.driver.OracleDriver. It works great until if > > > > the server > > > > > > idle for a few days, then the connection object > seems broken > > > > > > with this error: ==== begin error mesg === > > > > > > java.sql.SQLException: Io exception: Software caused > > connection > > > > > > abort: socket wr > > > > > > ite error at > > > > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) > > > > > > at > > > > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210) > > > > > > at > > > > > > > > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323) > > > > > > at > > > > > > > > > > > > oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417) > > > > > > at > > > > > > > > > > > > oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432) > > > > > > at > > > > > > > > > > > > > > > > > oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStat > > > > e > > > > > > ment.java:182) at > > > > > > > > > > > > > > > > > oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleCo > > > > n > > > > > > nection.java:602) at > > > > > > > > > > > > > > > > > oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnectio > > > > n > > > > > > .java:538) at > > > > > > > org.apache.commons.dbcp.DelegatingConnection.prepareStatement( > > > > > > DelegatingConn > > > > > > ection.java:197) > > > > > > ... > > > > > > ===== end of error mesg ==== > > > > > > > > > > > > What happen and how can I prevent this? > > > > > > Thanks. > > > > > > David > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > > > > > Do you Yahoo!? > > > > > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > > > > > http://mailplus.yahoo.com > > > > > > > > > > > > -- > > > > > > 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:struts-user-> [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]> > > > > > > _________________________________________________________________ > > STOP MORE SPAM with the new MSN 8 and get 2 months FREE* > > http://join.msn.com/?page=features/junkmail > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:struts-user-> [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]>
