CODEWITHSUNDEEP
javavalidationjooq
parthivrshah
parthivrshah

Reputation: 674

Inner property is not automatically cast in JOOQ

I have table as below:

    CREATE TABLE recipes
(
  id INT AUTO_INCREMENT,
  name VARCHAR(100) NOT NULL,
  components JSON,
  active BOOLEAN NULL DEFAULT TRUE,

  PRIMARY KEY (id),
  UNIQUE KEY (name)
)
  CHARACTER SET "UTF8"
  ENGINE = InnoDb;

I have created pojo class like below:

@JsonIgnoreProperties(ignoreUnknown = true)
public class CValueRecipeV2
{
    @JsonProperty("components")
    @JsonAlias("matcher.components")
    @Column(name = "components")
    @Valid
    private List<CComponentV2> mComponents;

    @JsonProperty("name")
    @Column(name = "name")
    private String name;

    public List<CComponentV2> getComponents()
    {
        return mComponents;
    }

    public void setComponents(List<CComponentV2> mComponents)
    {
        this.mComponents = mComponents;
    }
    public String getName()
    {
        return mName;
    }

    public void setName(String mName)
    {
        this.mName = mName;
    }

}

another class 

@JsonIgnoreProperties(ignoreUnknown = true)
public class CComponentV2
{
    @JsonProperty("shingle_size")
    @JsonAlias("shingleSize")
    @CShingleField
    private Integer mShingleSize;

    public Integer getmShingleSize()
    {
        return mShingleSize;
    }

    public void setmShingleSize(Integer mShingleSize)
    {
        this.mShingleSize = mShingleSize;
    }
}

Now I am trying to fetch the record from the database using JOOQ. But I am not able to convert json component string into component class.

I am reading the data from the table as mentioned below:

context.dsl().select(RECIPES.asterisk())
                        .from(RECIPES)
                        .where(RECIPES.NAME.eq(name))
                        .fetchInto(CValueRecipeV2.class);

In the database, I have the following record.

ID name components           active
1  a    [{"shingle_size=2"}] true

While fetching the data, I am receiving the following error

Caused by: org.jooq.exception.DataTypeException: Cannot convert from {shingle_size=2} (class java.util.HashMap) to class com.ac.config_objects.CComponentV2

I am new to JOOQ. Please let me know if I missing anything. Thanks in advance.

Upvotes: 0

Views: 407

Answers (2)

parthivrshah
parthivrshah

Reputation: 674

I have solved my problem using the jooq converter.

var record = context.dsl().select(RECIPES.asterisk())
                        .from(RECIPES)
                        .where(RECIPES.NAME.eq(name))
                        .fetchOne();

                record.setValue(RECIPES.COMPONENTS, record.get(RECIPES.COMPONENTS, new CComponentV2Converter()));
                var recipe = record.into(CValueRecipeV2.class);

and my converter lools like below:

public class CComponentV2Converter implements Converter<Object, List<CComponentV2>>
{
    static final long serialVersionUID = 0;

    @Override
    public List<CComponentV2> from(Object databaseObject)
    {
        var componentList = CObjectCaster.toMapList(databaseObject);
        List<CComponentV2> cComponentV2s = new ArrayList<>();
        componentList.forEach(e -> {
            CComponentV2 cComponentV2 = new CComponentV2();
            cComponentV2.setmShingleSize(CObjectCaster.toInteger(e.get("shingle_size")));
            cComponentV2s.add(cComponentV2);
        });
        return cComponentV2s;
    }
}

Upvotes: 1

Lukas Eder
Lukas Eder

Reputation: 221145

jOOQ doesn't understand your @JsonProperty and other annotations out of the box. You will have to implement your own record mapper to support them: https://www.jooq.org/doc/latest/manual/sql-execution/fetching/pojos-with-recordmapper-provider/

Upvotes: 0

Related Questions