Trying to put in some logging statements. Can anyone suggest where System.out prints to?
I don't see it in any of the logs. On Wed, Apr 1, 2009 at 8:47 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Ramy, > > (Hey! I found my original message. Here's a bit more detail on the > validationQuery) > > On 3/31/2009 9:36 PM, Mighty Tornado wrote: > > Hi I placed the following in context.xml in META-INF. > > But the result set is null, what's wrong with my set up? Can anybody > please > > advise? > > As others have suggested, your exception does not include the important > part: what actually happened. We only got a piece of what happened. You > say that it's an old exception so maybe it's unrelated. > > Let's take a look at your configuration: > > > validationQuery="select * from family_member;" > > Yikes! A complete table-scan for each validation query? I would > recommend something like "/* PING */ SELECT 1" where the database > doesn't have to do any work to fulfill the query. Remember, the > validation query just checks to see if communication with the database > is still working. It's not intended to return any actual data. > > Other than that, your configuration looks good. It appears to be > working, so you're probably fine. > > (See my other message with comments on your code) > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAknTYkYACgkQ9CaO5/Lv0PArVwCeNrLv9Z57uFqpM6i9c4OU4AmD > sJYAoK6l6VD93NAjvDEhxkBPWDtJDk0T > =mdTH > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
