Oracle数据库直连IO异常,更改localhost为本机IP地址后运行正常

最新推荐文章于 2022-08-08 13:06:46 发布

alfred-sun

最新推荐文章于 2022-08-08 13:06:46 发布

阅读量917

点赞数

分类专栏：项目文章标签： oracle10g 数据库异常 localhost

本文链接：https://blog.csdn.net/alfedsun/article/details/48161977

版权

项目专栏收录该内容

2 篇文章 0 订阅

订阅专栏

2015年9月1日19:03:39

//一星期内都被这个IO异常搞的烦躁不已，不停的倒包建库建监听始终是IO异常，今天破罐破摔之后居然成功了，记录一下。

//BaseDAO 惨烈的注释见证我的血泪史

//此为Oracle数据库连接类  Connection getCon 
//目标数据库 NEUEDU login
package DAO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class baseDAO {
	public Connection getCon()
	{
		Connection con=null;
		try {
			Class.forName//("sun.jdbc.odbc.JdbcOdbcDriver");
			//("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //sql server
			//("com.mysql.jdbc.Driver");			//mysql
			//("sun.jdbc.odbc.JdbcOdbcDriver");		//桥接 read只读事务类型，不能添加数据，改为mysql
			("oracle.jdbc.OracleDriver");			//直连IO异常 改为桥接 数据源 Ora_local
			
			
			con=DriverManager.getConnection//("jdbc:odbc:Ora_local","scott","tiger");
			//("jdbc:sqlserver://localhost:1433;database=master","sa","sql2008");	//sql server
			//("jdbc:mysql://localhost:3306/alfred","root","msysql");				//mysql
	        //+ "user=root&password=147258&useUnicode=true&characterEncoding=GBK");	//mysql
			//("jdbc:odbc:Ora_local","scott","tiger");
			
			//("jdbc:Oracle:thin:@localhost:1521:neuedu","scott","tiger");<span style="white-space:pre">	</span>// DO NOT　USE LOCALHOST!!!!!!!!!!!!!
			("jdbc:oracle:thin:@10.25.44.17:1521:NEUEDU","scott","tiger");
			System.out.println("ok");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
	}
	public static void main(String[] args)
	{
		baseDAO bd=new baseDAO();
		bd.getCon();
	}

}

//本地Localhost无异常

# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

127.0.0.1       localhost

127.0.0.1       localhost