<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#3e4c4e" style="background-color:#3e4c4e;color:#ffffff;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://www.jboss.org/dms/hibernate/images/jira/jiraheader_hibernate.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://hibernate.onjira.com/secure/useravatar?avatarId=10162" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="bharatkumar" id="email_bharatkumar" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=bharatkumar" style="color:#6c797f;">bharatkumar</a>
created <img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/BVAL-312'>BVAL-312</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/BVAL-312'><strong>Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Issue Type:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> Bug
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Assignee:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Unassigned </td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Created:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
26/Sep/12 11:32 PM
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Description:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<p style='margin-top:0;margin-bottom:10px;'>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.</p>
<p style='margin-top:0;margin-bottom:10px;'>Please provide me some solution so that do i restrict them for not fetching that many objects.</p>
<p style='margin-top:0;margin-bottom:10px;'>Please find the below server logs for the error :</p>
<p style='margin-top:0;margin-bottom:10px;'>Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries</p>
<p style='margin-top:0;margin-bottom:10px;'>«<br/>
Technical information <br/>
Date: 2012-09-27 06:15:55<br/>
Message: org.hibernate.exception.GenericJDBCException: could not initialize a collection: <a href="#23578">de.segal.baoss.platform.entity.Document.activities#23578</a></p>
<p style='margin-top:0;margin-bottom:10px;'>Stacktrace:</p>
<p style='margin-top:0;margin-bottom:10px;'>org.hibernate.exception.GenericJDBCException: could not initialize a collection: <a href="#23578">de.segal.baoss.platform.entity.Document.activities#23578</a><br/>
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)<br/>
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)<br/>
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)<br/>
at org.hibernate.loader.Loader.loadCollection(Loader.java:2173)<br/>
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62)<br/>
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:627)<br/>
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)<br/>
at de.segal.baoss.platform.profiling.persistence.ProfilingInitializeCollectionEventListener.onInitializeCollection(ProfilingInitializeCollectionEventListener.java:42)<br/>
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1863)<br/>
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:369)<br/>
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111)<br/>
at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:134)<br/>
at org.hibernate.collection.PersistentBag.isEmpty(PersistentBag.java:255)<br/>
at de.segal.baoss.platform.entity.Document.getActivity(Document.java:381)<br/>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br/>
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br/>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/>
at java.lang.reflect.Method.invoke(Method.java:597)<br/>
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335)<br/>
at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:280)<br/>
at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)<br/>
at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)<br/>
at org.jboss.el.parser.AstMethodSuffix.getParameters(AstMethodSuffix.java:27)<br/>
at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)<br/>
at org.jboss.el.parser.AstMethodSuffix.invoke(AstMethodSuffix.java:65)<br/>
at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)<br/>
at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)<br/>
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)<br/>
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)<br/>
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)<br/>
at javax.faces.component.UICommand.broadcast(UICommand.java:387)<br/>
at org.ajax4jsf.component.UIDataAdaptorBase.broadcast(UIDataAdaptorBase.java:1397)<br/>
at org.richfaces.component.UIExtendedDataTable.broadcast(UIExtendedDataTable.java:92)<br/>
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)<br/>
at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)<br/>
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)<br/>
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)<br/>
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)<br/>
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)<br/>
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)<br/>
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)<br/>
at de.segal.baoss.platform.servlet.TransactionFilter.doFilter(TransactionFilter.java:68)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at de.segal.baoss.platform.profiling.WithinAjax4jsfFilterProfilingFilter.doFilter(WithinAjax4jsfFilterProfilingFilter.java:34)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)<br/>
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:295)<br/>
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:393)<br/>
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:520)<br/>
at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at de.segal.baoss.platform.profiling.ProfilingFilter.doFilter(ProfilingFilter.java:124)<br/>
at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)<br/>
at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at com.googlecode.webutilities.filters.CompressionFilter.doFilter(CompressionFilter.java:112)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at de.segal.baoss.platform.monitoring.WebStatisticsFilter.doFilter(WebStatisticsFilter.java:47)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at de.segal.baoss.platform.multitenancy.TenantSelectionFilter.doFilter(TenantSelectionFilter.java:137)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at de.segal.baoss.platform.servlet.SessionTimeoutFilter.doFilter(SessionTimeoutFilter.java:143)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at de.segal.baoss.platform.servlet.RichFacesFirefox11Filter.doFilter(RichFacesFirefox11Filter.java:21)<br/>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)<br/>
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)<br/>
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)<br/>
at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:161)<br/>
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java)<br/>
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397)<br/>
at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)<br/>
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)<br/>
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)<br/>
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br/>
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)<br/>
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br/>
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)<br/>
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)<br/>
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)<br/>
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)<br/>
at java.lang.Thread.run(Thread.java:662)<br/>
Caused by: org.postgresql.util.PSQLException: ERROR: target lists can have at most 1664 entries<br/>
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)<br/>
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)<br/>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)<br/>
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<br/>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)<br/>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)<br/>
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)<br/>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/>
at java.lang.reflect.Method.invoke(Method.java:597)<br/>
at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)<br/>
at $Proxy158.executeQuery(Unknown Source)<br/>
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)<br/>
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)<br/>
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)<br/>
at org.hibernate.loader.Loader.doQuery(Loader.java:802)<br/>
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)<br/>
at org.hibernate.loader.Loader.loadCollection(Loader.java:2166)<br/>
... 95 more</p>
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Project:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a style="color:#6c797f;" href="https://hibernate.onjira.com/browse/BVAL">Bean Validation</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Priority:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/priority_blocker.gif" height="16" width="16" border="0" align="absmiddle" alt="Blocker"> Blocker
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Reporter:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="bharatkumar" id="email_bharatkumar" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=bharatkumar" style="color:#6c797f;">bharatkumar</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your JIRA administrators<br />
For more information on JIRA, see: <a style='color:#6c797f;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->