-----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
