ssh项目,本来用数据库 mysql 没错,换到oracle启动tomcat的时候就报错标示符无效?哪里有错误呢?2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: create table emep_ApproveInfo (id number(19,0) not null, approveTime timestamp, approval number(1,0), comment varchar2(255 char), formId number(19,0), approverId number(19,0), primary key (id))
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00904: : 标识符无效2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: create table emep_form (id number(19,0) not null, title varchar2(255 char), applyTime timestamp, status varchar2(255 char), year varchar2(255 char), number varchar2(255 char), projectName varchar2(255 char), units varchar2(255 char), makeTaskTime varchar2(255 char), samplingTime varchar2(255 char), endTime varchar2(255 char), analyzeItem varchar2(255 char), objective varchar2(255 char), vehicle varchar2(255 char), peopleNum varchar2(255 char), contact varchar2(255 char), demand varchar2(255 char), isStart varchar2(255 char), projectLeader varchar2(255 char), re varchar2(255 char), informDep varchar2(255 char), acceptDep varchar2(255 char), formTemplateId number(19,0), applicantId number(19,0), primary key (id))
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00904: : 标识符无效2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_ApproveInfo add constraint FK1F039E8F402F4C27 foreign key (approverId) references emep_user
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_ApproveInfo add constraint FK1F039E8FC1A18F5F foreign key (formId) references emep_form
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_form add constraint FK5D3ED230B5FBD1F3 foreign key (formTemplateId) references emep_FormTemplate
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_form add constraint FK5D3ED23069E9E924 foreign key (applicantId) references emep_user
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在
hibernate java 标示符
严重: Unsuccessful: create table emep_ApproveInfo (id number(19,0) not null, approveTime timestamp, approval number(1,0), comment varchar2(255 char), formId number(19,0), approverId number(19,0), primary key (id))
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00904: : 标识符无效2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: create table emep_form (id number(19,0) not null, title varchar2(255 char), applyTime timestamp, status varchar2(255 char), year varchar2(255 char), number varchar2(255 char), projectName varchar2(255 char), units varchar2(255 char), makeTaskTime varchar2(255 char), samplingTime varchar2(255 char), endTime varchar2(255 char), analyzeItem varchar2(255 char), objective varchar2(255 char), vehicle varchar2(255 char), peopleNum varchar2(255 char), contact varchar2(255 char), demand varchar2(255 char), isStart varchar2(255 char), projectLeader varchar2(255 char), re varchar2(255 char), informDep varchar2(255 char), acceptDep varchar2(255 char), formTemplateId number(19,0), applicantId number(19,0), primary key (id))
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00904: : 标识符无效2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_ApproveInfo add constraint FK1F039E8F402F4C27 foreign key (approverId) references emep_user
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_ApproveInfo add constraint FK1F039E8FC1A18F5F foreign key (formId) references emep_form
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_form add constraint FK5D3ED230B5FBD1F3 foreign key (formTemplateId) references emep_FormTemplate
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: Unsuccessful: alter table emep_form add constraint FK5D3ED23069E9E924 foreign key (applicantId) references emep_user
2014-11-13 15:14:52 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00942: 表或视图不存在
hibernate java 标示符
解决方案 »
- 求解:使用ssh框架,为何调试时得不到画面上输入的值?
- Hibernate OSCache 缓存使用问题!
- FTP上传的错误!急!
- 一个strurs+hibernate+spring 整合 的配置问题
- #### EJB ####
- HttpURLConnection.connect() 卡死 死锁怎么解决
- 用struts做jsp无法从.properties文件中获取文本是怎么回事啊?
- 在线急问:开发soap程序用jbulider好吗?
- MVC(如struts)如何解决多个用户操作在同一个页面进行的问题?
- 如何配置tomcat才能实现类似于asp的global功能,实现在线人数的统计?
- 求助 那位高手知道SQLException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP B
- JBPM web designer 怎么保存流程?
你把语句放oracle 运行试试看
2014-11-13 15:39:28 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00904: : 标识符无效我找了半天原来是这个字段出错,这个字段是String类型啊
映射文件:<property name="comment"></property>
没问题啊。。
哈哈 教训的即是。。
严重: Unsuccessful: alter table emep_ApproveInfo add comment varchar2(255 char)
2014-11-13 15:39:28 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
严重: ORA-00904: : 标识符无效
我找了半天原来是这个字段出错,这个字段是String类型啊
映射文件:<property name="comment"></property>
没问题啊。。
COMMENT ON
{ TABLE [ schema. ]
{ table | view }
| COLUMN [ schema. ]
{ table. | view. | materialized_view. } column
| OPERATOR [ schema. ] operator
| INDEXTYPE [ schema. ] indextype
| MATERIALIZED VIEW materialized_view
}
IS 'text' ;用法如下:
1.对表的说明
comment on table table_name is 'comments_on_tab_information';2.对表中列的说明
comment on column table.column_name is 'comments_on_col_information';3.查看表的说明
SQL> select * from user_tab_comments where TABLE_NAME='EMPLOYEES';