Nick
Nick

Reputation: 147

How to connect to oracle database as sysdba without user from java?

I can connect to Oracle in the following way: sqlplus / as sysdba. Can I connect in the same way from java? According to the docs (https://docs.oracle.com/cd/B19306_01/java.102/b14355/urls.htm#CHDJICFH), I have to have sys schema with the password, but I don't have any user.

Upvotes: 1

Views: 1119

Answers (1)

ibre5041
ibre5041

Reputation: 5298

This is not supported by Thin JDBC drivers.

When you execute sqlplus / as sysdba then your sqlplus spawns a child oracle process and then talks to it via pipe. So you completely bypass a network stack.

Upvotes: 1

Related Questions