hantai

如何在JDBC中使用SYSDBA角色連接ORACLE數據庫

解決方法:
在連接屬性中設置internal_logon即可

public Connection
getConn(){
Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
java.util.Properties
info = new java.util.Properties();
info.put("user",
"sys");
info.put("password",
"orcl");
info.put("internal_logon",
"sysdba");
conn =
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL",info);
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
} catch (SQLException
e)
{
e.printStackTrace();
}
return
conn;
}

因為sys是DBA用戶，登錄時，必須以SYSDBA或SYSOPER身份登錄