A
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??
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??