这是怎么回事,我用的是Hibernate+struts+spring+oracle开发的,这个错误是启动服务器,hibernate更新表结构是报的我把错误信息贴出来
...
17:06:42,296 WARN AnnotationSessionFactoryBean:1019 - Unsuccessful schema statement: create table CustLost (id number(19,0) not null, date timestamp, delay varchar2(255 char), orderDate timestamp, reson varchar2(255 char), state varchar2(255 char), customer_id number(19,0), primary key (id))
java.sql.SQLException: ORA-00904: : 标识符无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:865)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaStatement(LocalSessionFactoryBean.java:1015)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:987)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean$3.doInHibernate(LocalSessionFactoryBean.java:960)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.updateDatabaseSchema
.....
...
17:06:42,296 WARN AnnotationSessionFactoryBean:1019 - Unsuccessful schema statement: create table CustLost (id number(19,0) not null, date timestamp, delay varchar2(255 char), orderDate timestamp, reson varchar2(255 char), state varchar2(255 char), customer_id number(19,0), primary key (id))
java.sql.SQLException: ORA-00904: : 标识符无效 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:865)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaStatement(LocalSessionFactoryBean.java:1015)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:987)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean$3.doInHibernate(LocalSessionFactoryBean.java:960)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.updateDatabaseSchema
.....
解决方案 »
- oracle日期分段
- 在存储过程中如何返回结果集
- 还是ORA-04030错误,高手请指教,如何解决
- 求上百万的access的数据导入到oracle9i中的快速方法
- 请教一个分区的问题
- 我是初学者,想问一下普通用户想要创建多一个用户需不需要dba赋予的权限,如果要那么需要什么权限
- EXECUTE Immediate 在oralce 8中出现的问题
- 请问安装缺这两个件到哪里去下!!
- updating 是什么?---一段触发器看不懂!
- 要microsoft odbc for oracle驱动一定要安装oracle单机版吗?
- 如何高效的比较时间段
- 请问oracle 10g中彻底删除视图,用purge怎么报错?
正确。就是不能使用date作为字段名
还可以这样呢?