xautlx / s2jh

A Java/J2EE development framework for enterprise system based on Struts/Spring/JPA/Hibernate and jquery/bootstrap
GNU Lesser General Public License v3.0
321 stars 242 forks source link

后台运行报错,估计是报表模块的问题 #5

Closed smilesman closed 11 years ago

smilesman commented 11 years ago

09:15:21.031 ERROR jdbc.sqltiming[139] - 10. Statement.executeUpdate(alter table t_rpt_report_param add hidden number(1,0)) FAILED! alter table t_rpt_report_param add hidden number(1,0) {FAILED after 121 msec}
java.sql.SQLException: ORA-01430: 表中已存在要添加的列 09:15:21.031 ERROR o.h.tool.hbm2ddl.SchemaUpdate[235] - HHH000388: Unsuccessful: alter table t_rpt_report_param add hidden number(1,0)
09:15:21.031 ERROR o.h.tool.hbm2ddl.SchemaUpdate[236] - ORA-01430: 表中已存在要添加的列

xautlx commented 11 years ago

把对应字段或表删除重建试试。

在 2013-8-5,9:16,"邢凌霄" notifications@github.com 写道:

09:15:21.031 ERROR jdbc.sqltiming[139] - 10. Statement.executeUpdate(alter table t_rpt_report_param add hidden number(1,0)) FAILED! alter table t_rpt_report_param add hidden number(1,0) {FAILED after 121 msec}

java.sql.SQLException: ORA-01430: 表中已存在要添加的列 09:15:21.031 ERROR o.h.tool.hbm2ddl.SchemaUpdate[235] - HHH000388: Unsuccessful: alter table t_rpt_report_param add hidden number(1,0)

09:15:21.031 ERROR o.h.tool.hbm2ddl.SchemaUpdate[236] - ORA-01430: 表中已存在要添加的列

— Reply to this email directly or view it on GitHub.

xautlx commented 11 years ago

在本地Oracle环境无法重现问题:

CREATE TABLESPACE SHOWCASE DATAFILE 'SHOWCASE' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON;

--DROP USER SHOWCASE CASCADE;

CREATE USER SHOWCASE IDENTIFIED BY "SHOWCASE" DEFAULT TABLESPACE "SHOWCASE" QUOTA UNLIMITED ON "SHOWCASE";

GRANT CONNECT, RESOURCE, CREATE VIEW TO SHOWCASE;