How to map List<UUID> to array with Hibernate?

Question

I'm setting up a table in Postgres, and want to map List to jdbc array type using custom @Converter class. But I

get org.hibernate.MappingException: No Dialect mapping for JDBC type: 984991021

//StoredJob class for creating table:
@Entity
@Table(name = "jobs")
public class StoredJob {
 ....
//The error is here
@Column
@Convert(converter = JobFileListConverter.class)
private List<UUID> jobFiles;

//Converter class:
@Converter
public class JobFileListConverter implements 
                        AttributeConverter<List<UUID>, UUID[]> {
@Override
public UUID[] convertToDatabaseColumn(List<UUID> uuidList) {
    return uuidList.toArray(UUID[]::new);
}

@Override
public List<UUID> convertToEntityAttribute(UUID[] uuidArray) {
    return Arrays.asList(uuidArray);
}

What is your database schema ? I've used many times mapping to lists and I never encountered issues or needed a converter. If you're removing your converter it does not work ? — A Le Dref
– A Le Dref, Commented Sep 3, 2019 at 7:11
Have a look here stackoverflow.com/questions/287201/… and here stackoverflow.com/questions/4495233/… perhaps — dpr
– dpr, Commented Sep 3, 2019 at 7:12
A Le Dref, if i remove converter i get another exception: Could not determine type for: java.util.List, at table: jobs, for columns: [org.hibernate.mapping.Column(job_files) — SurPrise 2
– SurPrise 2, Commented Sep 3, 2019 at 7:23

shaahin2010 · Accepted Answer · 2019-09-03 07:21:45Z

1

Change this:

private List<UUID> jobFiles;

with this one:

private UUID[] jobFiles;

But, I strongly suggest you to remove '@Convert' annotation and add a getter method as below:

public UUID[] getJobFiles() {
    return jobFiles.stream().toArray(UUID[]::new);
}

answered Sep 3, 2019 at 7:21

shaahin2010

112 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SurPrise 2 Over a year ago

But what if i want to operate with jobFiles as a list?

shaahin2010 Over a year ago

You can handle it using different getter/setter

Collectives™ on Stack Overflow

How to map List<UUID> to array with Hibernate?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related