如何在JDBC中使用SYSDBA角色連接ORACLE數(shù)據(jù)庫
解決方法:
在連接屬性中設(shè)置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身份登錄