tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mighty Tornado <mighty.torn...@gmail.com>
Subject Re: DataSource from Context files - doesn't work
Date Wed, 01 Apr 2009 17:55:10 GMT
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 <
chris@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message