java初学者 加入小组

273个成员 61个话题 创建时间:2015-02-03

关于无法连接上ORACLE数据库的问题

发表于10天前 30次查看

代码如下:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

 

public class LoadingDriverDemo {

    public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";

    public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:mldn";

    public static final String DBUSER = "scott";

    public static final String PASSWORD = "tiger";

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

//第一步:加载数据库驱动程序

Class.forName(DBDRIVER);//向容器中加载驱动中的连接类

//第二步:取得数据库连接对象

Connection conn = DriverManager.getConnection(DBURL,DBUSER,PASSWORD);

System.out.println("数据库已连接");

//第三步:取得数据库连接对象

Statement stmt = conn.createStatement();//创建数据库

String sql = "INSERT INTO member(id,name,age,birthday,note)"

+"VALUES(myseq.nextval,'张三',"

+"10,TO_DATE('1990-10-01','yyyy-MM-dd'),暂无";

int len = stmt.executeUpdate(sql);   //执行更新,返回更新行数

System.out.println("影响的数据行数"+len);

//第四步:关闭数据库连接

conn.close();

}

}

 

错误提示:

Exception in thread "main" 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:412)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.yige.JDBC.LoadingDriverDemo.main(LoadingDriverDemo.java:17)

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

 

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)

... 7 more

1回复
  • 2楼 SuperMan亦歌 10天前

    数据库监听服务OracleOraDb11g_home1TNSListener和OracleServiceMLDN都是开启的

发表回复
你还没有登录,请先登录注册