Hibernate: mapping column substring to a field

Question

I want to know if it is possible to map a table column "substring" to a field, here is a sample. Initially --> column named 'description' contains this string '123456789' After mapping --> java class field named 'descSummary' contains '123'.

Thanks in advance.

Grim · Accepted Answer · 2014-10-21 14:01:36Z

1

Yes using a Column Transformer.

answered Oct 21, 2014 at 14:01

Grim

2,16312 gold badges63 silver badges139 bronze badges

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

1 Comment

neo Over a year ago

thank you for your answear, it is clean ... didn't get it out when browsing hibernate reference doc.

MystyxMac · Accepted Answer · 2014-10-21 13:41:35Z

One way is to use a Hibernate custom UserType.

A rough example (some methods from the interface are left out for readability):

package org.example;

public class SubstringUserType implements UserType {
    @Override
    public Class<String> returnedClass() {
        return String.class;
    }

    @Override
    public Object nullSafeGet(final ResultSet rs, final String[] names, final SessionImplementor    session, final Object owner) throws HibernateException, SQLException {
        if (rs != null || names.length != 0 || null != names[0]) {
            String desc = rs.getString(names[0]);
            return desc.substring(0, 3);
        }
    }
}

and use the following annotation on the field.

@Type(type = "org.example.SubstringUserType")

Collectives™ on Stack Overflow

Hibernate: mapping column substring to a field

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related