org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578]

Hibernate JIRA | bharatkumar | 4 years ago
  1. 0

    I am facing one issue while using one entity called Entity_1 which is already mapped with other multiple entities in the application. After mapping Entity_1 with a new entity Entity_2, during data fetching of Entity_1 from Entity_2, Its bydefault trying to fetch data records for all the mappings. And create a very large Sql query, that fails to be executed. Please provide me some solution so that do i restrict them for not fetching that many objects. Please find the below server logs for the error : Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries « Technical information Date: 2012-09-27 06:15:55 Message: org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578] Stacktrace: org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadCollection(Loader.java:2173) at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:627) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83) at de.segal.baoss.platform.profiling.persistence.ProfilingInitializeCollectionEventListener.onInitializeCollection(ProfilingInitializeCollectionEventListener.java:42) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1863) at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:369) at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111) at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:134) at org.hibernate.collection.PersistentBag.isEmpty(PersistentBag.java:255) at de.segal.baoss.platform.entity.Document.getActivity(Document.java:381) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335) at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:280) at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59) at org.jboss.el.parser.AstValue.getValue(AstValue.java:67) at org.jboss.el.parser.AstMethodSuffix.getParameters(AstMethodSuffix.java:27) at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59) at org.jboss.el.parser.AstMethodSuffix.invoke(AstMethodSuffix.java:65) at org.jboss.el.parser.AstValue.invoke(AstValue.java:96) at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at org.ajax4jsf.component.UIDataAdaptorBase.broadcast(UIDataAdaptorBase.java:1397) at org.richfaces.component.UIExtendedDataTable.broadcast(UIExtendedDataTable.java:92) at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329) at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304) at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261) at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83) at de.segal.baoss.platform.servlet.TransactionFilter.doFilter(TransactionFilter.java:68) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at de.segal.baoss.platform.profiling.WithinAjax4jsfFilterProfilingFilter.doFilter(WithinAjax4jsfFilterProfilingFilter.java:34) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206) at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:295) at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:393) at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:520) at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at de.segal.baoss.platform.profiling.ProfilingFilter.doFilter(ProfilingFilter.java:124) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at com.googlecode.webutilities.filters.CompressionFilter.doFilter(CompressionFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.monitoring.WebStatisticsFilter.doFilter(WebStatisticsFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.multitenancy.TenantSelectionFilter.doFilter(TenantSelectionFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.servlet.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:143) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.servlet.RichFacesFirefox11Filter.doFilter(RichFacesFirefox11Filter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:161) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397) at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) at java.lang.Thread.run(Thread.java:662) Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455) at $Proxy158.executeQuery(Unknown Source) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.loadCollection(Loader.java:2166) ... 95 more

    Hibernate JIRA | 4 years ago | bharatkumar
    org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578]
  2. 0

    I am facing one issue while using one entity called Entity_1 which is already mapped with other multiple entities in the application. After mapping Entity_1 with a new entity Entity_2, during data fetching of Entity_1 from Entity_2, Its bydefault trying to fetch data records for all the mappings. And create a very large Sql query, that fails to be executed. Please provide me some solution so that do i restrict them for not fetching that many objects. Please find the below server logs for the error : Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries « Technical information Date: 2012-09-27 06:15:55 Message: org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578] Stacktrace: org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.loadCollection(Loader.java:2173) at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:627) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83) at de.segal.baoss.platform.profiling.persistence.ProfilingInitializeCollectionEventListener.onInitializeCollection(ProfilingInitializeCollectionEventListener.java:42) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1863) at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:369) at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111) at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:134) at org.hibernate.collection.PersistentBag.isEmpty(PersistentBag.java:255) at de.segal.baoss.platform.entity.Document.getActivity(Document.java:381) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335) at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:280) at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59) at org.jboss.el.parser.AstValue.getValue(AstValue.java:67) at org.jboss.el.parser.AstMethodSuffix.getParameters(AstMethodSuffix.java:27) at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59) at org.jboss.el.parser.AstMethodSuffix.invoke(AstMethodSuffix.java:65) at org.jboss.el.parser.AstValue.invoke(AstValue.java:96) at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88) at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102) at javax.faces.component.UICommand.broadcast(UICommand.java:387) at org.ajax4jsf.component.UIDataAdaptorBase.broadcast(UIDataAdaptorBase.java:1397) at org.richfaces.component.UIExtendedDataTable.broadcast(UIExtendedDataTable.java:92) at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329) at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304) at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261) at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474) at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82) at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83) at de.segal.baoss.platform.servlet.TransactionFilter.doFilter(TransactionFilter.java:68) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at de.segal.baoss.platform.profiling.WithinAjax4jsfFilterProfilingFilter.doFilter(WithinAjax4jsfFilterProfilingFilter.java:34) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206) at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:295) at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:393) at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:520) at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at de.segal.baoss.platform.profiling.ProfilingFilter.doFilter(ProfilingFilter.java:124) at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at com.googlecode.webutilities.filters.CompressionFilter.doFilter(CompressionFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.monitoring.WebStatisticsFilter.doFilter(WebStatisticsFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.multitenancy.TenantSelectionFilter.doFilter(TenantSelectionFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.servlet.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:143) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at de.segal.baoss.platform.servlet.RichFacesFirefox11Filter.doFilter(RichFacesFirefox11Filter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:161) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397) at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) at java.lang.Thread.run(Thread.java:662) Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455) at $Proxy158.executeQuery(Unknown Source) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.loadCollection(Loader.java:2166) ... 95 more

    Hibernate JIRA | 4 years ago | bharatkumar
    org.hibernate.exception.GenericJDBCException: could not initialize a collection: [de.segal.baoss.platform.entity.Document.activities#23578]
  3. 0

    Problem of case with "PUBLIC" schema in PostGIS

    GitHub | 3 years ago | gpetit
    org.postgresql.util.PSQLException: ERREUR: la relation « PUBLIC.test » n'existe pas Position : 15
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Bug when you change default schema with PostgreSQL

    GitHub | 3 years ago | mlecoeuvre
    org.postgresql.util.PSQLException: ERREUR: la relation « geometry_columns » n'existe pas Position : 15
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: target lists can have at most 1664 entries

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    6 frames
  3. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  4. PostgreSQL JDBC Driver
    AbstractJdbc23PooledConnection$StatementHandler.invoke
    1. org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    1 frame
  5. Unknown
    $Proxy158.executeQuery
    1. $Proxy158.executeQuery(Unknown Source)
    1 frame
  6. IronJacamar
    WrappedPreparedStatement.executeQuery
    1. org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
    1 frame
  7. Hibernate
    AbstractCollectionPersister.initialize
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:802)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    5. org.hibernate.loader.Loader.loadCollection(Loader.java:2166)
    6. org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62)
    7. org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:627)
    7 frames
  8. Hibernate
    DefaultInitializeCollectionEventListener.onInitializeCollection
    1. org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
    1 frame
  9. de.segal.baoss
    ProfilingInitializeCollectionEventListener.onInitializeCollection
    1. de.segal.baoss.platform.profiling.persistence.ProfilingInitializeCollectionEventListener.onInitializeCollection(ProfilingInitializeCollectionEventListener.java:42)
    1 frame
  10. Hibernate
    PersistentBag.isEmpty
    1. org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1863)
    2. org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:369)
    3. org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111)
    4. org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:134)
    5. org.hibernate.collection.PersistentBag.isEmpty(PersistentBag.java:255)
    5 frames
  11. de.segal.baoss
    Document.getActivity
    1. de.segal.baoss.platform.entity.Document.getActivity(Document.java:381)
    1 frame
  12. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  13. org.jboss.el
    MethodExpressionImpl.invoke
    1. org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335)
    2. org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:280)
    3. org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)
    4. org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
    5. org.jboss.el.parser.AstMethodSuffix.getParameters(AstMethodSuffix.java:27)
    6. org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)
    7. org.jboss.el.parser.AstMethodSuffix.invoke(AstMethodSuffix.java:65)
    8. org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
    9. org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
    9 frames
  14. Facelets
    TagMethodExpression.invoke
    1. com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
    1 frame
  15. JavaEE 7
    MethodBindingMethodExpressionAdapter.invoke
    1. javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
    1 frame
  16. JSF
    ActionListenerImpl.processAction
    1. com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
    1 frame
  17. JavaEE 7
    UICommand.broadcast
    1. javax.faces.component.UICommand.broadcast(UICommand.java:387)
    1 frame
  18. RichFaces Core API
    AjaxViewRoot.processApplication
    1. org.ajax4jsf.component.UIDataAdaptorBase.broadcast(UIDataAdaptorBase.java:1397)
    2. org.richfaces.component.UIExtendedDataTable.broadcast(UIExtendedDataTable.java:92)
    3. org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
    4. org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
    5. org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
    6. org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
    6 frames
  19. JSF
    LifecycleImpl.execute
    1. com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
    2. com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
    3. com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
    3 frames
  20. JavaEE 7
    FacesServlet.service
    1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
    1 frame
  21. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    2 frames
  22. org.jboss.seam
    SeamFilter$FilterChainImpl.doFilter
    1. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
    1 frame
  23. de.segal.baoss
    TransactionFilter.doFilter
    1. de.segal.baoss.platform.servlet.TransactionFilter.doFilter(TransactionFilter.java:68)
    1 frame
  24. org.jboss.seam
    SeamFilter$FilterChainImpl.doFilter
    1. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    2. org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
    3. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    4. org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
    5. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    6. org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
    7. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    8. org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
    9. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    9 frames
  25. de.segal.baoss
    WithinAjax4jsfFilterProfilingFilter.doFilter
    1. de.segal.baoss.platform.profiling.WithinAjax4jsfFilterProfilingFilter.doFilter(WithinAjax4jsfFilterProfilingFilter.java:34)
    1 frame
  26. org.jboss.seam
    SeamFilter$FilterChainImpl.doFilter
    1. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    1 frame
  27. org.ajax4jsf.webapp
    BaseFilter.doFilter
    1. org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
    2. org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:295)
    3. org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:393)
    4. org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:520)
    4 frames
  28. org.jboss.seam
    SeamFilter$FilterChainImpl.doFilter
    1. org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
    2. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    3. org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
    4. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    4 frames
  29. de.segal.baoss
    ProfilingFilter.doFilter
    1. de.segal.baoss.platform.profiling.ProfilingFilter.doFilter(ProfilingFilter.java:124)
    1 frame
  30. org.jboss.seam
    SeamFilter.doFilter
    1. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
    2. org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
    2 frames
  31. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    2 frames
  32. webutilities
    CompressionFilter.doFilter
    1. com.googlecode.webutilities.filters.CompressionFilter.doFilter(CompressionFilter.java:112)
    1 frame
  33. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    2 frames
  34. de.segal.baoss
    WebStatisticsFilter.doFilter
    1. de.segal.baoss.platform.monitoring.WebStatisticsFilter.doFilter(WebStatisticsFilter.java:47)
    1 frame
  35. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    2 frames
  36. de.segal.baoss
    TenantSelectionFilter.doFilter
    1. de.segal.baoss.platform.multitenancy.TenantSelectionFilter.doFilter(TenantSelectionFilter.java:137)
    1 frame
  37. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    2 frames
  38. de.segal.baoss
    SessionTimeoutFilter.doFilter
    1. de.segal.baoss.platform.servlet.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:143)
    1 frame
  39. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    2 frames
  40. de.segal.baoss
    RichFacesFirefox11Filter.doFilter
    1. de.segal.baoss.platform.servlet.RichFacesFirefox11Filter.doFilter(RichFacesFirefox11Filter.java:21)
    1 frame
  41. Glassfish Core
    AuthenticatorBase.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
    4. org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:161)
    5. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java)
    6. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397)
    6 frames
  42. JPA
    WebNonTxEmCloserValve.invoke
    1. org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
    1 frame
  43. JBoss Web
    SecurityContextAssociationValve.invoke
    1. org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
    1 frame
  44. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    3. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
    4. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    5. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
    5 frames
  45. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
    3 frames
  46. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame