The problem was of my own creation.
Indeeed @Zackster, I needed to add an ormFlush().
Because although in Lucee/Admin Flush at request end is TRUE, in Application.cfc it is set to false.
So the fact that it didn’t save, is the expected behaviour with my code.
But then I was wondering, why is it that object.save() worked without the ormFlush()?
So I looked into the code, and found that we have defined a superclass that all ORM classes inherit from - and in that class is a save() method - where the entitySave() is wrapped in a transaction / try and transactionCommit(), ensures the data saved to the DB.
Whoever thought that reading your own code, could be so insightful?
Gavin.