`
wkf41068
  • 浏览: 453626 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
社区版块
存档分类
最新评论

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 -->
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics