问题描述;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,排查了一下原因和网上的资料之后在这里做一下总结。
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
It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. •Code-completion and SQL snippets •Backwards compatibility •SQL ...