Question

用ssh框架中的hql语句访问数据库对象名无效

sql server中存在对应的表,不过是db_eshop.dbo.category,不过在hql语句中写上db_eshop.dbo.category，会提示找不到，请高手帮助，谢谢！
Hibernate: select category0_.ID as ID, category0_.CateName as CateName8_, category0_.CateDesc as CateDesc8_ from db_eshop.category category0_ order by category0_.ID
2014-05-03 22:00:08 [日志信息] SQL Error: 208, SQLState: S0002
2014-05-03 22:00:08 [日志信息] 对象名 'db_eshop.category' 无效。
2014-05-03 22:00:08 [日志信息] 在执行MerServiceImpl类中的browseCategory方法时出错：
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:890)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at com.service.MerServiceImpl.browseCategory(MerServiceImpl.java:40)
at com.struts.action.MerAction.browseIndexMer(MerAction.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:606)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

Answer 1

你该调用你的实体类的名字而不是表的名字

Answer 2

在hibernate对应的hbm.xml文件里面会配置相应的table，你看看里面配置都对的么