CF2018 / Hibernate / Sequences not being utilized & mappings not being saved
Hoping someone can help with this issue! I've set up ORM settings as below and my model is set up as listed. However, when utilizing, I keep getting an error that ID already exists and it appears CF is using hibernate_sequence instead of the sequence I'm specifying. Furthermore, even with savemapping=true, it is not creating any hibernate xml files (supposed to be in same directory as models).
I'm using Postgresql as the DB. I've tried restarting / different settings (even different JDBC drivers), etc without success.
This code was working fine with CF10 and trying to upgrade (unsuccessfully) to CF2018.
this["ormsettings"] = {
datasource = "db_icp",
eventHandling = false,
logsql=false,
savemapping=true,
cfclocation = application.mappings["models"]
};
component name="logins" entityName="logins" persistent="true" table="logins"
{
property name="id" column="id" fieldtype="id"
generator="sequence" params="{sequence='seq_logins_id'}";
property name="userName" type="string" hint="user who attempted login";
property name="dateInserted" ormtype="timestamp" hint="datetime of the login attempt";
property name="ipAddress" type="string" hint="IP address logged in from";
}
