<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <base href="https://hibernate.atlassian.net" />
<title>Message Title</title>
</head>
<body class="jira" style="color: #333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<!-- header here -->
<tr>
<td id="header-pattern-container" style="padding: 0px; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px"> <img id="header-avatar-image" class="image_fix" src="https://secure.gravatar.com/avatar/3f5a6a034cb3db16ac718e2fec1bda4c?d=mm&s=48" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top" />
</td>
<td id="header-text-container" valign="middle" style="padding: 0px; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="mikewilklow" id="email_mikewilklow" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=mikewilklow" style="color:#6c797f;; color: #3b73af; text-decoration: none">Mike Wilklow</a> <strong>created</strong> an issue
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0px; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-spacing: 0; border-collapse: separate">
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 15px; background-color: #fff; border-left: 1px solid #ccc; border-top: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly">
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="page-title-pattern-first-line " style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-8653" style="color: #3b73af; text-decoration: none"><img src="https://hibernate.atlassian.net/images/icons/issuetypes/task.png" height="16" width="16" border="0" align="absmiddle" alt="Task" style="vertical-align: text-bottom" /></a> <a href="https://hibernate.atlassian.net/browse/HHH-8653" style="color: #3b73af; text-decoration: none">HHH-8653</a>
</td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0px; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-8653" style="color: #3b73af; text-decoration: none">Value Handler missing for Date Literals</a> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; padding-top: 10px; padding-bottom: 5px">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Issue Type:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="https://hibernate.atlassian.net/images/icons/issuetypes/task.png" height="16" width="16" border="0" align="absmiddle" alt="Task" style="vertical-align: text-bottom" /> Task
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Affects Versions:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
4.2.5, 4.0.1
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Assignee:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
Unassigned
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Components:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
core, entity-manager
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Created:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
29/Oct/13 9:05 AM
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Environment:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
hibernate-core-4.2.5.Final, hsqldb 2.3.0
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Labels:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
literal date DateLiteral ValueHandler
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Priority:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="https://hibernate.atlassian.net/images/icons/priorities/minor.png" height="16" width="16" border="0" align="absmiddle" alt="Minor" style="vertical-align: text-bottom" /> Minor
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Reporter:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="mikewilklow" id="email_mikewilklow" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=mikewilklow" style="color:#6c797f;; color: #3b73af; text-decoration: none">Mike Wilklow</a>
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Original Estimate:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
16h
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Remaining Estimate:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
16h
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; padding-top: 5px; padding-bottom: 10px">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0px; border-collapse: collapse; padding: 0 0 10px 0">
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">There is no value handler for date types defined in the ValueHandlerFactory class. This means that attempting to select a date literal will result in a null pointer exception.</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">I ran into this bug when attempting to implement coalesce using date properties. The following code throws an exception:</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">query.select(coalesce(pathToDatePropertyOnEntity, defaultDateLiteral));</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Coalesce should select the date property off some entity unless it is null, in which case it will select the supplied date literal. But because no handling for date literals exists, this instruction throws a null pointer exception.</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Simple test case:</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">@Test<br /> public void testFoo() throws Exception</p> { //insert an element into the database Session session = sessionFactory.getCurrentSession(); session.beginTransaction(); SampleClass sample = new SampleClass(); session.save(sample); session.getTransaction().commit(); criteriaQuery.from(SampleClass.class); criteriaQuery.select(criteriaBuilder.literal(new Date())); TypedQuery<Date> jpaQuery = entityManager.createQuery(criteriaQuery); List<Date> results = jpaQuery.getResultList(); Assert.assertEquals(1, results.size()); }
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Test Output:</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">DateLiteralJpaEvaluatorTest,testFoo<br /> Oct 29, 2013 10:37:56 AM org.hibernate.annotations.common.Version <clinit><br /> INFO: HCANN000001: Hibernate Commons Annotations </p> {4.0.2.Final}
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Oct 29, 2013 10:37:56 AM org.hibernate.Version logVersion<br /> INFO: HHH000412: Hibernate Core </p> {4.2.5.Final}
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Oct 29, 2013 10:37:56 AM org.hibernate.cfg.Environment <clinit><br /> INFO: HHH000206: hibernate.properties not found<br /> Oct 29, 2013 10:37:56 AM org.hibernate.cfg.Environment buildBytecodeProvider<br /> INFO: HHH000021: Bytecode provider name : javassist<br /> Oct 29, 2013 10:37:57 AM org.hibernate.dialect.Dialect <init><br /> INFO: HHH000400: Using dialect: org.hibernate.dialect.HSQLDialect<br /> Oct 29, 2013 10:37:57 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService<br /> INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory<br /> Oct 29, 2013 10:37:57 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init><br /> INFO: HHH000397: Using ASTQueryTranslatorFactory<br /> Oct 29, 2013 10:37:57 AM org.hibernate.validator.internal.util.Version <clinit><br /> INFO: HV000001: Hibernate Validator 5.0.0.Final<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute<br /> INFO: HHH000228: Running hbm2ddl schema update<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute<br /> INFO: HHH000102: Fetching database metadata<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute<br /> INFO: HHH000396: Updating schema<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata<br /> INFO: HHH000262: Table not found: SampleClass<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata<br /> INFO: HHH000262: Table not found: SampleClass<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata<br /> INFO: HHH000262: Table not found: SampleClass<br /> Oct 29, 2013 10:37:58 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute<br /> INFO: HHH000232: Schema update complete<br /> create table SampleClass (id binary(255) not null, booleanProperty boolean, dateProperty timestamp, numberProperty numeric(19,2), stringProperty varchar(255), primary key (id))<br /> Oct 29, 2013 10:37:58 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init><br /> INFO: HHH000397: Using ASTQueryTranslatorFactory<br /> Oct 29, 2013 10:37:58 AM org.hibernate.type.TypeFactory$TypeScopeImpl injectSessionFactory<br /> WARN: HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@7a8eb36a after already scoped org.hibernate.internal.SessionFactoryImpl@5dd23619</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">java.lang.NullPointerException<br /> at org.hibernate.ejb.criteria.expression.LiteralExpression.renderProjection(LiteralExpression.java:82)<br /> at org.hibernate.ejb.criteria.QueryStructure.render(QueryStructure.java:250)<br /> at org.hibernate.ejb.criteria.CriteriaQueryImpl.render(CriteriaQueryImpl.java:338)<br /> at org.hibernate.ejb.criteria.CriteriaQueryCompiler.compile(CriteriaQueryCompiler.java:223)<br /> at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:622)<br /> at com.tr.grc.storage.eval.jpa.date.DateLiteralJpaEvaluatorTest.testFoo(DateLiteralJpaEvaluatorTest.java:78)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br /> at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)<br /> at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)<br /> at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)<br /> at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)<br /> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)<br /> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)<br /> at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)<br /> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)<br /> at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)<br /> at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)<br /> at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)<br /> at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)<br /> at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)<br /> at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)<br /> at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)<br /> at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)<br /> at org.junit.runners.ParentRunner.run(ParentRunner.java:309)<br /> at org.junit.runner.JUnitCore.run(JUnitCore.java:160)<br /> at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:77)<br /> at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:195)<br /> at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:63)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br /> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0px; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0px; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-8653#add-comment" target="_blank" title="{getText($action.text)}" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="https://hibernate.atlassian.net/images/mail/comment-icon.png" alt="Add Comment" title="{Add Comment}-icon" height="16" width="16" border="0" style="vertical-align: middle" /> </a>
</td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-8653#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #fff; border-top: 0; border-left: 1px solid #ccc; border-bottom: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0px; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px; border-collapse: collapse; color: #999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px">
This message was sent by Atlassian JIRA <span id="footer-build-information">(v6.2-OD-01#6204-<span title="9a81f1273565b708db95415d383556dcb6085057" data-commit-id="9a81f1273565b708db95415d383556dcb6085057}">sha1:9a81f12</span>)</span>
</td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0px; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse; padding-top: 3px"> <img id="footer-pattern-logo-desktop" src="https://hibernate.atlassian.net/images/mail/footer-desktop-logo.png" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>