Io 异常: The Network Adapter could not establish the connection

Question

我循环往oracle数据库中插入数据,当插于一定量条数时(大概5多条记录)就报"Io 异常: The Network Adapter could not establish the connection",请问个是怎么回事?怎样解决啊?

Answer 1

你的插入程序不规范,把协议栈给搞崩溃了吧
你出现异常之后TNSPING 还能连上么?检查一下你的插入程序吧,该及时断掉的空连接要断掉,该及时释放的数据集要及时释放.

Answer 2

我每插入一次就关掉了的啊.
public synchronized boolean getExecute(String sql){//数据插入更新
boolean success = false;
           try{
              conn=DriverManager.getConnection(connStr,"admin","admin");
          
              Statement stmt=conn.createStatement();
              success=stmt.execute(sql);
              success = true;
              stmt.close();
              conn.commit();
              conn.close();
           }catch(SQLException ex){
              System.out.println("数据库异常(getExecute):"+ex.getMessage());
           }
           return success;
          
    }