Posted on 2010-01-14 22:59
斷點 閱讀(851)
評論(0) 編輯 收藏 所屬分類:
Tomcat
異常如下：
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).如果用到的是本機上的數據，本地數據源里的部分配置為： username="pcisv62" password="11" url="jdbc:oracle:thin:@localhost:1521:orcl"
(2).如果用到的是服務器上的數據，則數據源里的部分配置為： username="pcisv62" password="11" url="jdbc:oracle:thin:@dbserver:1521:corev6"
（dbserver為服務器的名字，corev6為服務器上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)
)
)
或服務器配置：
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)