David, Oracle have a view named v$sqlarea that contains all SQL Queries, and in my case "Select * from dual" appears :( So validationQuery is sending this query.
Christopher, I don't expect many long-time queries... So what's your opinion? Tnks all! Christopher Schultz-2 wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > CC, > > On 3/23/2009 11:24 AM, CutKiller wrote: >> But the validationQuery was set at the Resources Tags. >> >> <Context path="/testAdmin" docBase="testAdmin" >> debug="0" reloadable="true" crossContext="true"> > > What version of TC are you running? You shouldn't be setting the path > attribute, though this is unlikely to be causing your problem. > > Is there a testAdmin.xml file hiding somewhere under > $CATALINA_HOME/conf/[enginename]/[hostname]/ that could be overriding > your configuration? > >> removeAbandoned="true" removeAbandonedTimeout="1800" > > Do you expect many long-running queries? This configuration will only > purge abandoned connections after they've been out of the pool for 30 > /minutes/. That's a long time to wait before your connections recover. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAknKI2cACgkQ9CaO5/Lv0PD2XgCgoOiqvDyfelUoL+zUQuBXhm0X > HbcAn2KPdmbsjMcoEsIbVJgiqqSnZFdH > =qsgv > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > 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-and-Database-Problem-tp22658620p22703934.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
