I get a class exception not related to the mapping, however, I think I am matching it! I have 2 classes ClientAppts and Appointments that have relationships from 1 to many. I want to receive all Clients and dates of their appointment. What causes this? All suggestions are welcome.
Here is the class:
@Entity(name="ClientAppts") @Table(name="person") public class ClientAppts { private Integer person_id; private String fName; private String lName; private Date appt; private String phone; private String cell; private String address1; private String address2; private String city; private String state; private String zip; private String doctor; private String notes; @ElementCollection @CollectionTable(name="Appointment", joinColumns= @JoinColumn(name="person_id")) @Column(name="appt") Collection<Date> appointments;
And here, to be clear, there is a Destination class mentioned above:
@Entity(name="Appointment") @Table(name="appointment") public class Appointment { private int id; private Date appt; private Date apptfinish; private String title; private String location; private BigDecimal fee; private BigDecimal amtPaid; private Boolean serviceRendered; private int person_id; private String description;
And here is the code that throws the exception:
List<ClientAppts> list = getSessionFactory().getCurrentSession().createQuery(" from ClientAppts client order by client.lName ").list();
And finally, the stack trace:
org.hibernate.hql.internal.ast.QuerySyntaxException: ClientAppts not showing [from ClientAppts client order by client.lName] at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister (SessionFactoryHelper.java:1) .hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement (FromElementFactory.java:110) at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement (FromClause.java:93) at orghlate .internal.ast.HqlSqlWalker.createFromElement (HqlSqlWalker.java:326) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement (HqlSqlBaseWalker.java:3252Hl.lh.lhl.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.lh.hl.hl.hl.ln.hl.hl. (HqlSqlBaseWalker. org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.sele ctStatement (HqlSqlBaseWalker.java:287) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement (HqlSqlBaseWalker.java:235) at org.hibernate.hql.internal.ast.qulpl.alytl at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile (QueryTranslatorImpl.java:183) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile (QueryTranslatorImpl.java:136) on org.iberhnn .spi.HQLQueryPlan. (HQLQueryPlan.java:101) at org.hibernate.engine.query.spi.HQLQueryPlan. (HQLQueryPlan.java:80) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan (QueryPlanCache.java:119) at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan (AbstractSessionImplnj.java. internal.AbstractSessionImpl.createQuery (AbstractSessionImpl.java:193) at org.hibernate.internal.SessionImpl.createQuery (SessionImpl.java:1649) at com.dave.user.dao.UserDAO.getClientAppts (UserDAO.java:130) at .dave.user.service.UserService.getClientAppts (UserService.java:126) at sun.reflect.NativeMethodAccessorImpl.invoke0 (native method) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.javalectleglelegethlegleleglelegleleglelegleleglelegleleg .invoke (DelegatingMethodAccessorImpl.java:25) in java.lang.reflect.Method.invoke (Method.java►97) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (AopUtils.javahaps18) at org.spring aop.framework.ReflectiveMethodInvocation.invo keJoinpoint (ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invokework Transaction orgTeraction.orv1 org .aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke (JdkDynamicAopProxy.java:202) in $ Proxy251.getClientAppman (unknown) appended () beanAppointmentsMB.loadAppointments (Assignments MB.java: 45) at com.dave.managed.bean.AppointmentsMB.init (Assignments MB.java: 40) at sun.reflect.NativeMethodAccessorImpl.invoke0 (native method) at sun.reflect.NativeMethodvccessor NativeMethodAccessorImpl.java:39) on sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) in java.lang.re flect.Method.invoke (Method.javaPoint97) at org.glassfish.faces.integration.GlassFishInjectionProvider $ 2.run (GlassFishInjectionProvider.javahaps82) in java.security.AccessController.doPrivileged (native method) at org.glassfish.faces .integration.GlassFishInjectionProvider.invokeLifecycleMethod (GlassFishInjectionProvider.javahaps76) on org.glassfish.faces.integration.GlassFishInjectionProvider.invokePostConstruct (GlassFishInjectionProvider.java:306. ) on com.sun.faces.mgbean.BeanBuilder.invokePostConstruct (BeanBuilder.java:223) on com.sun.faces.mgbean.BeanBuilder.build (BeanBuilder.java:105) on com.sun.faces.mgbean.BeanManager. createAndPush (BeanManager.java:409) on com.sun.faces.mgbean.BeanManager.create (BeanManager.java:269) on com.sun.faces.el.ManagedBeanELResolver.resolveBean (ManagedBeanELResolver.java:244) com .fa ces.el.ManagedBeanELResolver.GetValue (ManagedBeanELResolver.java:116) on com.sun.faces.el.DemuxCompositeELResolver._getValue (DemuxCompositeELResolver.java:176) on com.sun.faces.el.Demux compolveite 203) at com.sun.el.parser.AstIdentifier.getValue (AstIdentifier.java:103) at com.sun.el.parser.AstValue.getValue (AstValue.java:179) at com.sun.el.ValueExpressionImpl.getValue (ValueExpressionImpl.java:224) at com.sun.faces.facelets.el.TagValueExpression.getValue (TagValueExpression.java:109) in javax.faces.component.ComponentStateHelper.eval (ComponentStateHelper.java:194) in javax.faces. component.ComponentStateHelper.eval (ComponentStateHelper.java:182) in javax.faces.component.UIOutput.getValue (UIOutput.java:169) on org.primefaces.component.calendar.CalendarUtils.getValueAsString (CalendarUtils.java:35) on org .primefaces.component.calendar.CalendarRenderer.encodeEnd (CalendarRenderer.java:58) at javax.faces.component.U IComponentBase.encodeEnd (UIComponentBase.java:875) at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive (HtmlBasicRenderer.java data 105) in javax.faces.component.UIComponentBase.encodeChildren (UIComponentBase.java:845) at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive (HtmlBasicRenderer.java:304) on com.sunren.h .GridRenderer.renderRow (GridRenderer.java:185) at com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren (GridRenderer.java:129) in javax.faces.component.UIComponentBase.encodeChildren45 (UIComponentBase.encodeChildren45) javax.faces.component.UIComponent.encodeAll (UIComponent.java:1757) in javax.faces.render.Renderer.encodeChildren (Renderer.java:168) in javax.faces.component.UIComponentBase.encodeChildren (UIComponentBase.java:java in javax.faces.component.UIComponent.encodeAll (UIComponent.java:1757) in javax .faces.component.UIComponent.encodeAll (UIComponent.java:1760) in javax.faces.component.UIComponent.encodeAll (UIComponent.java:1760) in javax.faces.component.UIComponent.encodeAll (UIComponent.java:1760) in com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView (FaceletViewHandlingStrategy.java:402) in com.sun.faces.application.view.MultiViewHandler.renderView (MultiViewHandler.java:131) in javax.faces.application.ViewHandlerWrapper. renderView (ViewHandlerWrapper.java:288) on org.apache.myfaces.tomahawk.application.ResourceViewHandlerWrapper.renderView (ResourceViewHandlerWrapper.java:93) in com.sun.faces.lifecycle.RenderResponsePhase.execute (RenderResponsePh112h com .sun.faces.lifecycle.Phase.doPhase (Phase.java:101) at com.sun.faces.lifecycle.LifecycleImpl.render (LifecycleImpl.java:139) in javax.faces.webapp.FacesServlet.service (FacesServlet.java : 594) at org.apache.catalina.core.StandardWrapper.service (StandardWrapper.java:1542) on org .apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:281) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:175) at org.apache.catalina.core.StandardVipeline.ipipdodo .java: 655) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java//95) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:161) on org.apache.catalina. connector.CoyoteAdapter.doService (CoyoteAdapter.javahaps31) on org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:231) on com.sun.enterprise.v3.services.impl.ContainerMapper $ AdapterCallable.call ( ContainerMapper.javahaps17) on com.sun.enterprise.v3.services.impl.ContainerMapper.service (ContainerMapper.java:195) on com.sun.grizzly.http.ProcessorTask.invokeAdapter (ProcessorTask.java:849) on com .sun.grizzly.http.ProcessorTask.doProcess (ProcessorTask.java:746) at com.sun.grizzly.http.ProcessorTask.process (Pro cessorTask.java:1045) at com.sun.grizzly.http.DefaultProtocolFilter.execute (DefaultProtocolFilter.java:228) at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter (DefaultProtocolChain.java:137) at com.DunocolPain.grotzzrizzf.gzzzzrizz .execute (DefaultProtocolChain.java:104) at com.sun.grizzly.DefaultProtocolChain.execute (DefaultProtocolChain.java:90) at com.sun.grizzly.http.HttpProtocolChain.execute (HttpProtocolChain.java:79) in com.sun. grizzly.ProtocolChainContextTask.doCall (ProtocolChainContextTask.java:54) at com.sun.grizzly.SelectionKeyContextTask.call (SelectionKeyContextTask.java:59) at com.sun.grizzly.ContextTask.run (ContextTask.java:71) at com.s .grizzly.util.AbstractThreadPool $ Worker.doWork (AbstractThreadPool.java∗32) at com.sun.grizzly.util.AbstractThreadPool $ Worker.run (AbstractThreadPool.java UP13) in java.lang.Thread.run (Thread.java : 662)
hibernate
Dave
source share