DB SQLException for locked DB
I have a JSP web page that has worked with Oracle 9i for a couple years. Now lately I have this message coming up:
[1]java.sql.SQLException: ORA-28000: the account is locked
Please advise because I have not changed my password or login or updated anything on this web page for two years.
My error comes on line 92 which is where my sql is located:
<%//This is line 92 here
try...
String myString ="select * from tableOne";
Class.forName(....);
Connection myConnection = DriverManager.getConnection(...);
.....
catch(SQLException se)
{
...
[736 byte] By [
teser2a] at [2007-11-26 15:16:44]
# 1
This isn't a Java question, you should check in an Oracle forum.
Any chance someone might try and hack the account?
From the Oracle Security FAQ. It would appear there are many reasons an account can be locked, perhaps one of these occured in the recent past?
From Oracle8 one can manage passwords through profiles. Some of the things that one can restrict:
FAILED_LOGIN_ATTEMPTS - failed login attempts before the account is locked
PASSWORD_LIFE_TIME - limits the number of days the same password can be used for authentication
PASSWORD_REUSE_TIME - number of days before a password can be reused
PASSWORD_REUSE_MAX - number of password changes required before the current password can be reused
PASSWORD_LOCK_TIME - number of days an account will be locked after maximum failed login attempts
PASSWORD_GRACE_TIME - number of days after the grace period begins during which a warning is issued and login is allowed
PASSWORD_VERIFY_FUNCTION - password complexity verification script
