在java应用程序中与oracle连接

发布时间：2020-12-15 04:59:07 所属栏目：Java 来源：网络整理

导读：我已经下载了oracle express 11g版并安装了.现在我想从 java应用程序连接它.这是我的连接代码： – Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:exa

我已经下载了oracle express 11g版并安装了.现在我想从 java应用程序连接它.这是我的连接代码： –

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:example","example","password123");

但是当我试图连接它时,它会向我显示以下异常.

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

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at javaapplication3.JavaApplication3.main(JavaApplication3.java:40)

但是,当我尝试连接“xe”数据库时,它已连接.

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();   
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","password123");

我不知道为什么会这样？请给我一些参考或提示.

解决方法

我认为,您在数据库架构和数据库类型之间存在误解.在Oracle中,XE表示oracle数据库的Express Edition. ORCL意味着Oracle公司

在mysql中

DriverManager.getConnection("jdbc:mysql://localhost:3306/test","password123");

`test` is a database schema.

在Oracle XE中

DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","password123");
DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@myhost:1521:orcl","password123");

`example`: database schema name and DB user name are the same.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!