Hi,
I'm getting a duplicate key exception when trying to use findOrSaveWhere on a domain class. I don't know how this is possible when I'm handing in the entire key as part of the findOrSave.
Below is the domain class. The method is failing in the findOrSaveAll method at the bottom with an exception:
ERROR: hibernate.util.JDBCExceptionReporter Batch entry 0 insert into schema.object_reference (version, key, source, type, id) values ('0', '243', 'none', 'Feature', '379') was aborted. Call getNextException to see the cause.
ERROR: hibernate.util.JDBCExceptionReporter ERROR: duplicate key value violates unique constraint "object_reference_type_source_key_key"
class ObjectReference {
static constraints = {
source(nullable: false, blank: false)
type(nullable: false, blank: false)
key(unique: ['source', 'type'], nullable: false, blank: false)
}
static beforeUpdate = {
throw new InvalidOperationException("Object references cannot be updated.")
}
String source
String type
String key
static String SOURCE_DEFAULT = "none"
ObjectReference() {
source = SOURCE_DEFAULT
}
/*
Finds or creates all objects in the list.
Objects should have the following properties:
[source], type, key
This method finds or creates all of the objects in the list.
*/
static List<ObjectReference> findOrSaveAll(ArrayList objects) {
def result = []
for (int i = 0; i < objects.size(); i++) {
def o = objects[i];
o.source = o.source ?: SOURCE_DEFAULT
if (o.source && o.type && o.key) {
result << ObjectReference.findOrSaveWhere(source: o.source.toString().trim(), type: o.type.toString().trim(), key: o.key.toString().trim())
}
}
return result
}
}
Locked
