How to connect in java as SYS to Oracle?

Question

I receive this error:

java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER 

How to fix? (I need to be SYS). Thanks.

Answer 1

try this :

import java.sql as jsql import java.lang as lang driver, url, user, passwd = ( "oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@localhost:1234:xxx1", "sys as sysdba", "xxx1")  lang.Class.forName(driver)  c = jsql.DriverManager.getConnection(url,user,passwd) 

Answer 2

Answers already there,

you are trying to connect as sys but the Server allows

either

sys as sysdba 

or

sys as sysoper 

just change user parameter as either one from above

user='sys as sysdba' 

or

user='sys as sysoper'