今天遇到一个很奇怪的问题 我在数据库这边一张表修改一个字段 改成功了 就是改完 代码报错 但是只报一次 后来就正常了 很奇怪不知道是数据库的问题还是开发的问题 数据库版本 11.2.0.4 java开发框架 springmvc+tomcat
2022-08-25 19:43:30.105 [Thread-9] ERROR c.e.controller.CloudOrderController-getNewCloudOrderListV2-Line:159 getNewCloudOrderListV2
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: java.sql.SQLException: Schema changed
### The error may exist in file [/opt/eastmoney/tomcat-9.0.37/webapps/cs-futures/WEB-INF/classes/com/eastmoney/mapper/xml/CloudOrderMapper.xml]
### The error may involve com.eastmoney.mapper.CloudOrderMapper.getCloudOrderListV2-Inline
### The error occurred while setting parameters
### SQL: select * from ( select tmp_page.*, rownum row_id from ( select * from CloudOrder WHERE account=? AND ((orderType > 2 AND (status=2 OR status=12)) OR (orderType <=2 AND offsetFlag!=0)) AND status <200 order by itime desc ) tmp_page where rownum <= ? ) where row_id > ?
### Cause: java.sql.SQLException: Schema changed
; uncategorized SQLException for SQL []; SQL state [99999]; error code [17294]; Schema changed; nested exception is java.sql.SQLException: Schema changed
墨值悬赏


评论

