Hi
I have a problem for which I seem to find no answer. In our project we have single-table inheritance with a discriminator column.

@Entity
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "CATEGORY")
public abstract class A {
...
}

@Entity
public class B extends A {
...
}

@Entity
public class C extends A {
...
}

The problem is that we sometimes need to change objects of type B to objects of type C. Could you suggest how I should do it?
I'd rather not delete and insert a new object because there are other entities referencing the old object.
What would happen if I flushed the entity manager and then used native sql to change the discriminator column? Would it work? Is there another way perhaps?

Thanks in advance and have a good day!