在最近的项目中碰到一个问题就是我在执行Junit时候,后台报如下的错误:
当看到了<The error occurred while executing update. --- Check the SQL Statement (preparation failed). 如是想到是不是SQL的问题,如是琢磨着到了Ibatis的配置文件中检查。发现我的SQL语句是不存在问题的(单独的拿出来发到PL-SQL中执行的时候是OK的),SQL如下:
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 -->