java连接数据库密码错误_如果密码有特殊字符，则无法使用JDBC连接到oracle数据库...

以下是代码::

public class OraclePwdTest {

static{

try {

Class.forName("oracle.jdbc.OracleDriver");

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

// TODO Auto-generated method stub

String ip ="192.168.20.145";

String sid = "oradg";

int port = 1521;

String user = "sys";

String pwd = "[email protected]";

Connection conn = null;

String url = "jdbc:oracle:thin:"+"(DESCRIPTION =" +

"(ADDRESS_LIST =" +

"(ADDRESS = (PROTOCOL = TCP)(HOST = "+ ip +")" +

"(PORT = " + port + "))" +

")" +

"(CONNECT_DATA = (SRVR=DEDICATED) " +

"(SID = " + sid +

"))" +

")";

java.util.Properties prop = new java.util.Properties();

prop.put ("user", user);

prop.put ("password", pwd);

prop.put ("internal_logon", "sysdba");

try {

conn = DriverManager.getConnection(url,prop);

System.out.println("Connected");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

如果密码是，如＃@特殊字符...那么上面的代码不起作用。它使用简单的密码。

我得到以下错误消息::

值java.sql.SQLException：ORA-01017：无效的用户名/密码;登录被拒绝

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573)

at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)

at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:154)

at TestOracleConnection.main(TestOracleConnection.java:54)

请帮我解决问题。

2014-02-20

Anjali

+0

只是一个方面说明：你为什么要作为应用程序代码中的SYSDBA进行连接。这听起来像一个可怕的想法。 –

+0

no..with sqlplus也没有工作.. –