<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="finion" id="email_finion" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=finion" style="color:#6c797f;">finion</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-7558'>HHH-7558</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-7558'><strong>DB2 HQL insert statement</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.6, 3.2.7 </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%;">
28/Aug/12 10:09 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;'>The statement work fine on version 3.2.5,<br/>
since upgrade to 3.2.7 it throw exception,<br/>
and I try the latest 4.1.6 got the same problem.</p>
<p style='margin-top:0;margin-bottom:10px;'>----------------------------------------------------------<br/>
Exception in thread "main" java.lang.NullPointerException<br/>
at org.hibernate.dialect.function.CastFunction.render(CastFunction.java:36)<br/>
at org.hibernate.hql.ast.SqlGenerator.endFunctionTemplate(SqlGenerator.java:197)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.methodCall(SqlGeneratorBase.java:2223)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.selectExpr(SqlGeneratorBase.java:1897)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.selectColumn(SqlGeneratorBase.java:1743)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.selectClause(SqlGeneratorBase.java:527)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.selectStatement(SqlGeneratorBase.java:175)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.insertStatement(SqlGeneratorBase.java:444)<br/>
at org.hibernate.hql.antlr.SqlGeneratorBase.statement(SqlGeneratorBase.java:137)<br/>
at org.hibernate.hql.ast.exec.BasicExecutor.<init>(BasicExecutor.java:42)<br/>
at org.hibernate.hql.ast.QueryTranslatorImpl.buildAppropriateStatementExecutor(QueryTranslatorImpl.java:535)<br/>
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:178)<br/>
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:113)<br/>
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)<br/>
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)<br/>
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)<br/>
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)<br/>
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)<br/>
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1624)<br/>
at com.gss.lager.HibernateTest.main(HibernateTest.java:42)<br/>
-------------------------------------------------------------------</p>
<p style='margin-top:0;margin-bottom:10px;'>sample code :<br/>
StringBuffer incoming = new StringBuffer();<br/>
incoming.append("insert into DagEdgeImpl(entryEdgeId) ")<br/>
.append("select edge.id ")<br/>
.append("from DagEdgeImpl edge ")<br/>
.append("where edge.endVertex.higherBits = ? ")<br/>
.append("and edge.endVertex.lowerBits = ? ");</p>
<p style='margin-top:0;margin-bottom:10px;'> log.debug("incoming sql : " + incoming);<br/>
Query query = session.createQuery(incoming.toString());<br/>
query.setLong(0, -552857267868777299L);<br/>
query.setLong(1, -5131265078905782943L);<br/>
query.executeUpdate();</p>
<p style='margin-top:0;margin-bottom:10px;'>hbm :<br/>
<hibernate-mapping package="com.gss.lager.texture.domain.impl"><br/>
<class name="DagEdgeImpl" table="LAGER_DAG_TC_EDGE"></p>
<p style='margin-top:0;margin-bottom:10px;'> <id name="id" column="id" type="long"><br/>
<generator class="native"><br/>
<param name="sequence">SEQ_DAG_TC_EDGE</param><br/>
</generator><br/>
</id></p>
<p style='margin-top:0;margin-bottom:10px;'> <version name="version" column="version" type="long"/></p>
<p style='margin-top:0;margin-bottom:10px;'> <property name="entryEdgeId" column="entry_edge_id" type="long" index="LAGER_DAG_ENTRY_EDGE_IDX"/></p>
<p style='margin-top:0;margin-bottom:10px;'> <property name="directEdgeId" column="direct_edge_id" type="long" index="LAGER_DAG_DIRECT_EDGE_IDX"/></p>
<p style='margin-top:0;margin-bottom:10px;'> <property name="exitEdgeId" column="exit_edge_id" type="long" index="LAGER_DAG_EXIT_EDGE_IDX"/></p>
<p style='margin-top:0;margin-bottom:10px;'> <property name="hops" column="hops" type="long" not-null="true" index="LAGER_DAG_HOPS"/></p>
<p style='margin-top:0;margin-bottom:10px;'> <property name="dagId" column="dag_id" type="string" not-null="true" index="LAGER_DAG_ID_IDX"/></p>
<p style='margin-top:0;margin-bottom:10px;'> <component name="startVertex" class="com.gss.lager.texture.domain.UUID"><br/>
<property name="higherBits" column="start_vertex_hi" index="LAGER_DAG_START_VTX_HI"/><br/>
<property name="lowerBits" column="start_vertex_lo" index="LAGER_DAG_START_VTX_LO"/><br/>
</component></p>
<p style='margin-top:0;margin-bottom:10px;'> <component name="endVertex" class="com.gss.lager.texture.domain.UUID"><br/>
<property name="higherBits" column="end_vertex_hi" index="LAGER_DAG_END_VTX_HI"/><br/>
<property name="lowerBits" column="end_vertex_lo" index="LAGER_DAG_END_VTX_LO"/><br/>
</component></p>
<p style='margin-top:0;margin-bottom:10px;'> </class><br/>
</hibernate-mapping></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/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;">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="finion" id="email_finion" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=finion" style="color:#6c797f;">finion</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 <a style='color:#6c797f;' href='https://hibernate.onjira.com/secure/ContactAdministrators!default.jspa'>JIRA administrators</a>.<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 -->