Issue
I'm trying to establish a new connection with Oracle database with ojdbc7 driver and when I get to the "Customize Connection" step, i get the following message:
Cannot establish a connection to jdbc:oracle:thin:@localhost:1521:XE using oracle.jdbc.OracleDriver (ORA-01017: invalid username/password; logon denied
)
Can anyone explain what to do? I tried putting in different formats of username and password, I tried stopping and then starting the database again (Express Edition 11g), I couldn't find anything on the web...
Solution
Oracle has a very detailed tutorial on how to setup a connection from Netbeans to Oracle Express Edition
https://netbeans.org/kb/docs/ide/oracle-db.html
You can only connect using already existing users, If you want to create a new user you need to do that directly in the database
Regardingthe JDBC url sintax here is an example
jdbc:oracle:thin:@//localhost:1521/xe, username = sys and password = 123456
Answered By - Mauricio Gracia Gutierrez
