query result offset is not supported
Hi folks,
we are testing application in ColdFusion 2021
I am getting below error message as i am using offset in ormExecuteQuery()
we used offset for pagination.
error is : "query result offset is not supported"
I tried below steps to resolve but none work for me.
1. Adding hibernate configuration file
this.ormSettings.ormconfig = "hibernate.cfg.xml";
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name = "hibernate.legacy_limit_handler">true</property>
</session-factory>
</hibernate-configuration>
2. Adding below setting along with other orm settings.
<cfset structInsert( this.ormSettings,'hibernate',structNew(),true )>
<cfset structInsert( this.ormSettings.hibernate,'legacy_limit_handler',true,true )>
i am not sure this works or not but tried based on other community posts.
3. Adding as java arguments.
Add the following flag in ColdFusion's jvm.config file.
-DHibernate.legacy_limit_handler=true
Any words of wisdom would be appreciated.
AdChoices