tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Demieville" <g...@pdccorp.com>
Subject RE: Oracle Invalid Login Credentials
Date Thu, 13 Sep 2007 16:50:31 GMT
>Is it possible that your db connection is being terminated (probably due
>to inactivity) and that the "invalid login" is a spurious error?

Once the 'Invalid login ' error happens, then everyone else gets the same
error upon login until Tomcat is re-started.

Which log files would help me determine a JDBC error?

Thank you,
 
Greg Demieville

-----Original Message-----
From: Christopher Schultz [mailto:chris@christopherschultz.net] 
Sent: Wednesday, September 12, 2007 3:18 PM
To: Tomcat Users List
Subject: Re: Oracle Invalid Login Credentials

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greg,

Greg Demieville wrote:
> We occasionally get 'Access Denied Invalid Login Credentials' when
accessing
> our application. Stopping and Re-starting Tomcat fixes the issue. We are
> using Apache Tomcat 5.0.28/Java JDK 1.5.0.11/Oracle 9.2/JSP pages. Is
there
> a known issue with Tomcat and Oracle, or do we need to require the Tomcat
> service restart as part of a maintenance schedule?

Is it possible that your db connection is being terminated (probably due
to inactivity) and that the "invalid login" is a spurious error?

If you are using a Tomcat connection pool (which I highly recommend),
consider using testOnBorrow and friends to make sure that your DB
connection is good before you try to use it for things like authentication.

(Or, are you getting this error from the Oracle JDBC driver?)

- -chris

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG6EmT9CaO5/Lv0PARAh1AAJ96NOesCJF67tl1cYs5xJoCJSXT5wCghrLt
0r5BbE6fjDRX36eYqkdrr30=
=DfO/
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message