See Thread at: http://www.techienuggets.com/Detail?tx=12700 Posted on behalf of a User
You should look at the SQL ORA error message that should be in the SQLException thrown by your JDBC call. This should be in your log4j log file if you're using log4j or any other logging mechanism, perhaps even the default log. In Response To: >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:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: [EMAIL PROTECTED] To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
