问题描述;oracle10g连接oracle11g 视图v_pick_orders_watch 取自11g数据
javax.servlet.ServletException: StatementCallback; uncategorized SQLException for SQL [select *
from v_pick_orders_watch]; SQL state [null]; error code [0]; Invalid scale size. Cannot be less
than zero; nested exception is java.sql.SQLException: Invalid scale size. Cannot be less than
zero
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:515)
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419)
root cause
解决:1、原有后台解析sql用了 *;应该写上相应的字段名称;注意把数据字段用nvl(字段,0)函数;保证有数据;
2、SqlRowSet rs = this.getJdbcTemplate().queryForRowSet(sql);结果集是null;也会报错;
改为其他方式获取;如this.getJdbcTemplate().queryForList(sql);原因是Spring中实现的问题;
3、oracle9i或oracle10个dlink连接oracle11g的密码加“小写密码”;
相关推荐
NULL 博文链接:https://gembler.iteye.com/blog/346242
oracle error invalid rowid
OS error code 0: Success 操作系统错误代码0:成功 OS error code 1: Operation not permitted 操作系统错误代码1:操作不允许 OS error code 2: No such file or directory 操作系统错误代码2:没有这样的文件或...
python——pip install xxx报错SyntaxError: invalid syntax 在安装好python后,进入python运行环境后,因为我要用pip安装开发Web App需要的第三方库,执行pip install aiohttp,发现会报错SyntaxError: invalid ...
主要介绍了for循环中删除map中的元素valgrind检测提示error:Invalid read of size 8 的相关资料,需要的朋友可以参考下
今天我的朋友用了我发给他的文件后总是显示 Error: User Command terminated, Exit-Code = 1,在我这边又可以显示ok,排查了一下原因和网上的资料之后在这里做一下总结。
Error response from daemon: rpc error: code = FailedPrecondition desc = node y2qsyjdbfmm4tjwh4p9wqlmq1 is not down and can’t be removed 解决(需要把active状态的节点的docker服务关闭;同时在manager节点中...
Delphi 10.3 ,程序运行到DataModule2.ClientDataSet1.ApplyUpdates(0);语句时,提示“Invalid parameter”错误
jspdf html页面生成pdf j jspdf html页面生成pdfspdf html页面生成pdf
SQL Prompt - Provides intelligent code completion for SQL Server editors SQL Server developers and DBAs use SQL Prompt to: Write SQL smoothly, with code-completion and SQL snippets Check database ...
使用rsync/cwrsync工具进行档案同步的时候出现了...rsync error: error starting client-server protocol (code 5) at main.c(1506) [Receiver=3.0.7] 解决办法:在rsyncd.conf文件中添加下面两行即可解决问题 uid =
微软sql server,SQL语句常见错误,有描述有问题有答案。
SQL Prompt - Provides intelligent code completion for SQL Server editors SQL Server developers and DBAs use SQL Prompt to: Write SQL smoothly, with code-completion and SQL snippets Check database...
SQL Prompt - Provides intelligent code completion for SQL Server editors SQL Server developers and DBAs use SQL Prompt to: Write SQL smoothly, with code-completion and SQL snippets Check database ...
关于pip install xxx报错SyntaxError:invalid syntax的解决方法 声明:1.以下均以pip install requests举例; 2.Windows系统; 首先,看自己是否在python环境中运行了pip,若是,请打开“开始”菜单,输入cmd,找到...
These updates do not constitute a consistent state. This property is often called serializability. For example, a second transaction traversing the doubly linked list mentioned above would see the ...
Python系列:error: invalid command ‘egg-info‘ 安装optuna时报错
common error analysis memory leakage & invalid pointer update 1127/08 23:23PM sorry, it may be removed by Manager. this resource doesn't exist now. you can't download it