Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Java (http://www.velocityreviews.com/forums/f30-java.html)
-   -   ORA-01017: invalid username/password; logon denied (http://www.velocityreviews.com/forums/t390682-ora-01017-invalid-username-password-logon-denied.html)

aemi 02-07-2007 03:31 PM

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

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:
134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.j ava:259)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:346)
at
oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:
468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.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>(OTLDat abase.java:51)
at
com.hewitt.mb.common.otl.CopyOneTable.main(CopyOne Table.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 02-07-2007 07:09 PM

Re: ORA-01017: invalid username/password; logon denied
 
aemi wrote:
> Exception in thread "main" java.sql.SQLException: ORA-01017: invalid
> username/password; logon denied
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:
> 134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
> at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
> at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.j ava:259)
> at
> oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:346)
> at
> oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:
> 468)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.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>(OTLDat abase.java:51)
> at
> com.hewitt.mb.common.otl.CopyOneTable.main(CopyOne Table.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


All times are GMT. The time now is 12:55 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.