The query has been changed to "select 1". Thanks.
Pid-6 wrote: > > On 30/09/2009 13:38, MartinOShea wrote: >> >> So select now() is fine. > > (Where "fine" is defined as "not what you were advised to use, for sound > reasons that are require a longer explanation than was necessary at the > time".) > > p > > >> Thanks. >> >> >> markt-2 wrote: >>> >>> MartinOShea wrote: >>>> Thanks for the reply. >>>> >>>> Setting testOnBorrow to true is something I'll try but according to: >>>> >>>> http://commons.apache.org/dbcp/configuration.html >>>> >>>> If testOnBorrow is set to true, the validation query must be set to a >>>> 'non-null string'. Presumably this means that the query must always >>>> return a >>>> value such as validationQuery = "select now()" always returning the >>>> date >>>> / >>>> time? >>> >>> It just means that testOnBorrow does nothing if validationQuery is set >>> to >>> "". >>> For mysql "select 1" is sufficient and saves a call to now(). The Oracle >>> equivalent would be "select 1 from dual" >>> >>> I just checked the dbcp source code and the criteria for the validation >>> query is >>> that it must return at least 1 row with no exceptions being thrown. >>> >>> Mark >>> >>> >>>> >>>> validationQuery = "select now()" >>>> >>>> markt-2 wrote: >>>>> MartinOShea wrote: >>>>>> But I think what is >>>>>> happening after eight hours of inactivity, is that the system is >>>>>> trying >>>>>> to >>>>>> reuse a connection pool object that MySQL has closed down after its >>>>>> default >>>>>> eight hour period. >>>>> Sounds likely. >>>>> >>>>>> testOnBorrow = "false" >>>>> Try setting this to true. >>>>> >>>>> Mark >>>>> >>>>> >>>>> --------------------------------------------------------------------- >>>>> 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 >>> >>> >>> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > -- View this message in context: http://www.nabble.com/Tomcat-6.X-and-MySQL-connection-pooling-issue-tp25677820p25680340.html Sent from the Tomcat - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
