网站公告列表

  没有公告

加入收藏
设为首页
联系站长
您现在的位置: 网络学院 >> 程序设计 >> Java编程 >> 文章正文
  异常java.sql.sqlexception: io exception:the network adapter could not establish connection          【字体:
异常java.sql.sqlexception: io exception:the network adapter could not establish connection
作者:佚名    文章来源:不详    点击数:    更新时间:2007-7-7    
正在装载数据……
    Oracle Database Connection (from oracle.com)
    
    PROBLEM
    You are attempting to connect to an Oracle instance using JDBC and you are receiving the following error.
    java.sql.SQLException: Io exception:
    The Network Adapter could not establish connection
    SQLException: SQLState (null) vendor code (17002)
    
    Any or all of the following conditions may also apply:
    
    1) You are able to establish a SQL*Plus connection from the same
    client to the same Oracle instance.
    
    2) You are able to establish a JDBC OCI connection, but not a Thin
    connection from the same client to the same Oracle instance.
    
    3) The same JDBC application is able to connect from a different
    client to the same Oracle instance.
    
    4) The same behavior applies whether the initial JDBC connection
    string specifies a hostname or an IP address.
    
    
    
    REDISCOVERY
    To verify whether you are hitting this problem, verify whether the Oracle instance is configured for Multithreaded Server (MTS). If the Oracle instance is not configured for MTS, you are probably encountering a different problem. Otherwise, continue. Try forcing the JDBC connection to use a dedicated server instead of a shared server. This can be accomplished in several ways. For JDBC OCI or Thin, this can be done by reconfiguring the server for dedicated connections only. This approach, however, may not be feasible in many cases. In such cases, the following options apply: For JDBC OCI:
    
    1) Add the (SERVER=DEDICATED) property to the TNS connect string
    stored in the tnsnames.ora file on the client.
    
    2) Set the user_dedicated_server=ON in sqlnet.ora on the client.
站内文章搜索 高级搜索
文章录入:admin    责任编辑:admin 
  • 上一篇文章:

  • 下一篇文章:
  • 发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口
    最新热点 最新推荐 相关文章
     用java实现web服务器
     用java快速开发linux gu…
     正则表达式分解siemens交…
     [portal参考手册]目录
     jsp中调用oracle存储过程…
  • JSP中JavaBean的生命周期

  • Java Swing实现俄罗斯方块

  • 快速、简便使用AJAX技术的三…

  • java异常处理机制的深入理解

  • [转]Java堆和栈的区别 经典总…

  • 关于java Applet

  • java 设计工厂模式

  • Core Java 之旅

  • 专访Java之父:Java未来的发…

  • 开发手记---JAVA数据库连接池

  •   网友评论:(只显示最新10条。评论内容只代表网友观点,与本站立场无关!)
    网络学院©2007 www.23book.net
    为您提供web编程,vb编程,vc编程,服务器架设管理,数据库设计等方面的知识 站长:David