斷點

          每天進(jìn)步一點點!
          posts - 174, comments - 56, trackbacks - 0, articles - 21

          異常如下:

          org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 異常: The Network Adapter could not establish the connection)
            at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
            at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
           Caused by: java.sql.SQLException: Io 異常: The Network Adapter could not establish the connection
            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
            at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
           

          主要原因:

          1.可能是server.xml文件的DataSource配置出錯。

          (1).如果用到的是本機上的數(shù)據(jù),本地數(shù)據(jù)源里的部分配置為: username="pcisv62" password="11" url="jdbc:oracle:thin:@localhost:1521:orcl"
          (2).如果用到的是服務(wù)器上的數(shù)據(jù),則數(shù)據(jù)源里的部分配置為: username="pcisv62" password="11" url="jdbc:oracle:thin:@dbserver:1521:corev6"

          (dbserver為服務(wù)器的名字,corev6為服務(wù)器上Oracle的SID)

          2.可能是oracle的tnsnames.ora文件配置出錯。

          oracle的安裝目錄E:\oracle\ora92\network\admin下的tnsnames.ora:
          本地配置:
          ORCL =
            (DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 主機名)(PORT = 1521))
              )
              (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = ORCL)
              )
            )
          或服務(wù)器配置:
          COREV6_DBSERVER =
            (DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = dbserver)(PORT = 1521))
              )
              (CONNECT_DATA =
                (SID = COREV6)
                (SERVER = DEDICATED)
              )
            )


          posted @ 2009-03-04 17:33 斷點 閱讀(3508) | 評論 (0)
          主站蜘蛛池模板: 陵水| 枝江市| 柳州市| 贵阳市| 常熟市| 左权县| 兰坪| 始兴县| 德昌县| 抚远县| 博爱县| 桂阳县| 茌平县| 宜都市| 南雄市| 文登市| 项城市| 海安县| 宿迁市| 通州市| 定州市| 洱源县| 应城市| 巨鹿县| 甘德县| 嘉鱼县| 隆尧县| 保山市| 盘山县| 陇西县| 霞浦县| 大厂| 定南县| 昭觉县| 沽源县| 常宁市| 大理市| 墨竹工卡县| 建始县| 蕉岭县| 上林县|