在最近的项目中碰到一个问题就是我在执行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 -->
分享到:
相关推荐
NULL 博文链接:https://lbay.iteye.com/blog/784874
The Network Adapter could not establish the connection
Oracle10G控制台解决办法-Io 异常:Unknown host specified解决方法
View各种状态的切换 比如请求网络失败,数据为空,正在加载中不同视图的轻松切换,里面还有好看的dialog噢。
内部自动缓存buffer,友好的关闭流closeQuetly,以LineIterator行迭代器的形式读取文件,流
Could not resolve dependencies for project org.apache.flink:flink-avro-confluent-registry:jar:1.15.3: Could not find artifact io.confluent:kafka-schema-registry-client:jar:6.2.2 in maven 安装本地...
Failure to transfer org.... Original error: Could not transfer artifact org.codehaus.plexus:plexus-io:jar: 1.0.1 from/to central (http://repo.maven.apache.org/maven2): No response received after 60000
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies....
在windows环境下的eclipse或者idea中编写spark应用时,有时为了验证程序功能需要以本地模式运行...java.io.Exception: Could not locate executable null\bin\winutils.exe in the Hadoop binarie 本文件可以解决此异常
网络IO模型:同步IO和异步IO,阻塞IO和非阻塞IO
docker load -i prometheus-adapter-v0.9.1.tar.gz ; docker images |grep k8s.gcr.io/prometheus-adapter/prometheus-adapter
解决删除目录提示:System.IO.IOException: 目录不是空的
Elegantnetwork.github.io:The Elegant Network博客
Eclipse、Myeclipse的输入输出-commons-io-2.4包。官方免费版
报错:java.io.IOException: Could not locate executable null\bin\winutils.exe in the Hadoop binaries.-附件资源
Android Studio上运行Flutter,报错could not find io.flutter:flutter_embedding_debug的错误,需要替换以上zip文件即可,Android Studio 4.2.0, Flutter 2.2.3, Dart 2.13.4
几乎每一种外设都是通过读写设备上的寄存器来进行...CPU对外设IO端口物理地址的编址方式有两种:一种是I/O映射方式(I/O-mapped),另一种是内存映射方式(Memory-mapped)。而具体采用哪一种则取决于CPU的体系结构。
XAdapter Support for the pull-down refresh loading and the addition of multiple header and footer RecyclerViewAdapter Blog:https://7449.github.io/Android_XAdapter/ Screenshots ...
java.io.CharConversionException: isHexDigit.最近项目运行出现了这个问题,刚开始就知道是编码问题,怎么改编码都不正确,在网上搜到的文章。