As the error is clearly telling either user or password wrong. To make sure this once again write small java program like below and connect through the java program(for this get download ojdbc14.jar to execute this program) if it will give the same error then you can confirm username and password wrong.
/*
*
*/
//ODBC14.jar required to connect Oracle database
package com.sap.prgs;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
*/
public class JDBCConnection {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection conn = null;
Statement stmt = null;
try{
System.out.println("hello");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url ="jdbc:oracle:thin:@xxx.x.xxx.xxx:port:somehost";
conn = DriverManager.getConnection(url,"username","password");
System.out.println("connection success"+conn.getClass());
stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("SELECT column1 FROM tablename");
while (rset.next()) {
System.out.println (rset.getString(1));
}
}
catch(Exception e){
System.out.println("exception is"+e);
}
finally{
System.out.println("closing connection");
conn.close();
stmt.close();
}
}
}
thanks,
madhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.