Styjun

D Scale Question

Could these polynomials be identified?

Why wasn't Linda Hamilton in T3?

How does the search space affect the speed of an ILP solver?

When do we use "no women" instead of "no woman"?

Tasha's Hideous Laughter used on a deaf person?

Should we run PBKDF2 for every plaintext to be protected or should we run PBKDF2 only once?

The Justice Thought & System & its Morals?

How to run a command 1 out of N times in Bash

Function of the separated, individual solar cells on Telstar 1 and 2? Why were they "special"?

If the government illegally doesn't ask for article 50 extension, can parliament do it instead?

How can I modify a line which contains 2nd occurence of a string?

Can authors email you PDFs of their textbook for free?

Different past tense for various *et words

Polarity of gas discharge tubes?

Cheap oscilloscope showing 16 MHz square wave

How do I get my neighbour to stop disturbing with loud music?

How do you manage to study and have a balance in your life at the same time?

Is there anything in the universe that cannot be compressed?

Can a system of three stars exist?

What happens if you just start drawing from the Deck of Many Things without declaring any number of cards?

What is causing gaps in logs?

Why are CEOs generally fired rather being demoted?

What are ways to record who took the pictures if a camera is used by multiple people?

how to map json in orm.xml in jpa

What is the “N+1 selects problem” in ORM (Object-Relational Mapping)?JPA EntityManager: Why use persist() over merge()?Infinite Recursion with Jackson JSON and Hibernate JPA issueJPA, MySQL, Hibernate & Maven SkeletonJPA Secondary Table XML ConfigWhat's the difference between JPA and Hibernate?What's the difference between @JoinColumn and mappedBy when using a JPA @OneToMany associationWhat is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?Could not determine type for entityValidationException Exception Description: uses a non-entity as target entity in the relationship attribute

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have create DTO/Entities from openApi gen and I have orm.xml to map Java Entity to JPA. Problem is I want one of field object(named obj see code below) in java class to be mapped to JSON/JSONB JDBC data type. I am not sure how to do it.

class Test
 private String id;
 //its not a JsonObject
 private Object obj;
 // usual boiler plate i.e. Default constructors and getters/setters

orm.xml ->

<?xml version="1.0" encoding="UTF-8" ?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_2_0.xsd"
 version="2.0">



 <entity class="com.Test" access="FIELD">
 <table name="Test"/>

 <attributes>
 <json name="obj"/>

 </attributes>
 </entity>

</entity-mappings>

But its saved as "byteArray" psql data type instead of json type on database. Please help me understand how can I create a mapping that creates a "json" column instead of "byteArray" psql data type

jpa jdbc orm spring-data-jpa jpa-2.1

share|improve this question

asked Mar 28 at 1:06

user3879753user3879753

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Vlad Mihalcea can you help in solving my issue
  
  – user3879753
  Mar 29 at 4:02
  

  
  
  
  

add a comment | 

0

I have create DTO/Entities from openApi gen and I have orm.xml to map Java Entity to JPA. Problem is I want one of field object(named obj see code below) in java class to be mapped to JSON/JSONB JDBC data type. I am not sure how to do it.

class Test
 private String id;
 //its not a JsonObject
 private Object obj;
 // usual boiler plate i.e. Default constructors and getters/setters

orm.xml ->

<?xml version="1.0" encoding="UTF-8" ?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_2_0.xsd"
 version="2.0">



 <entity class="com.Test" access="FIELD">
 <table name="Test"/>

 <attributes>
 <json name="obj"/>

 </attributes>
 </entity>

</entity-mappings>

But its saved as "byteArray" psql data type instead of json type on database. Please help me understand how can I create a mapping that creates a "json" column instead of "byteArray" psql data type

jpa jdbc orm spring-data-jpa jpa-2.1

share|improve this question

asked Mar 28 at 1:06

user3879753user3879753

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Vlad Mihalcea can you help in solving my issue
  
  – user3879753
  Mar 29 at 4:02
  

  
  
  
  

add a comment | 

I have create DTO/Entities from openApi gen and I have orm.xml to map Java Entity to JPA. Problem is I want one of field object(named obj see code below) in java class to be mapped to JSON/JSONB JDBC data type. I am not sure how to do it.

class Test
 private String id;
 //its not a JsonObject
 private Object obj;
 // usual boiler plate i.e. Default constructors and getters/setters

orm.xml ->

<?xml version="1.0" encoding="UTF-8" ?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_2_0.xsd"
 version="2.0">



 <entity class="com.Test" access="FIELD">
 <table name="Test"/>

 <attributes>
 <json name="obj"/>

 </attributes>
 </entity>

</entity-mappings>

But its saved as "byteArray" psql data type instead of json type on database. Please help me understand how can I create a mapping that creates a "json" column instead of "byteArray" psql data type

jpa jdbc orm spring-data-jpa jpa-2.1

share|improve this question

asked Mar 28 at 1:06

user3879753user3879753

1

class Test
 private String id;
 //its not a JsonObject
 private Object obj;
 // usual boiler plate i.e. Default constructors and getters/setters

<?xml version="1.0" encoding="UTF-8" ?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_2_0.xsd"
 version="2.0">



 <entity class="com.Test" access="FIELD">
 <table name="Test"/>

 <attributes>
 <json name="obj"/>

 </attributes>
 </entity>

</entity-mappings>

share|improve this question

asked Mar 28 at 1:06

user3879753user3879753

1

share|improve this question

asked Mar 28 at 1:06

user3879753user3879753

1

asked Mar 28 at 1:06

user3879753user3879753

1

asked Mar 28 at 1:06

user3879753user3879753

1