如何在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身份登录