What steps will reproduce the problem?
1. Search the subscribers of a list
What is the expected output? What do you see instead?
javax.ejb.EJBException: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute query
at com.caucho.ejb.util.XAManager.rethrowEjbException(XAManager.java:353)
at org.subethamail.core.lists.ListMgrBean__ListMgrStatelessProxy.searchSubscribers(ListMgrBean__ListMgrStatelessProxy.java:2683)
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:616)
at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:302)
at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:198)
at com.caucho.hessian.server.HessianServlet.invoke(HessianServlet.java:399)
at com.caucho.hessian.server.HessianServlet.service(HessianServlet.java:379)
at com.caucho.server.dispatch.WebServiceFilterChain.doFilter(WebServiceFilterChain.java:101)
at org.subethamail.web.servlet.ListFilter.doFilter(ListFilter.java:128)
at org.subethamail.web.util.AbstractFilter.doFilter(AbstractFilter.java:53)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:89)
at org.subethamail.web.util.SetRequestCharsetFilter.doFilter(SetRequestCharsetFilter.java:41)
at org.subethamail.web.util.AbstractFilter.doFilter(AbstractFilter.java:53)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:89)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:156)
at com.caucho.server.webapp.AccessLogFilterChain.doFilter(AccessLogFilterChain.java:95)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:287)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:802)
at com.caucho.network.listen.TcpSocketLink.dispatchRequest(TcpSocketLink.java:731)
at com.caucho.network.listen.TcpSocketLink.handleRequest(TcpSocketLink.java:693)
at com.caucho.network.listen.TcpSocketLink.handleRequestsImpl(TcpSocketLink.java:677)
at com.caucho.network.listen.TcpSocketLink.handleRequests(TcpSocketLink.java:623)
at com.caucho.network.listen.AcceptTask.doTask(AcceptTask.java:107)
at com.caucho.network.listen.ConnectionReadTask.runThread(ConnectionReadTask.java:98)
at com.caucho.network.listen.ConnectionReadTask.run(ConnectionReadTask.java:81)
at com.caucho.network.listen.AcceptTask.run(AcceptTask.java:65)
at com.caucho.env.thread.ResinThread.runTasks(ResinThread.java:164)
at com.caucho.env.thread.ResinThread.run(ResinThread.java:130)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:250)
at org.subethamail.core.util.SubEthaEntityManager.findSubscribers(SubEthaEntityManager.java:521)
at org.subethamail.core.lists.ListMgrBean.searchSubscribers(ListMgrBean.java:718)
at org.subethamail.core.lists.ListMgrBean__ListMgrStatelessProxy.searchSubscribers(ListMgrBean__ListMgrStatelessProxy.java:2653)
... 29 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2297)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2204)
at org.hibernate.loader.Loader.list(Loader.java:2164)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:448)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
... 32 more
Caused by: org.postgresql.util.PSQLException: ERROR: for SELECT DISTINCT, ORDER
BY expressions must appear in select list
Position: 519
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
at $Proxy92.executeQuery(Unknown Source)
at com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:108)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1849)
at org.hibernate.loader.Loader.doQuery(Loader.java:718)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2294)
... 40 more
Original issue reported on code.google.com by gilberthuph@gmail.com on 29 Jun 2011 at 4:37
Original issue reported on code.google.com by
gilberthuph@gmail.comon 29 Jun 2011 at 4:37