12:46:09,710 ERROR JDBCExceptionReporter:78 - ORA-00942: 表或視圖不存在java
12:46:09,756 ERROR UserInfoDAO:91 - find by property name failed
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:630)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
at com.jboa.dao.impl.UserInfoDAO.findByProperty(UserInfoDAO.java:89)
at com.jboa.dao.impl.UserInfoDAO.findByUName(UserInfoDAO.java:98)
at com.jboa.service.impl.UserInfoServiceImpl.findByUName(UserInfoServiceImpl.java:44)
at com.jboa.action.UserInfoAction.login(UserInfoAction.java:33)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)spring
網頁顯示:數據庫
type Exception reportoracle
messageapp
descriptionThe server encountered an internal error () that prevented it from fulfilling this request.測試
exceptionthis
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630) org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921) org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917) com.jboa.dao.impl.UserInfoDAO.findByProperty(UserInfoDAO.java:89) com.jboa.dao.impl.UserInfoDAO.findByUName(UserInfoDAO.java:98) com.jboa.service.impl.UserInfoServiceImpl.findByUName(UserInfoServiceImpl.java:44) com.jboa.action.UserInfoAction.login(UserInfoAction.java:33) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597)
解決方法:修改hibernate.reveng.xml、applicationContext.xml、還有vo實體中的xxx.hbm.xml名稱 :shchema+username+實體schema中的名稱一個定要統一一致,數據庫登陸名不分大小寫url
hibernate.reveng.xml:spa
<tablename="xxx"schema="OA"class="com.jbit.vo.xxx">hibernate
applicationContext.xml:
<propertyname="url"value="jdbc:oracle:thin:@localhost:1521:orcl"></property>
<propertyname="username"value="oa"></property>
<property name="password"value="bdqn"></property>
實體中xxx.hbm.xml
<class name="com.jbit.vo.xxx" table="xxx" schema="OA">
總結:
出現這個錯誤實在是不該該的。因爲第一次開發企業級的項目在前期工做沒有考慮全面,在數據庫的名稱的規定沒有一個文檔說明就開始咱們的項目搭建和開發。完成後高高興興的把項目帶過來,準備開發測試另外一臺機上的項目結果就是如上圖。
前期的工做一點都不能馬虎,不緊要速度還要質量,文檔必定要把基本的規範作好。統一是很是重要。