tracker issue : CF-4198329

Problem Description:
java.lang.NullPointerException
	at org.hibernate.internal.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:415)
	at org.hibernate.internal.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:385)
	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:99)
	at coldfusion.orm.hibernate.HibernatePersistenceManager._executeHQL(HibernatePersistenceManager.java:828)
	at coldfusion.orm.hibernate.HibernatePersistenceManager.executeHQL(HibernatePersistenceManager.java:757)
	at coldfusion.orm.hibernate.HibernatePersistenceManager.executeQuery(HibernatePersistenceManager.java:617)
	at coldfusion.orm.ORMUtils._executeQuery(ORMUtils.java:348)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:797)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cftest2ecfm1686140605.runPage(C:\Dev\ColdFusion Builder 3 workspace\amh\test.cfm:360)

Steps to Reproduce:
Was able to reproduce using three different methods of HQL query.

Method 1:
<cfscript>
		local.sqlText = "
				SELECT count(*) as countEDIsubmissions
				FROM FACILITY_DATA_SUBMISSION
				WHERE FDS_FACILITY_ID = ?
				  and FDS_SUBMISSION_METHOD = 'EDI'";
		local.facilityEDIStatus = ORMExecuteQuery(local.sqlText, [139]);

Method 2:
		local.sqlText = "
				SELECT count(*) as countEDIsubmissions
				FROM FACILITY_DATA_SUBMISSION
				WHERE FDS_FACILITY_ID = :facid
				  and FDS_SUBMISSION_METHOD = 'EDI'";
		local.facilityEDIStatus = ORMExecuteQuery(local.sqlText, {facid = 139);

Method 3:

		<cfquery name="LOCAL.facilityEDIStatus" dbtype="hql">
    				SELECT count(*) as countEDIsubmissions
				FROM FACILITY_DATA_SUBMISSION
				WHERE FDS_FACILITY_ID = <cfqueryparam  value="139">
				  and FDS_SUBMISSION_METHOD = 'EDI'
                </cfquery>

Actual Result:
same error above for all three versions

Expected Result:
For the HQL query to run.

Any Workarounds:
Found none, but attempted following:
Updated ColdFusion to 2016.3 - No Effect
Updated Java on host to 8.20 - No Effect
Updated the jre in ColdFusion to 8.20 - No Effect
Update the hibernate.core JAR file in \cfusion\lib to 5.2.6 - Cold Fusion unable to bind to the newer JAR.  - Restored 4.3.10 JAR file

Attachments:

Comments: