请高手解决啊 小弟我今天到公司分部,把公司项目的oracle数据库移植到分部的服务器上,相应ip什么也改了,启动项目成功,登录平台时出现下面的问题:
Hibernate: select ssouser0_.ID as ID48_, ssouser0_.FLAG_ISVALID as FLAG2_48_, ssouser0_.FLAG_BAK as FLAG3_48_, ssouser0_.LOGIN_ID as LOGIN4_48_, ssouser0_.PASSWORD as PASSWORD48_, ssouser0_.LOGIN_NUM as LOGIN6_48_, ssouser0_.LAST_LOGIN_DATE as LAST7_48_, ssouser0_.LAST_LOGIN_IP as LAST8_48_, ssouser0_.IS_MULTI_ROLE as IS9_48_ from CUG.SSO_USER ssouser0_ where ssouser0_.LOGIN_ID='wangqy'
Hibernate: select this_.ID as ID26_1_, this_.FLAG_ISVALID as FLAG2_26_1_, this_.FK_SSO_USER_ID as FK3_26_1_, this_.FLAG_GENDER as FLAG4_26_1_, this_.FLAG_CMS_MAG as FLAG5_26_1_, this_.NAME as NAME26_1_, this_.TRUE_NAME as TRUE7_26_1_, this_.MOBILE_PHONE as MOBILE8_26_1_, this_.PHONE as PHONE26_1_, this_.CARD_NO as CARD10_26_1_, this_.EMAIL as EMAIL26_1_, this_.SIGN_DATE as SIGN12_26_1_, this_.login_id as login13_26_1_, ssouser1_.ID as ID48_0_, ssouser1_.FLAG_ISVALID as FLAG2_48_0_, ssouser1_.FLAG_BAK as FLAG3_48_0_, ssouser1_.LOGIN_ID as LOGIN4_48_0_, ssouser1_.PASSWORD as PASSWORD48_0_, ssouser1_.LOGIN_NUM as LOGIN6_48_0_, ssouser1_.LAST_LOGIN_DATE as LAST7_48_0_, ssouser1_.LAST_LOGIN_IP as LAST8_48_0_, ssouser1_.IS_MULTI_ROLE as IS9_48_0_ from CUG.PE_MANAGER this_ inner join CUG.SSO_USER ssouser1_ on this_.FK_SSO_USER_ID=ssouser1_.ID where ssouser1_.LOGIN_ID=?
2011-08-02 03:22:25,843 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] ORA-00904: "THIS_"."LOGIN_ID": 标识符无效org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)
at com.whaty.platform.entity.dao.hibernate.GeneralHibernateDao.getList(GeneralHibernateDao.java:191)
at com.whaty.platform.sso.service.SsoUserServiceImp.CheckSsoUserByType(SsoUserServiceImp.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:623)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at o
Hibernate: select ssouser0_.ID as ID48_, ssouser0_.FLAG_ISVALID as FLAG2_48_, ssouser0_.FLAG_BAK as FLAG3_48_, ssouser0_.LOGIN_ID as LOGIN4_48_, ssouser0_.PASSWORD as PASSWORD48_, ssouser0_.LOGIN_NUM as LOGIN6_48_, ssouser0_.LAST_LOGIN_DATE as LAST7_48_, ssouser0_.LAST_LOGIN_IP as LAST8_48_, ssouser0_.IS_MULTI_ROLE as IS9_48_ from CUG.SSO_USER ssouser0_ where ssouser0_.LOGIN_ID='wangqy'
Hibernate: select this_.ID as ID26_1_, this_.FLAG_ISVALID as FLAG2_26_1_, this_.FK_SSO_USER_ID as FK3_26_1_, this_.FLAG_GENDER as FLAG4_26_1_, this_.FLAG_CMS_MAG as FLAG5_26_1_, this_.NAME as NAME26_1_, this_.TRUE_NAME as TRUE7_26_1_, this_.MOBILE_PHONE as MOBILE8_26_1_, this_.PHONE as PHONE26_1_, this_.CARD_NO as CARD10_26_1_, this_.EMAIL as EMAIL26_1_, this_.SIGN_DATE as SIGN12_26_1_, this_.login_id as login13_26_1_, ssouser1_.ID as ID48_0_, ssouser1_.FLAG_ISVALID as FLAG2_48_0_, ssouser1_.FLAG_BAK as FLAG3_48_0_, ssouser1_.LOGIN_ID as LOGIN4_48_0_, ssouser1_.PASSWORD as PASSWORD48_0_, ssouser1_.LOGIN_NUM as LOGIN6_48_0_, ssouser1_.LAST_LOGIN_DATE as LAST7_48_0_, ssouser1_.LAST_LOGIN_IP as LAST8_48_0_, ssouser1_.IS_MULTI_ROLE as IS9_48_0_ from CUG.PE_MANAGER this_ inner join CUG.SSO_USER ssouser1_ on this_.FK_SSO_USER_ID=ssouser1_.ID where ssouser1_.LOGIN_ID=?
2011-08-02 03:22:25,843 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] ORA-00904: "THIS_"."LOGIN_ID": 标识符无效org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)
at com.whaty.platform.entity.dao.hibernate.GeneralHibernateDao.getList(GeneralHibernateDao.java:191)
at com.whaty.platform.sso.service.SsoUserServiceImp.CheckSsoUserByType(SsoUserServiceImp.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:623)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
at o
解决方案 »
- 菜鸟求助! 如何在一个页面调用多个action
- 倾家荡产为大虾们指条路
- 在校软件工程学生该如何为自己的职业java生涯作准备。
- 急!!页面跳转的问题,搞了很久了
- 关于hibernate,对同一个对象的多个实例入库
- Spring+Struts2+JPA集成
- 我的tomcat4.1的控制台也显示“WebappClassLoader: Lifecycle error : CL stopped”,什么意思?
- 有谁知道这个错误?关于struts的。
- sybase 12.0 以前的版本 是否在jdbc中支持rs.last(),rs.absolute()等操作row的方法?
- 究竟JBOSS,WEBLOGIC,WEBSPHERE是不是包括了TOMCAT在里面?
- 编程解决各种问题(一)----Flash 经典智力游戏(一) 人羊菜以及狼的故事
- 第二个小问题 jsp ,在线等。
schema去掉 不能吧
数据库中还真没有LOGIN_ID 原来是公司更新po类映射
但是数据表字段没有修改
多谢了
数据库中还真没有LOGIN_ID 原来是公司更新po类映射
但是数据表字段没有修改
多谢了