<!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: #333333; 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" bgcolor="#f5f5f5"> 
            <!-- header here --> 
            <tbody>
                <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"> 
                            <tbody>
                                <tr> 
                                    <td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px" width="32"> <img id="header-avatar-image" class="image_fix" src="cid:jira-generated-image-avatar-b6dfd4d1-eff3-49b2-8762-4873ed89c651" 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="steve" id="email_steve" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=steve" style="color:#6c797f;; color: #3b73af; text-decoration: none">Steve Ebersole</a> <strong>updated</strong> an issue </td> 
                                </tr> 
                            </tbody>
                        </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"> 
                            <tbody>
                                <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: #ffffff; padding: 0 15px 0 16px; height: 15px; background-color: #ffffff; border-left: 1px solid #cccccc; border-top: 1px solid #cccccc; border-right: 1px solid #cccccc; 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" height="10" bgcolor="#ffffff">&nbsp;</td> 
                                </tr> 
                                <tr> 
                                    <td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff"> 
                                        <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"> 
                                            <tbody>
                                                <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-10446" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-avatar-c2d51f7d-e13e-47f7-ad28-8e4111a06561" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"></a> <a href="https://hibernate.atlassian.net/browse/HHH-10446" style="color: #3b73af; text-decoration: none">HHH-10446</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-10446" style="color: #3b73af; text-decoration: none">Hibernate 5.1 not able to find native query parameter by index</a> </span> </td> 
                                                </tr> 
                                            </tbody>
                                        </table> </td> 
                                </tr> 
                                <tr> 
                                    <td class="email-content-main mobile-expand  wrapper-special-margin" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 10px; padding-bottom: 5px" bgcolor="#ffffff"> 
                                        <table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt"> 
                                            <tbody>
                                                <tr> 
                                                    <th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Change By:</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="steve" id="email_steve" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=steve" style="color:#6c797f;; color: #3b73af; text-decoration: none">Steve Ebersole</a> </td> 
                                                </tr> 
                                            </tbody>
                                        </table> </td> 
                                </tr> 
                                <tr> 
                                    <td class="email-content-main mobile-expand  issue-description-container" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 5px; padding-bottom: 10px" bgcolor="#ffffff"> 
                                        <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"> 
                                            <tbody>
                                                <tr> 
                                                    <td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0px; border-collapse: collapse; padding: 0 0 10px 0"> <span class="diffcontext">Spring4&nbsp;is&nbsp;used&nbsp;as&nbsp;dependency&nbsp;Injection,&nbsp;the&nbsp;following&nbsp;code&nbsp;wrote&nbsp;for&nbsp;my&nbsp;sql&nbsp;db&nbsp;<br></span> <span class="diffaddedchars" style="background-color:#ddfade;"><br>{code}<br></span> <span class="diffcontext">public&nbsp;List&lt;Edi204DrayPortal&gt;&nbsp;findbyHasDrayPortalStatusLimit(DataTablesReqRto&nbsp;criterias)&nbsp;{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int&nbsp;start&nbsp;&nbsp;=&nbsp;criterias.getStart();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;int&nbsp;length&nbsp;=&nbsp;criterias.getLength();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Global&nbsp;search&nbsp;string<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String&nbsp;searchValue&nbsp;=&nbsp;criterias.getSearch().getValue();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;Order&gt;&nbsp;orderValues&nbsp;=&nbsp;criterias.getOrder();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;Columns&gt;&nbsp;colIds&nbsp;=&nbsp;criterias.getColumns();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Query&nbsp;query&nbsp;=&nbsp;&nbsp;&nbsp;em.createNativeQuery(<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"&nbsp;&nbsp;&nbsp;select&nbsp;user,&nbsp;apptment,&nbsp;dnum,&nbsp;ln,&nbsp;vendorid,&nbsp;city,&nbsp;coalesce(d.destin,&nbsp;'--ERR&nbsp;PHONE&nbsp;IT--')&nbsp;as&nbsp;rt&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;",&nbsp;ramp&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;",&nbsp;if(rail&nbsp;is&nbsp;NULL&nbsp;,'N',&nbsp;'Y')&nbsp;as&nbsp;rail&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;",&nbsp;portalstatus&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;",&nbsp;st&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;",&nbsp;sentvia&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;",&nbsp;coalesce(d.state,&nbsp;'--ERR&nbsp;PHONE&nbsp;IT--')&nbsp;as&nbsp;rtstate&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;from&nbsp;(&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;select&nbsp;if(e.dnum&nbsp;=&nbsp;1,&nbsp;'Pickup',&nbsp;'Delivery')&nbsp;as&nbsp;dnum&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e.ln,&nbsp;e.user,&nbsp;e.vendorid,&nbsp;e.portalstatus&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(e.dnum&nbsp;=&nbsp;1,&nbsp;date_format(a.apptment,'%Y-%m-%d&nbsp;%H:%i'),&nbsp;date_format(ad.cnapptment,'%Y-%m-%d&nbsp;%H:%i'))&nbsp;as&nbsp;apptment&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(e.dnum&nbsp;=&nbsp;1,&nbsp;a.shipst,&nbsp;a.constt)&nbsp;as&nbsp;st&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(e.dnum&nbsp;=&nbsp;1,&nbsp;a.shipcity,&nbsp;a.concity)&nbsp;as&nbsp;city&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(e.dnum&nbsp;=&nbsp;1,&nbsp;ad.orig1rp,&nbsp;ad.dest1rp)&nbsp;as&nbsp;ramp&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;coalesce(rb1.sentvia,&nbsp;'--NONE--')&nbsp;as&nbsp;sentvia&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rb1.rail&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ad.cnunicomp,&nbsp;ad.cnunitel&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;&nbsp;&nbsp;from&nbsp;edi204dray&nbsp;e&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;join&nbsp;armast&nbsp;a&nbsp;on&nbsp;a.ln&nbsp;=&nbsp;e.ln&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;join&nbsp;additional&nbsp;ad&nbsp;on&nbsp;ad.ln&nbsp;=&nbsp;e.ln&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;left&nbsp;join&nbsp;edirailbill&nbsp;rb1&nbsp;on&nbsp;rb1.ln&nbsp;=&nbsp;e.ln&nbsp;and&nbsp;rb1.recno&nbsp;=&nbsp;(select&nbsp;max(rb2.recno)&nbsp;from&nbsp;edirailbill&nbsp;rb2&nbsp;where&nbsp;rb2.ln&nbsp;=&nbsp;rb1.ln)&nbsp;"<br>{color:#d04437}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;where&nbsp;e.recno&nbsp;=&nbsp;(select&nbsp;max(ee.recno)&nbsp;from&nbsp;edi204dray&nbsp;ee&nbsp;where&nbsp;ee.ln&nbsp;=&nbsp;e.ln&nbsp;and&nbsp;ee.dnum&nbsp;=&nbsp;e.dnum)&nbsp;"{color}<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;appendSearch(colIds,&nbsp;searchValue)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;and&nbsp;portalstatus&nbsp;is&nbsp;not&nbsp;null&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;and&nbsp;not&nbsp;((portalstatus&nbsp;=&nbsp;'Ingate'&nbsp;or&nbsp;portalstatus&nbsp;=&nbsp;'Ingate&nbsp;Empty/Street&nbsp;Turn')&nbsp;and&nbsp;DATEDIFF(&nbsp;NOW(),&nbsp;ackdate)&nbsp;&gt;&nbsp;1)&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;order&nbsp;by&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;appendOrder(orderValues,&nbsp;colIds)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;limit&nbsp;(?1),(?2)&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;)&nbsp;t&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;"&nbsp;left&nbsp;join&nbsp;dest&nbsp;d&nbsp;on&nbsp;substring(d.destin,1,25)&nbsp;=&nbsp;t.cnunicomp&nbsp;and&nbsp;d.phone&nbsp;=&nbsp;t.cnunitel&nbsp;"<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,&nbsp;"CSRDashBoardMapping");<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;query.setParameter(1,&nbsp;start)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setParameter(2,&nbsp;length)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.getResultList();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}catch(Exception&nbsp;exp){<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exp.printStackTrace();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;null&nbsp;;<br>&nbsp;&nbsp;&nbsp;}<br></span> <span class="diffaddedchars" style="background-color:#ddfade;">{code}</span> <span class="diffcontext"><br></span> <span class="diffaddedchars" style="background-color:#ddfade;"><br><br></span> <span class="diffcontext">Expectation:&nbsp;the&nbsp;code&nbsp;must&nbsp;find&nbsp;the&nbsp;parameter&nbsp;(?1),&nbsp;(?2)&nbsp;<br>Other&nbsp;place&nbsp;for&nbsp;Error:&nbsp;add&nbsp;parameter&nbsp;at&nbsp;the&nbsp;end&nbsp;of&nbsp;red&nbsp;where&nbsp;just&nbsp;before&nbsp;closing&nbsp;the&nbsp;)&nbsp;like&nbsp;and&nbsp;e.dnum=&nbsp;?1&nbsp;,&nbsp;e.dnum=&nbsp;:dNumVal,&nbsp;e.dnum=&nbsp;(?1),&nbsp;or&nbsp;e.dnum=?&nbsp;none&nbsp;of&nbsp;this&nbsp;work&nbsp;in&nbsp;this&nbsp;version,&nbsp;all&nbsp;of&nbsp;it&nbsp;work&nbsp;on&nbsp;version&nbsp;5.0&nbsp;<br><br>the&nbsp;following&nbsp;is&nbsp;the&nbsp;stack&nbsp;trace&nbsp;<br><br>this&nbsp;code&nbsp;was&nbsp;working&nbsp;fine&nbsp;in&nbsp;hibernate&nbsp;v5&nbsp;until&nbsp;we&nbsp;upgrade&nbsp;we&nbsp;start&nbsp;get&nbsp;the&nbsp;following&nbsp;exception&nbsp;I&nbsp;try&nbsp;?,&nbsp;?1,&nbsp;and&nbsp;(?1)&nbsp;to&nbsp;add&nbsp;the&nbsp;parameter&nbsp;to&nbsp;the&nbsp;query&nbsp;non&nbsp;of&nbsp;them&nbsp;work&nbsp;on&nbsp;hibernate&nbsp;5.1,&nbsp;any&nbsp;help&nbsp;from&nbsp;you&nbsp;will&nbsp;be&nbsp;highly&nbsp;appreciated.<br><br></span> <span class="diffaddedchars" style="background-color:#ddfade;">{noformat}<br></span> <span class="diffcontext">11:47:41,593&nbsp;ERROR&nbsp;[org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/dray-1.0.0-SNAPSHOT].[com.celticintl.dray]]&nbsp;(http-/127.0.0.1:8080-5)&nbsp;JBWEB000236:&nbsp;Servlet.service()&nbsp;for&nbsp;servlet&nbsp;com.celticintl.dray&nbsp;threw&nbsp;exception:&nbsp;java.lang.IllegalArgumentException:&nbsp;Parameter&nbsp;with&nbsp;that&nbsp;position&nbsp;[1]&nbsp;did&nbsp;not&nbsp;exist<br>at&nbsp;org.hibernate.jpa.spi.BaseQueryImpl.findParameterRegistration(BaseQueryImpl.java:501)&nbsp;[hibernate-entitymanager-5.1.0-20160111.170655-128.jar:5.1.0.SNAPSHOT]<br>at&nbsp;org.hibernate.jpa.spi.BaseQueryImpl.setParameter(BaseQueryImpl.java:691)&nbsp;[hibernate-entitymanager-5.1.0-20160111.170655-128.jar:5.1.0.SNAPSHOT]<br>at&nbsp;org.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:181)&nbsp;[hibernate-entitymanager-5.1.0-20160111.170655-128.jar:5.1.0.SNAPSHOT]<br>at&nbsp;org.hibernate.jpa.spi.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:32)&nbsp;[hibernate-entitymanager-5.1.0-20160111.170655-128.jar:5.1.0.SNAPSHOT]<br>at&nbsp;sun.reflect.NativeMethodAccessorImpl.invoke0(Native&nbsp;Method)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;java.lang.reflect.Method.invoke(Method.java:606)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:360)&nbsp;[spring-orm-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;com.sun.proxy.$Proxy177.setParameter(Unknown&nbsp;Source)<br>at&nbsp;com.celticintl.dray.dto.Edi204DrayPortal.findbyHasDrayPortalStatusLimit(Edi204DrayPortal.java:224)&nbsp;[classes:]<br>at&nbsp;com.celticintl.dray.controller.OrderMonitorDashBoardControllerRest.getDataTableInfo(OrderMonitorDashBoardControllerRest.java:34)&nbsp;[classes:]<br>at&nbsp;sun.reflect.NativeMethodAccessorImpl.invoke0(Native&nbsp;Method)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;java.lang.reflect.Method.invoke(Method.java:606)&nbsp;[rt.jar:1.7.0_79]<br>at&nbsp;org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)&nbsp;[spring-web-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)&nbsp;[spring-web-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:754)&nbsp;[jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]<br>at&nbsp;org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)&nbsp;[spring-webmvc-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;javax.servlet.http.HttpServlet.service(HttpServlet.java:847)&nbsp;[jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]<br>at&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;com.celticintl.dray.filters.TenantIdentifierFilter.doFilter(TenantIdentifierFilter.java:80)&nbsp;[classes:]<br>at&nbsp;org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)&nbsp;[spring-web-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)&nbsp;[spring-web-4.1.1.RELEASE.jar:4.1.1.RELEASE]<br>at&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:208)&nbsp;[cors-filter-2.4.jar:2.4]<br>at&nbsp;com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:274)&nbsp;[cors-filter-2.4.jar:2.4]<br>at&nbsp;org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)&nbsp;[jboss-as-web-7.4.0.Final-redhat-19.jar:7.4.0.Final-redhat-19]<br>at&nbsp;org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)&nbsp;[jbossweb-7.4.8.Final-redhat-4.jar:7.4.8.Final-redhat-4]<br>at&nbsp;java.lang.Thread.run(Thread.java:745)&nbsp;[rt.jar:1.7.0_79]</span> <span class="diffaddedchars" style="background-color:#ddfade;"><br>{noformat}<br></span> </td> 
                                                </tr> 
                                            </tbody>
                                        </table> </td> 
                                </tr> 
                                <tr> 
                                    <td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff"> 
                                        <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"> 
                                            <tbody>
                                                <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"> 
                                                            <tbody>
                                                                <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-10446#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-77bc0869-ff36-4823-ad3a-31c1e09d07f2" alt="Add Comment" title="Add Comment" 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-10446#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a> </td> 
                                                                </tr> 
                                                            </tbody>
                                                        </table> </td> 
                                                </tr> 
                                            </tbody>
                                        </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: #ffffff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #ffffff; border-top: 0; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly" height="5" bgcolor="#ffffff">&nbsp;</td> 
                                </tr> 
                            </tbody>
                        </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"> 
                            <tbody>
                                <tr> 
                                    <td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px; border-collapse: collapse; color: #999999; 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">(v7.1.0-OD-05-006#71001-<span title="081cc1af5ccca4c5c6d6a6b62118b45ebbf699ab" data-commit-id="081cc1af5ccca4c5c6d6a6b62118b45ebbf699ab}">sha1:081cc1a</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"> 
                                            <tbody>
                                                <tr> 
                                                    <td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse; padding-top: 3px"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-1b765304-410f-42b9-b001-665b7a17e8dc" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix"> </td> 
                                                </tr> 
                                            </tbody>
                                        </table> </td> 
                                </tr> 
                            </tbody>
                        </table> </td> 
                </tr> 
            </tbody>
        </table>   
    </body>
</html>