> -----Original Message----- > From: Jose María Zaragoza [mailto:demablo...@gmail.com] > Sent: Friday, December 13, 2013 2:33 PM > To: Tomcat Users List > Subject: Re: What if my database is unavailable at startup? > > 2013/12/13 Dames, Kristopher J <kristopher.da...@mercy.net>:
> >> With testOnBorrow="true" ( I think that is the default value in Tomcat > >> 6 ) + validationQuery="SELECT 1 FROM DUAL" , that should work > >> > > > > So you are saying my configuration should work as-is to allow Tomcat to > create a database connection pool to a database that was unavailable when > Tomcat was started? > > > Yes , I do it and it works > But I dont use some parameters like maxOpenPreparedStatements , > accessToUnderlyingConnectionAllowed > Furthermore, I use default values for testOnXXX > The others , at first sight, are similar > Tomcat appears to be working properly. Another webapp in the same Tomcat instance does recover once the database becomes available. The one that does not is using an older Oracle driver. In addition, both are JRuby on Rails webapps and the non-working one is using an older version of Rails. So the issue seems to be with the webapp instead of with Tomcat itself. Thank you all for the input and direction! -- Kris Dames > >> I've never used > >> > >> maxOpenPreparedStatements="0" > >> accessToUnderlyingConnectionAllowed="false" > >> > >> what are they for ? > >> > > > > maxOpenPreparedStatements: The maximum number of open statements that can be > allocated from the statement pool at the same time > > accessToUnderlyingConnectionAllowed: Allows the raw physical connection to > the database to be accessed by the webapp > > > > This email contains information which may be PROPRIETARY IN NATURE OR > OTHERWISE PROTECTED BY LAW FROM DISCLOSURE and is intended only for the use of > the addresses(s) named above. If you have received this email in error, > please contact the sender immediately. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org This email contains information which may be PROPRIETARY IN NATURE OR OTHERWISE PROTECTED BY LAW FROM DISCLOSURE and is intended only for the use of the addresses(s) named above. If you have received this email in error, please contact the sender immediately. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
