0

I try to connect my JavaEE to the Oracle database. If I test the connection from any IDE like DBeaver or from a command prompt there is no problem. I use Eclipse for IDE and Windows 10 for OS. What I tried?

Class.forName("oracle.jdbc.driver.OracleDriver"); 
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","password");
Class.forName("oracle.jdbc.driver.OracleDriver"); 
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/xe","system","password");
Class.forName("oracle.jdbc.driver.OracleDriver"); 
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","password");

Class.forName("oracle.jdbc.driver.OracleDriver"); 
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","password");

I changed ojdbc14 to ojdbc6 I changed drivers and tried to connect to different databases SQL Server and MySql but always throws an exception on Class.forName java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:xeenter image description here

Improve this question
1
  • This seems to be configuration issue, kindly run lsnrctl status and see if you find any configuration errors. See if this post helps ibm.com/support/pages/… Commented Dec 6, 2020 at 11:51

1 Answer 1

Reset to default
0

The SID is wrong try to change in combo box to XE

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I dont have XE on dropdown