"Incompatible data types in combination" resulting in "Failed to initialize collection" in JPA with inherited bidirectional relation

Question

"Incompatible data types in combination" resulting in "Failed to initialize collection" in JPA with inherited bidirectional relation

I am trying to implement the following diagram in Hibernate, JPA.

enter image description here

I tried to implement it that way.

For the farm

@Entity
public class Farm implements Serializable{

    @OneToMany(mappedBy = "farm", cascade = { CascadeType.ALL }, targetEntity=AbstractAnimals.class, fetch=FetchType.LAZY)
    private List<AbstractAnimal> animals = new ArrayList<AbstractAnimals>();

}

For abstract annimal

@Entity
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
public abstract class AbstractAnimal implements Serializable{
    @Id
    private int id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "farmId", nullable = false)
    private Farm farm;

    ... other attributes and getter and setter
}

For an abstract mammal

@MappedSuperClass
public abstract class AbstractMammalian extends AbstractAnimal implements Serializable{
    ... other attributes and getter and setter
}

For all annotals

@Entity
public abstract class 'Animal' extends 'supertype' implements Serializable{

    ... other attributes and getter and setter
}

When I tried to get all the farm animals, I get the following error:

org.hibernate.exception.SQLGrammarException: could not initialize a collection: [my.example.Farm.animals#24]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.loader.Loader.loadCollection(Loader.java:2173)
    at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:62)
    at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:627)
    at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
    at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1863)
    at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:369)
    at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:111)
    at org.hibernate.collection.PersistentBag.iterator(PersistentBag.java:272)
    at my.example.persistence.Farm.getAnnimals(Farm.java:132)
    at my.example.DTOFactory.updateFarmDTO(DTOFactory.java:269)
    at my.example.DTOFactory.createFarmDTO(DTOFactory.java:250)
    at my.example.DTOFactory.createChickenDTO(DTOFactory.java:183)
    at my.example.ChickenServiceImpl.createChicken(ChickenServiceImpl.java:62)
    at my.example.ChickenServiceTest.createChickenWithHome(ChickenServiceTest.java:243)
    at my.example.ChickenServiceTest.testRejectChickenHome(ChickenServiceTest.java:186)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
    at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: java.sql.SQLSyntaxErrorException: incompatible data types in combination
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
    at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
    at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
    at org.hibernate.loader.Loader.doQuery(Loader.java:801)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    at org.hibernate.loader.Loader.loadCollection(Loader.java:2166)
    ... 40 more
Caused by: org.hsqldb.HsqlException: incompatible data types in combination
    at org.hsqldb.error.Error.error(Unknown Source)
    at org.hsqldb.error.Error.error(Unknown Source)
    at org.hsqldb.types.BitType.getAggregateType(Unknown Source)
    at org.hsqldb.types.Type.getAggregateType(Unknown Source)
    at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source)
    at org.hsqldb.QueryExpression.resolveTypesPartOne(Unknown Source)
    at org.hsqldb.QueryExpression.resolveTypes(Unknown Source)
    at org.hsqldb.ParserDQL.XreadTableSubqueryOrNull(Unknown Source)
    at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
    at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
    at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
    at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
    at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
    at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
    at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
    at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
    at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
    at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
    at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
    at org.hsqldb.ParserCommand.compilePart(Unknown Source)
    at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    at org.hsqldb.Session.compileStatement(Unknown Source)
    at org.hsqldb.StatementManager.compile(Unknown Source)
    at org.hsqldb.Session.execute(Unknown Source)
    ... 49 more

Edit

EntityManager manager = null;
EntityTransaction tx = null;
TaskDTO result = null;

try {
    manager = PersistenceUtils.getEntityManager();
    try
    {
       tx = manager.getTransaction();
       tx.begin();
       Farm farm = manager.find(Farm.class, 
       Farmer farmer = manager.find(farmer.class, farmerDtoID);
       int status = AnimalService.IDLE;

       if (birth.before(new Date())){
           status = TaskService.UNBORN;
       }
       Chicken newChicken = new Chicken(name, farm, user, birth, death, status);
       manager.persist(newChicken);
       tx.commit();
       result = DTOFactory.createChickenDTO(newChicken, true);
   }
   finally
   {
       if (tx.isActive())
       {
           tx.rollback();
       }
   }
}
finally
{
    if (manager != null)
    {
        manager.close();
    }
 }
 return result;

+5

java inheritance hibernate jpa

Baptiste gousset Jul 30 '12 at 11:15

source share

4 answers

: .

. - :

@Entity
public class Farm implements Serializable{

    @OneToMany(mappedBy = "farm", cascade = { CascadeType.ALL }, targetEntity=AbstractAnimals.class, fetch=FetchType.LAZY)
    private List<AbstractAnimal> animals;

}

0

Dmytro Chyzhykov 30 . '12 12:00

.
:

1. EAGER AbstractAnimal.

@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "farmId", nullable = false)
private Farm farm;

2. . @XmlTransient

0

Matin Kh 01 . '12 12:07

Good thanks to Tom Anderson. I managed to solve my problem. The solution was to use Hibernate 4.1 instead of 3.6 and change the methods in resistance helpers from 'Session'.connection() to

'Session'.doWork(new Work() {
    @Override
    public void execute(Connection c) throws SQLException {

    }
}

0

Baptiste gousset Aug 08 '12 at 10:28

source share

Tom Anderson · Accepted Answer · 2012-08-06T23:20:21+0000

I have no idea what you are doing wrong. You just did not show us enough code to detect the problem.

Here's how you can do it right:

https://bitbucket.org/twic/farm/src

, . Gradle script, SQL; , Farm.getAnimals().

. ; , , , , .. AbstractMammal @Entity, @MappedSuperclass. . , .

, , . JPA. , . , , , , .

"Incompatible data types in combination" resulting in "Failed to initialize collection" in JPA with inherited bidirectional relation

More articles: