Caused by: java.sql.SQLException: Io 错误: The Network Adapter could not esta(2)

2012-10-15

Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not esta(2)本篇是接上篇的(1)而

Caused by: java.sql.SQLException: Io 异常: The Network Adapter could not esta(2)
本篇是接上篇的(1)而言的。
(1) 在找问题根源的时候，想到没有更改过applicationContext.xml，而且所以就没有向配置文件着手来做一直在坚持Java代码是否有误，在反复确定Java代码无误后，才抱着试一试的态度，取查看了applicationContext.xml，发现有关数据源的链接是发生改变了(其它人在用我的环境做测试，没有告知他改过该文件)
出现问题的配置如下：

 <property name="driverUrl"            value="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.49.111)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.49.113)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.49.122)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = dev)))" />

而其实我们的配置应该如下所示：

 <property name="driverUrl"           value="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.14.5.194)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = support)))" />

当修改了，在重新走测试用例的时候，通过。

问题的小结：
(1) 在碰到执行数据库操作出现 The Network Adapter could not establish the connection错误提示时，应该能想到项目中那些配置文件配置了和数据的链接。<本项目中用到的是:applicationContext.xml>
在报The Network Adapter could not establish the connection的时候，连带的还报出错误：
--- The error occurred in com/huawei/support/poapply/orm/poApply.xml.
--- The error occurred while executing update.
--- Check the SQL Statement (preparation failed).
此类问题就我的分析是：原来的配置文件中指定的数据库连接出现异常，即使连接正确，也会报出执行SQL出错(因为在连接的库中没有相应的表)

热点排行

网络协议

Caused by: java.sql.SQLException: Io 错误: The Network Adapter could not esta(2)