tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: DataSource from Context files - doesn't work
Date Wed, 01 Apr 2009 12:47:02 GMT
-----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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message