<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;">
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="stoyan.zhekov" id="email_stoyan.zhekov" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=stoyan.zhekov" style="color:#6c797f;">stoyan zhekov</a>
edited a comment on <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/HBX-1126'>HBX-1126</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/HBX-1126'><strong>cannot start a jbpm proccess because the hibernated generated query, fails with informix 10</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 colspan="2" style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 16px 0;width:100%;">
<div class="comment-block" style="background-color:#edf5ff;border:1px solid #dddddd;color:#000000;padding:12px;"><p>hi everyone,<br/>
it seems that I have similar problem or at less I have the same exception. I use hibernate 3.6.6, jboss 6.1 and informix10. Infact everything worked fine before migration, when jboss 5 was used. Also I want to mention I dont have parameter DELIMIDENT in my url. My problem comes on the class which has two embedded field (for clarity : the names are as follow, sender and cerrier) with the same reference type. Both of the field use @AttributeOverride and @AssociationOverride to override properly names of the columns and association of the class which is annotated with @embeddable. The last one also have @OneToOne relationship with other entity. I try to check which on of the field make the problem so everything begins to work fine if I delete "sender" field. Here is a part of the code: </p>
<p>@Embeddable<br/>
public class ProductsAgent{
@Column(name = "name")
private String name;
@Column(name = "statute")
private String statute;
@OneToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
@JoinColumn(name = "products_agent_address_id")
private Address address;
}</p>
<p>@Entity<br/>
class Registration76v{</p>
<p> @Embedded<br/>
@AssociationOverride(name = "address", joinColumns = @JoinColumn(name = "sender_address_id", table = "registration76v"))<br/>
@AttributeOverrides(value = { @AttributeOverride(name = "name", column = @Column(name = "sender_name", table = "registration76v")),
@AttributeOverride(name = "statute", column = @Column(name = "sender_statute", table = "registration76v")) })<br/>
private ProductsAgent1 sender = new ProductsAgent1();</p>
<p> @Embedded<br/>
@AssociationOverride(name = "address", joinColumns = @JoinColumn(name = "carrier_address_id", table = "registration76v"))<br/>
@AttributeOverrides(value = { @AttributeOverride(name = "name", column = @Column(name = "carrier_name", table = "registration76v")),
@AttributeOverride(name = "statute", column = @Column(name = "carrier_statute", table = "registration76v")) })<br/>
private ProductsAgent carrier = new ProductsAgent();</p>
<p>}</p>
<p>here is a part of the log:</p>
<p>16:20:38,212 WARN <span class="error">[org.hibernate.util.JDBCExceptionReporter]</span> SQL Error: -79738, SQLState: IX000<br/>
16:20:38,212 ERROR <span class="error">[org.hibernate.util.JDBCExceptionReporter]</span> org.hibernate.util.JDBCExceptionReporter] No such column name<br/>
16:20:38,215 INFO <span class="error">[org.hibernate.event.def.DefaultLoadEventListener]</span> Error performing load command: org.hibernate.exception.GenericJDBCException: could not load an entity:<br/>
16:20:38,215 INFO <span class="error">[org.hibernate.event.def.DefaultLoadEventListener]</span> Error performing load command: org.hibernate.exception.GenericJDBCException: could not load an entity:</p>
<p>Somehow my colleague find that the problem comes from wrong generated sql. And to be more specif with generated alias of "sender_address_id" by which the given column is searched later.</p>
<p>So, if someone can give me a advice how to solve this problem I really will appreciate that.<br/>
Thanks in advance.</p>
<p>P.S<br/>
It is my first time when I try to solve the problem in this way, so excuse me if I didnt describe everything very well</p></div>
<div style="color:#505050;padding:4px 0 0 0;"> </div>
</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 -->