How to connect in java as SYS to Oracle?

java database oracle sys
user710818 picture user710818 · Apr 11, 2012 · Viewed 39.7k times · Source

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

simplycurious picture simplycurious · Apr 11, 2012

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)

Related questions

Java Oracle localhost connection error (ORA-12505)

I am trying to currently connect to a database on my current computer. import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { public static void main(String[] argv) throws Exception { Connection connection = null; try { // …

Read More
WFMLRSVCApp.ear file not found

I am trying to install Oracle 11g in my laptop. Im downloading the setup files from here: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html I have downloaded win64_11gR2_database_1of2.zip and win64_11gR2_database_2…

Read More
Error on Oracle while using DBLINK

I am Using jboss5.1.x, EJB3.0 ,JPA3. I am trying to do 'select' query from view which is connected via dblink to another database. source database is Oracle 9, destination dabatase is Oracle 8. I am getting this error: 15:27:06,625 WARN [JDBCExceptionReporter] SQL …

Read More