Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 21st, 2012  |  syntax: None  |  size: 19.39 KB  |  hits: 6  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to implement self join in JPA?
  2. create table ServiceType (
  3. typeCode varchar(32),
  4. parentTypeCode varchar(32),
  5. description varchar(255),
  6. primary_key(typeCode))
  7.        
  8. @Entity
  9.     @Table(name="ServiceType")
  10.     public class ServcieType implements java.io.Serializable {
  11.         @Id
  12.         protected String typeCode;
  13.  
  14.         protected String description;
  15.  
  16.         @ManyToOne
  17.         protected ServiceType parent;
  18.  
  19.         @OneToMany
  20.         protected Set<ServiceType> children;
  21.  
  22.         .... following is the setter and getter ...
  23.     }
  24. }
  25.        
  26. Exception in thread "main" javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.ifs.ejb.product.entity.ServiceType#PAYMENT]
  27.     at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:77)
  28.     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
  29.     at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
  30.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  31.     at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
  32.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  33.     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
  34.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  35.     at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
  36.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  37.     at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
  38.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  39.     at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
  40.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  41.     at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
  42.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  43.     at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:421)
  44.     at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:53)
  45.     at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
  46.     at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
  47.     at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891)
  48.     at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744)
  49.     at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697)
  50.     at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:524)
  51.     at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232)
  52. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.ifs.ejb.product.entity.ServiceType#PAYMENT]
  53.     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)
  54.     at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202)
  55.     at org.jboss.jpa.tx.TransactionScopedEntityManager.find(TransactionScopedEntityManager.java:176)
  56.     at com.ifs.ejb.product.service.ServiceManagerBean.fetchServiceType(ServiceManagerBean.java:27)
  57.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  58.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  59.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  60.     at java.lang.reflect.Method.invoke(Method.java:597)
  61.     at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
  62.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
  63.     at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
  64.     at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
  65.     at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
  66.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  67.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  68.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  69.     at java.lang.reflect.Method.invoke(Method.java:597)
  70.     at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
  71.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  72.     at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
  73.     at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1531239547.invoke(InvocationContextInterceptor_z_fillMethod_1531239547.java)
  74.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  75.     at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
  76.     at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1531239547.invoke(InvocationContextInterceptor_z_setup_1531239547.java)
  77.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  78.     at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
  79.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  80.     at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
  81.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  82.     at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
  83.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  84.     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
  85.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  86.     at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
  87.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  88.     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
  89.     at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
  90.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  91.     at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
  92.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  93.     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
  94.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  95.     at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
  96.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  97.     at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
  98.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  99.     at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
  100.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  101.     at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
  102.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  103.     at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:421)
  104.     at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:53)
  105.     at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
  106.     at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
  107.     at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891)
  108.     at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744)
  109.     at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697)
  110.     at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:524)
  111.     at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232)
  112.     at org.jboss.remoting.MicroRemoteClientInvoker.invoke(MicroRemoteClientInvoker.java:211)
  113.     at org.jboss.remoting.Client.invoke(Client.java:1724)
  114.     at org.jboss.remoting.Client.invoke(Client.java:629)
  115.     at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:60)
  116.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  117.     at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:61)
  118.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  119.     at org.jboss.ejb3.security.client.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65)
  120.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  121.     at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:74)
  122.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  123.     at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)
  124.     at $Proxy3.invoke(Unknown Source)
  125.     at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)
  126.     at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)
  127.     at $Proxy2.fetchServiceType(Unknown Source)
  128.     at com.ifs.ejb.product.test.ServiceTest.main(ServiceTest.java:51)
  129.     at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:72)
  130.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  131.     at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:61)
  132.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  133.     at org.jboss.ejb3.security.client.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:65)
  134.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  135.     at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:74)
  136.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  137.     at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)
  138.     at $Proxy3.invoke(Unknown Source)
  139.     at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)
  140.     at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)
  141.     at $Proxy2.fetchServiceType(Unknown Source)
  142.     at com.ifs.ejb.product.test.ServiceTest.main(ServiceTest.java:51)
  143. Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.ifs.ejb.product.entity.ServiceType#PAYMENT]
  144.     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
  145.     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  146.     at org.hibernate.loader.Loader.loadEntity(Loader.java:1895)
  147.     at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
  148.     at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
  149.     at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)
  150.     at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)
  151.     at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)
  152.     at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)
  153.     at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)
  154.     at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)
  155.     at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)
  156.     at org.hibernate.impl.SessionImpl.get(SessionImpl.java:842)
  157.     at org.hibernate.impl.SessionImpl.get(SessionImpl.java:835)
  158.     at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182)
  159.     at org.jboss.jpa.tx.TransactionScopedEntityManager.find(TransactionScopedEntityManager.java:176)
  160.     at com.ifs.ejb.product.service.ServiceManagerBean.fetchServiceType(ServiceManagerBean.java:27)
  161.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  162.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  163.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  164.     at java.lang.reflect.Method.invoke(Method.java:597)
  165.     at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
  166.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
  167.     at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
  168.     at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
  169.     at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
  170.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  171.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  172.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  173.     at java.lang.reflect.Method.invoke(Method.java:597)
  174.     at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
  175.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  176.     at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
  177.     at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1531239547.invoke(InvocationContextInterceptor_z_fillMethod_1531239547.java)
  178.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  179.     at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
  180.     at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1531239547.invoke(InvocationContextInterceptor_z_setup_1531239547.java)
  181.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  182.     at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
  183.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  184.     at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
  185.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  186.     at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
  187.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  188.     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
  189.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  190.     at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
  191.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  192.     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
  193.     at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
  194.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  195.     at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
  196.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  197.     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
  198.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  199.     at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
  200.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  201.     at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
  202.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  203.     at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
  204.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  205.     at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
  206.     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
  207.     at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:421)
  208.     at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:53)
  209.     at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
  210.     at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
  211.     at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891)
  212.     at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744)
  213.     at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697)
  214.     at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:524)
  215.     at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232)
  216. Caused by: org.postgresql.util.PSQLException: 错误: 字段 servicetyp0_.parent_service_type_id 不存在
  217.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1591)
  218.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1340)
  219.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
  220.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:471)
  221.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:373)
  222.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
  223.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  224.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  225.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  226.     at java.lang.reflect.Method.invoke(Method.java:597)
  227.     at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:458)
  228.     at $Proxy326.executeQuery(Unknown Source)
  229.     at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
  230.     at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  231.     at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
  232.     at org.hibernate.loader.Loader.doQuery(Loader.java:697)
  233.     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
  234.     at org.hibernate.loader.Loader.loadEntity(Loader.java:1881)
  235.     ... 69 more
  236.        
  237. @ManyToOne
  238. @JoinColumn(name = "parentTypeCode")
  239. protected ServiceType parent;
  240.  
  241. @OneToMany(mappedBy = "parent")
  242. protected Set<ServiceType> children;