ORA-01017: invalid username/password; logon denied

[aemi]

Exception in thread "main" java.sql.SQLException: ORA-01017: invalid
username/password; logon denied

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:
468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:
314)
at java.sql.DriverManager.getConnection(DriverManager.java:
525)
at java.sql.DriverManager.getConnection(DriverManager.java:
171)
at
com.hewitt.mb.common.otl.OTLDatabase.<init>(OTLDatabase.java:51)
at
com.hewitt.mb.common.otl.CopyOneTable.main(CopyOneTable.java:38)

SQL*Loader: Release 9.2.0.6.0 - Production on Wed Feb 7 08:58:05 2007



the part of OTLDatabase where it is showing error is

public OTLDatabase(String _url, String _schema, String _user, String
_password) throws ClassNotFoundException, SQLException {
url = _url;
schema = _schema;
user = _user;
password = "car27max";

logger.info("Connecting to " + url);
logger.info("schema: " + schema);
logger.info("user: " + user);
logger.info("password: " + password);
Class.forName("oracle.jdbc.OracleDriver");
dbConn = DriverManager.getConnection(_url, _user, _password);
metaData = dbConn.getMetaData();
}
and that of CopyOneTable.java is

OTLDatabase target = new
OTLDatabase(AppVariables.get("targetdriver.url"),
AppVariables.get("targetSchemaPattern"),
AppVariables.get("targetUser"), AppVariables.get("targetPassword"));
OTLDatabase source = new
OTLDatabase(AppVariables.get("sourcedriver.url"),
AppVariables.get("sourceSchemaPattern"),
AppVariables.get("sourceUser"), AppVariables.get("sourcePassword"));

can anybody tell me how to remove this error??

 

[Lew]

Exception in thread "main" java.sql.SQLException: ORA-01017: invalid
username/password; logon denied

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:
134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:
468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:
314)
at java.sql.DriverManager.getConnection(DriverManager.java:
525)
at java.sql.DriverManager.getConnection(DriverManager.java:
171)
at
com.hewitt.mb.common.otl.OTLDatabase.<init>(OTLDatabase.java:51)
at
com.hewitt.mb.common.otl.CopyOneTable.main(CopyOneTable.java:38)

SQL*Loader: Release 9.2.0.6.0 - Production on Wed Feb 7 08:58:05 2007



the part of OTLDatabase where it is showing error is

public OTLDatabase(String _url, String _schema, String _user, String
_password) throws ClassNotFoundException, SQLException {
url = _url;
schema = _schema;
user = _user;
password = "car27max";

logger.info("Connecting to " + url);
logger.info("schema: " + schema);
logger.info("user: " + user);
logger.info("password: " + password);
Class.forName("oracle.jdbc.OracleDriver");
dbConn = DriverManager.getConnection(_url, _user, _password);
metaData = dbConn.getMetaData();
}
and that of CopyOneTable.java is

OTLDatabase target = new
OTLDatabase(AppVariables.get("targetdriver.url"),
AppVariables.get("targetSchemaPattern"),
AppVariables.get("targetUser"), AppVariables.get("targetPassword"));
OTLDatabase source = new
OTLDatabase(AppVariables.get("sourcedriver.url"),
AppVariables.get("sourceSchemaPattern"),
AppVariables.get("sourceUser"), AppVariables.get("sourcePassword"));

can anybody tell me how to remove this error??

It looks like your AppVariables are not returning the correct username or
password. You might want to do some value checking there, perhaps in the
debugger, as to what is passed to the OTLDatabase constructor.

- Lew