<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="emundo" id="email_emundo" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=emundo" style="color:#6c797f;">eMundo GmbH</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-7707'>HHH-7707</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-7707'><strong>Described Implicit Join generates "CROSS JOIN" instead of "INNER JOIN"</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%;">
4.1.5.SP1 </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%;">
query-hql </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%;">
22/Oct/12 8:35 AM
</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;'>We have the following Entities defined:</p>
<p style='margin-top:0;margin-bottom:10px;'>@Entity<br/>
@Table(name = "table1")<br/>
public class Table1 implements VersionSupport, Persistable<Integer></p>
{
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Basic(optional = false)
@Column(name = "table1_id", nullable = false)
private Integer table1Id;
@Basic(optional = true)
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "table2_refid")
private Table2 table2;
}
<p style='margin-top:0;margin-bottom:10px;'>@Entity<br/>
@Table(name = "table2")<br/>
@Indexed<br/>
public class Table2 implements Persistable<Integer>, Auditable, VersionSupport</p>
{
@Id
@GeneratedValue
@DocumentId
@Column(name = "table2_id", nullable = false)
private Integer table2Id;
@Field
@Column(name = "matchcode", nullable = false)
private String matchcode;
}
<p style='margin-top:0;margin-bottom:10px;'>(shortend of course)</p>
<p style='margin-top:0;margin-bottom:10px;'>If I try to do a HQL-Query like the following, I get a "CROSS JOIN" instead of a "INNER JOIN":</p>
<p style='margin-top:0;margin-bottom:10px;'><code><br/>
StringBuilder sb = new StringBuilder();</p>
<p style='margin-top:0;margin-bottom:10px;'>sb.append("from Table1 where table2.matchcode = :refid");</p>
<p style='margin-top:0;margin-bottom:10px;'>Query query = sessionFactory.getCurrentSession().createQuery(sb.toString());<br/>
query.setInteger("refid", value);</p>
<p style='margin-top:0;margin-bottom:10px;'> List<Table1> table1List = (List<Table1>) query.list();</p>
<p style='margin-top:0;margin-bottom:10px;'> return table1List;<br/>
}<br/>
</code></p>
<p style='margin-top:0;margin-bottom:10px;'>HQL then generates me the following sql:</p>
<p style='margin-top:0;margin-bottom:10px;'><code><br/>
select ... <br/>
from Table1 t1 CROSS JOIN Table2 t2<br/>
where t1.table2_id = t2.id<br/>
and matchcode = ...<br/>
</code></p>
<p style='margin-top:0;margin-bottom:10px;'>instead of <br/>
<code><br/>
select ... <br/>
from Table1 t1 INNER JOIN Table2 t2 on t1.table2_id = t2.id<br/>
where matchcode = ...<br/>
</code><br/>
which I will get if I do a explicit join:</p>
<p style='margin-top:0;margin-bottom:10px;'><code><br/>
StringBuilder sb = new StringBuilder();</p>
<p style='margin-top:0;margin-bottom:10px;'>sb.append("from Table1 t1 join t1.table2Id where table2.matchcode = :refid");</p>
<p style='margin-top:0;margin-bottom:10px;'>Query query = sessionFactory.getCurrentSession().createQuery(sb.toString());<br/>
query.setInteger("refid", value);</p>
<p style='margin-top:0;margin-bottom:10px;'> List<Table1> table1List = (List<Table1>) query.list();</p>
<p style='margin-top:0;margin-bottom:10px;'> return table1List;<br/>
}<br/>
</code></p>
<p style='margin-top:0;margin-bottom:10px;'>That happens although documentation tells me in different way:<br/>
<a href="http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/queryhql.html#queryhql-joins-forms">http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/queryhql.html#queryhql-joins-forms</a><br/>
<code><br/>
HQL supports two forms of association joining: implicit and explicit.</p>
<p style='margin-top:0;margin-bottom:10px;'>The queries shown in the previous section all use the explicit form, that is, where the join keyword is explicitly used in the from clause. This is the recommended form.</p>
<p style='margin-top:0;margin-bottom:10px;'>The implicit form does not use the join keyword. Instead, the associations are "dereferenced" using dot-notation. implicit joins can appear in any of the HQL clauses. implicit join result in inner joins in the resulting SQL statement.</p>
<p style='margin-top:0;margin-bottom:10px;'>from Cat as cat where cat.mate.name like '%s%'</code></p>
<p style='margin-top:0;margin-bottom:10px;'>Who can help me in this case? I don't want to get ANY CROSS JOIN in my Program. In this case I have mapped my refid as nullable as it has to be filled later on in my program. But at the time I create this object it is nullable as I do not have this Object.</p>
<p style='margin-top:0;margin-bottom:10px;'>Either way -> I turned it to not null and it happened again...</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%;">
Informix 11.50
<br/>
Spring
</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
query
informix
hql
</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="emundo" id="email_emundo" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=emundo" style="color:#6c797f;">eMundo GmbH</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 -->