23
Replies
This ormsettings solution unfortunately is not working for us. Our this.ormsettings values are displayed in the attached image. We are evaluating CF2021 to upgrade but have to get beyond this hurdle to do so. Hoping that someone out there has been down this path with the challenge of a legacy db table named as a reserved word such as 'case' or 'group' and short of going through a large painful refactor - is there a way in CF 2021/Hibernate 5.2 to force Hibernate/ORM to simply wrap eg: [] in MS SQL Server? This reserved word issue does not surface in CF2016.
This ormsettings solution unfortunately is not working for us. Our this.ormsettings values are displayed in the attached image. We are evaluating CF2021 to upgrade but have to get beyond this hurdle to do so. Hoping that someone out there has been down this path with the challenge of a legacy db table named as a reserved word such as 'case' or 'group' and short of going through a large painful refactor - is there a way in CF 2021/Hibernate 5.2 to force Hibernate/ORM to simply wrap eg: [] in MS SQL Server? This reserved word issue does not surface in CF2016.
By @Phia Dev
I know of 4 ways to enable Hibernate to use reserved words. It is doubtful whether they will work in ColdFusion. However, you'll never know till you try.
- Use backticks (for individual reserved words). For example, replace case, group, etc. with `case`, `group`, etc.
- Set hibernate.globally_quoted_identifiers as a Java property (global, for every reserved word).
- Create a file named hibernate.properties and include its full path in the classpath (global, for every reserved word).
- Create a Hibernate configuration file, hibernate.cfg.xml and include its full path as the value of this.ormSettings.ormconfig (global, for every reserved word).
Option 1:
straightforward.
Option 2:
Add the following flag in ColdFusion's jvm.config file.
-DHibernate.globally_quoted_identifiers=true
Then restart ColdFusion.
Option3:
Contents of the file hibernate.properties
hibernate.globally_quoted_identifiers=trueInclude the full path of the file in the classpath setting in jvm.config.
Restart ColdFusion.
Option 4:
My guess for implementing this option:
<cfset this.ormsettings = {
...
ormconfig="absolute_path_to_Hibernate_configuration_file"
...
}>
There are 2 possible versions of the file hibernate.cfg.xml, depending on whether a public or system DTD is ised.
Public DTD
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="java:hibernate/SessionFactory">
<property name="hibernate.globally_quoted_identifiers" >true</property>
</session-factory>
</hibernate-configuration>
System DTD
<?xml version = "1.0" encoding = "utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name = "hibernate.globally_quoted_identifiers">true</property>
</session-factory>
</hibernate-configuration>
AdChoices