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

在最近的项目中碰到一个问题就是我在执行Junit时候,后台报如下的错误:

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17002];
--- The error occurred in com/huawei/support/poapply/orm/poApply.xml.
--- The error occurred while executing update.
--- Check the INSERT INTO SUP_USER_LOGIN_LOG (USERID, LOGINTIME, ACCOUNT_TYPE, LOGIN_IP ) VALUES (?, ?, ?, ? ) .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/huawei/support/poapply/orm/poApply.xml.
--- The error occurred while executing update.
--- Check the INSERT INTO SUP_USER_LOGIN_LOG (USERID,LOGINTIME, ACCOUNT_TYPE, LOGIN_IP ) VALUES (?,?,?,?) .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection


当看到了<The error occurred while executing update. --- Check the SQL Statement (preparation failed). 如是想到是不是SQL的问题,如是琢磨着到了Ibatis的配置文件中检查。发现我的SQL语句是不存在问题的(单独的拿出来发到PL-SQL中执行的时候是OK的),SQL如下:

<!-- 向 登录日志表SUP_USER_LOGIN_LOG中插入数据 -->
<!--Update by **_R09559/ for story_num on date begin->
<insert id="insertLoginInfo" parameterClass="ILoginLogDTO">
<![CDATA[
INSERT INTO SUP_USER_LOGIN_LOG
(USERID,
LOGINTIME,
ACCOUNT_TYPE,
LOGIN_IP
)
VALUES
(#USERID#,
to_date(#LOGINTIME#,'yyyy-MM-dd'),
#ACCOUNT_TYPE#,
#LOGIN_IP#
)
]]>
</insert>
<!--Update by **_R09559/ for story_num on date end -->
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值