<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Correct approach for creating a large number of records
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/meetoblivion">John Ament</a> in <i>EJB3</i> - <a href="http://community.jboss.org/message/575428#575428">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I'm on JBoss AS 6.</p><p><br/>I have a very large process that runs.  It consists of taking an entity and persisting it as well as a number of its children - roughly 12 child rows for each parent.  I can get it to successfully process the first 40 or so records, but then eventually I get this:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><br/>2010-12-10 10:10:11,257 WARN  [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-8080-2) SQL Error: 0, SQLState: null<br/>2010-12-10 10:10:11,257 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-0.0.0.0-8080-2) Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@bc9ef2<br/>2010-12-10 10:10:11,258 ERROR [org.jboss.ejb3.tx2.impl.CMTTxInterceptor] (http-0.0.0.0-8080-2) javax.ejb.EJBTransactionRolledbackException: could not insert:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><br/>In my ds.xml, I have setup</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><br/><max-pool-size>20000</max-pool-size><br/>      <idle-timeout-minutes>1</idle-timeout-minutes><br/>      <blocking-timeout-millis>60000</blocking-timeout-millis></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Is this a situation where I want to specify the JDBC batch size as well?  Overally, I'm a bit confused about why it wants to create so many connections - looks like one per record it wants to insert.  As a way to try to break it out further and further, I've even gotten to the point of directly using SessionFactory and StatelessSession in hibernate to avoid transactions, but no luck so far.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/575428#575428">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in EJB3 at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>