[code="java"][/code]现在我由于不得已操作中间表 在做分页的时候 总是报ERROR - ORA-00918: 未明确定义列 但是做搜索全部的时候却不会报 在这里请教下各位！！
[color=red]java code：[/color]
[code="java"]
public List getCoandmaFenye(final int pageNo, final int pageSize,
final int cid) throws Exception {
List list = (List) this.getHibernateTemplate()
.executeFind(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session
.createQuery("from Coandma coandma where coandma.cid=?");
query.setParameter(0, cid);
query.setFirstResult(pageNo * (pageSize))
.setMaxResults(pageSize);
return query.list();
}
});
return list;
}
[/code]
[color=red]
hbm.xml[/color]
[code="java"]
[/code]
错误
[code="java"]
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:615)
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.executeFind(HibernateTemplate.java:343)
at com.kinrich.mediaStorage.daoimp.CoandmaDaoImp.getCoandmaFenye(CoandmaDaoImp.java:28)
at com.kinrich.mediaStorage.action.CoandmaAction.getList(CoandmaAction.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.kinrich.mediaStorage.Interceptor.CheckInterceptor.doFilter(CheckInterceptor.java:38)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
[/code]
希望能各位能帮下 谢谢了！！ 都搞了一个星期了 就是弄不出来
[quote]org.hibernate.dialect.Oracle9Dialect[/quote]
你的数据库是 oracle 9i 的么？
假如不加后面的setFirstResult，也就是直接取所有可以吗？
应该改成from Coandma as coandma where coandma.cid=?"
或者直接 from Coandma where cid=?"
[quote]
Query query = session.createQuery("from Coandma coandma where coandma.cid=?");
query.setParameter(0, cid);
[/quote]
改为
[code="java"]
Query query = session.createQuery("from Coandma coandma where coandma.cid=?");
query.setInteger(0, new Integer(cid));
[/code]
或者：
[code="java"]
Query query = session.createQuery("from Coandma coandma where coandma.cid= :tempCid");
query.setParameter("tempCid", new Integer(cid));
[/code]
试试
[quote]我试了你说的方法 不行 还是报那个错误 [/quote]
加 as
你的 coandma.cid 是什么类型的？
[quote]去掉 setFirstResult报错 Caused by: java.sql.SQLException: 对只转发结果集的无效操作: absolute [/quote]
那你等于说直接取得就不行？不分页的时候就不行？
[quote]而且 我那是Oracle操作 我那样的sql语句可以执行的 就没有必要去加as了 [/quote]
no 你试试吧
[quote]
Query query = session.createQuery("from Coandma coandma where coandma.cid=?");
[/quote]
它产生的SQL语句应该会在控制台打印出来的吧，你把它贴出来看看呢？
[quote]
[/quote]
你直接把这个语句搬到 oracle 中去运行看它报不报错。注意修改一下表名和 ? 的值。
那你改为这个呢：
[quote]
[/quote]
在里面那个 where里面 加一个
rownum>5
外面 rownum<10
[quote]
[/quote]
把上面的
[quote]
[/quote]
这两句去掉，试试呢
这问题太奇怪了
不会是
[quote] coandma0_.ID as ID2_, [/quote]
不会是这个ID取名的问题吧，
反正 sqlserver有这个问题，但是oracle应该不会啊 晕
不明白，下面这个为什么会要写两遍：
[quote]
[/quote]
只是大小写不同而已。
我认为，父查询在根据这个子查询进行查询的时候，发现子查询中有两对列名是一样的，导致它无法确定查找哪一列，从而报了这个异常。
参见： [url]http://king520.iteye.com/blog/895216[/url]
[quote]去掉报缺少表达式[/quote]
不会吧，是不是你忘了删结尾的 逗号 了？
另外，看一下你的 hibernate.dialect 这个值是不是 org.hibernate.dialect.OracleDialect
工程中应有
[quote] hibernate.properties 或 hibernate.cfg.xml [/quote]
二者之一
那你搜一下 hibernate.dialect 看看