本文转自
http://rogerfederer.iteye.com/blog/1815171
java 用jdbc方式以 sys账号连接oracle数据的问题
Java代码
- jdbc.properties
- driver=oracle.jdbc.driver.OracleDriver
- url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
- username=sys
- password=password
报错:
Java代码
- Exception in thread "main" java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
改成Java代码
- username=sys as sysdba
就可以连接了!
如果是PL/SQL的话直接sys/rebeyond as sysdba就可以了。
其实在java的连接字符串里,只要把String user="sys"改成String user="sys as sysdba"就可以改变默认的Normal登陆模式了。
Java代码
- Connection c = DriverManager.getConnection(url, "sys as sysdba",
- "password");