<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="earrd01" id="email_earrd01" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=earrd01" style="color:#6c797f;">Eric Anderson</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/HHH-8020'>HHH-8020</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/HHH-8020'><strong>Incorrect number of binding parameters for composite key in a child assoc</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;">Affects Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
3.6.10 </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;">Components:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
core </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%;">
19/Feb/13 1:01 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;'>Issue<br/>
======<br/>
When Hibernate tries to insert the children (ErrorDetails) a "Parameter index is out of range" results.<br/>
Logs show the following:</p>
<p style='margin-top:0;margin-bottom:10px;'>Caused by: com.ibm.db2.jcc.b.co: <span class="error">[jcc]</span><span class="error">[10145]</span><span class="error">[10844]</span><span class="error">[3.53.70]</span> Invalid parameter 8: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815</p>
<p style='margin-top:0;margin-bottom:10px;'>ErrLog<br/>
*/ insert <br/>
into<br/>
ERR_LOG<br/>
(ERR_CD, ERR_MSG, FILE_ITEM_NR, UPLOAD_TYPE_CD, SUBTYP, EXEC_ID, LN_NR) <br/>
values<br/>
(?, ?, ?, ?, ?, ?, ?)<br/>
binding parameter <span class="error">[1]</span> as <span class="error">[INTEGER]</span> - 8<br/>
binding parameter <span class="error">[2]</span> as <span class="error">[VARCHAR]</span> - There was an error:Unable to create entityBean for update because the profileNbr can not be determined. The loginID= and the profileID=19971.</p>
<p style='margin-top:0;margin-bottom:10px;'>binding parameter <span class="error">[3]</span> as <span class="error">[VARCHAR]</span> - 3<br/>
binding parameter <span class="error">[4]</span> as <span class="error">[VARCHAR]</span> - PAB<br/>
binding parameter <span class="error">[5]</span> as <span class="error">[VARCHAR]</span> - <br/>
binding parameter <span class="error">[6]</span> as <span class="error">[INTEGER]</span> - 100000<br/>
binding parameter <span class="error">[7]</span> as <span class="error">[VARCHAR]</span> - PAB<br/>
binding parameter <span class="error">[8]</span> as <span class="error">[VARCHAR]</span> - </p>
<p style='margin-top:0;margin-bottom:10px;'>Binding parameters 4 and 5 are repeated again in 7 & 8. Additionaly, there is no binding parameter for LN_NR. Its as if binding parameters 7 & 8 took the place of LN_NR binding parameter.</p>
<p style='margin-top:0;margin-bottom:10px;'>I can't change the tables for this. Any suggestions how to get around this problem?</p>
<p style='margin-top:0;margin-bottom:10px;'>Error (Parent)<br/>
===============</p>
<p style='margin-top:0;margin-bottom:10px;'> @Id<br/>
@GenericGenerator(name="errorGenerator", strategy="increment")<br/>
@GeneratedValue(generator="errorGenerator")<br/>
@Column(name="EXEC_ID", nullable=false)<br/>
public int getExecId() {
return this.execId;
}<br/>
public void setExecId(int execId)</p>
{
this.execId = execId;
}
<p style='margin-top:0;margin-bottom:10px;'> @Id<br/>
@Column(name="UPLOAD_TYPE_CD", nullable=false, length=3)<br/>
public String getUploadTypeCd() {
return this.uploadTypeCd;
} <br/>
public void setUploadTypeCd(String uploadTypeCd) {
this.uploadTypeCd = uploadTypeCd;
}</p>
<p style='margin-top:0;margin-bottom:10px;'> @Id<br/>
@Column(name="SUBTYP", nullable=false, length=6)<br/>
public String getSubtyp() {
return this.subtyp;
}</p>
<p style='margin-top:0;margin-bottom:10px;'> public void setSubtyp(String subtyp) {
this.subtyp = subtyp;
}</p>
<p style='margin-top:0;margin-bottom:10px;'> @OneToMany<br/>
@JoinColumns( {
@JoinColumn(name="EXEC_ID", referencedColumnName="EXEC_ID", nullable=false),
@JoinColumn(name="SUBTYP", referencedColumnName="SUBTYP", nullable=false),
@JoinColumn(name="UPLOAD_TYPE_CD", referencedColumnName="UPLOAD_TYPE_CD", nullable=false)
} )<br/>
@Cascade({CascadeType.ALL})<br/>
public Set<ErrLog> getErrLogs() {
return this.errLogs;
}</p>
<p style='margin-top:0;margin-bottom:10px;'> public void setErrLogs(Set<ErrLog> errLogs) {
this.errLogs = errLogs;
}</p>
<p style='margin-top:0;margin-bottom:10px;'>ErrorDetails (Children)<br/>
========================<br/>
@Id<br/>
@Column(name="LN_NR", nullable=false)<br/>
public int getLnNr() {
return this.lnNr; //PART OF THE PK FOR THIS TABLE. THIS IS NOT AN INDEX. IT IS THE LINE IN A FILE THAT CAUSED THE ERROR.
}</p>
<p style='margin-top:0;margin-bottom:10px;'> @Id<br/>
@ManyToOne<br/>
@JoinColumns( {
@JoinColumn(name="EXEC_ID", referencedColumnName="EXEC_ID", nullable=false, insertable=false, updatable=false),
@JoinColumn(name="SUBTYP", referencedColumnName="SUBTYP", nullable=false, insertable=false, updatable=false),
@JoinColumn(name="UPLOAD_TYPE_CD", referencedColumnName="UPLOAD_TYPE_CD", nullable=false, insertable=false, updatable=false)
} )<br/>
public Exec getExec() {
return this.exec;
}</p>
<p style='margin-top:0;margin-bottom:10px;'> public void setExec(Exec exec) {
this.exec = exec;
}</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;">Environment:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Hibernate 3.6.10, DB2, Websphere 7.
<br/>
</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/HHH">Hibernate ORM</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;">Labels:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
hibernate
</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_major.gif" height="16" width="16" border="0" align="absmiddle" alt="Major"> Major
</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="earrd01" id="email_earrd01" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=earrd01" style="color:#6c797f;">Eric Anderson</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 -->