在java应用程序中与oracle连接 [英] Connection with oracle in java application
问题描述
我已经下载了oracle express 11g版本并安装了。现在我想从java应用程序连接它。这是我的连接代码: -
I have downloaded oracle express 11g edition and installed that.Now i want to connect it from java application. Here is my Connection code :-
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:example", "example","password123");
但是当我试图连接它,它显示我以下异常。
But when i am trying to connect it, it showing me following exception.
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数据库连接时,它是连接。
But when i am trying to connect with "xe" database then it is connected.
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "example","password123");
我不知道为什么会发生这种情况。请给我一些参考或提示。
I dont know why this is happening?. Please give me some reference or hint.
推荐答案
我想你不能理解数据库模式
类型。在oracle数据库的 Oracle
, XE
表示 Express Edition
ORCL
表示 Oracle Corp
。
I think, you are miss understanding between database schema
and database type. In Oracle
, XE
mean Express Edition
of oracle database. ORCL
mean Oracle Corp
.
In mysql
DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "example","password123");
`test` is a database schema.
在Oracle XE中
In Oracle XE
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "example","password123");
DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@myhost:1521:orcl","example", "password123");
`example`, database schema name and DB user name are the same.
这篇关于在java应用程序中与oracle连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!