I want to know how to eliminate duplicate nodes in neo4j using spring boot without using merge clause

[shashireddy055]

I have created a pojo class and set up a structure how nodes should be created in neo4j. Using .save method which is inbuilt in neo4jRepository i am sending data using postman.
public Book addBook(Book book) {
return repository.save(book);
}
@PostMapping("/addBook")
public Classifier addingClassifier(@RequestBody Book book)) {
return bookService.addBook(book);
}

if i send same data using postman then neo4j is creating duplicate nodes. How to stop creating duplicate nodes.

[stefan_armbrust]

use a unique constraint.

[shashireddy055]

tried with unique constraint but it is of no use. It did not stop creating duplicate nodes.

[stefan_armbrust]

By definition a unique constraint prevents duplication. I guess you're applying it not correctly.

[shashireddy055]

No, I think I am using it correctly.

@NodeEntity
public class Book {

@Id
@GeneratedValue
private Long id;

@Index(unique = true)
private String name;

@Index(unique = true)
@Relationship(type = "Comprises_Of",direction = Relationship.OUTGOING)
private Set<Publishers> publishers;

}

[stefan_armbrust]

what constraints do you actually have in the db: call db.constraints() ?

[shashireddy055]

no constraints are applied to the fields.

[shashireddy055]

@Index(Unique = true) is not working in the expected way. Please verify how to apply the unique constraint in spring boot code and let me know.

[stefan_armbrust]

why not just fire a create constraint on .... statement directly to the database and you're done?