Pojo to jsonb column mapping?

Hibernate ORM
1

Hi all;
after many GPT and claude sessions without success I am turning to the community for a little help.
my goal is simple, map a POJO to a jsonb column in posgres using PG15, hibernate 6.4 and jpa.
my stand alone java application is pretty simple: 1 entity, 1 pojo, main class as follows (stripped down code, persistence.xml ommited as there is nothing special there):

PolicyEntity{
....
@JdbcTypeCode(SqlTypes.JSON)
@Column(name = "data", columnDefinition = "jsonb")
private PolicyPOJO data;
...
}


PolicyPOJO{
...
public PolicyPOJO(){}
private String createdBy;
private List<String> rules;
...
}

main{
...
EntityManagerFactory emf = Persistence.createEntityManagerFactory("nms");
...
}

main throws:
“Exception in thread “main” org.hibernate.type.descriptor.java.spi.JdbcTypeRecommendationException: Could not determine recommended JdbcType for Java type ‘jsonbjpa.PolicyPOJO’”

note that I have cycled through many annotations on the data property and also tried hypersistence utils types but all yields the same. i am completely lost here even thouigh the error message seems straight forward.
is pojo mapping working with my versions? docuemntation shows a Map only example.
am I doing something wrong here?
note that i project is not a maven/gradle one, its a bring your own jars… maybe a jar is missing?
list of jars in the classpath below…
any help would be great (TBH, i cant get String to work also. i might be missing something)
10x

image
image544×358 10.8 KB

2

This mapping should be fine:

@Entity
public class PolicyEntity{
....
@JdbcTypeCode(SqlTypes.JSON)
@Column(name = "data")
private PolicyPOJO data;
...
}

I suppose that your runtime simply has an old version of Hibernate ORM that can’t understand this @JdbcTypeCode annotation. Make sure that you are running with Hibernate ORM 6.2+

I see you’re using Wildfly, make sure that your WAR/EAR file does not contain any hibernate-core JARs, the server already ships with a version.

3

thanks a lot for the answer.
i have reduced my code the required minimum and now things work.
now I have to add things back and see what is the reason for the error…
thanks again.
[update] maybe for those in an endless loop it would be helpful that my problem was the fact that the entities were defined with mappings on the getters and not the properties. this is allowed by JPA but apperantly this is problematic in jsonb mapping…