Another attempt to solve this problem.
I created a very simple project using Spring 4.2.5 and Hibernate 5.2.2 and added 4 entities similar to the previous example.
To simplify the example, DAO layer is absent. Loading collection as previously generates an incorrect query without a left outer join.
It may be an error in the configuration file of Spring or Hibernate?
Spring context
Code:
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
">
<context:annotation-config />
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@ndbs.vrn.ru:1521:ICDBS" />
<property name="username" value="devman" />
<property name="password" value="ecnh0qcndf" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:hibernate.cfg.xml" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" />
<bean id="transactionManager"
class="org.springframework.orm.hibernate5.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
</beans>
Hibernate configuration file
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="dialect">org.hibernate.dialect.Oracle9iDialect</property>
<property name="show_sql">true</property>
<property name="connection.pool_size">25</property>
<property name="connection.autocommit">true</property>
<mapping class="TestClass"/>
<mapping class="TestParent"/>
<mapping class="TestChild1"/>
</session-factory>
</hibernate-configuration>
Entities:
Code:
import java.util.Date;
import javax.persistence.Column;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.MappedSuperclass;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
@MappedSuperclass
public class DBObject {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq")
protected Integer id;
@Column(name = "correctdt")
@Temporal(TemporalType.TIMESTAMP)
protected Date correctDate;
@Override
public boolean equals(Object o) {
boolean result = false;
if (o != null && (o instanceof DBObject)) {
DBObject oo = (DBObject) o;
if (id != null) {
result = id.equals(oo.id);
}
}
return result;
}
@Override
public int hashCode() {
return (id != null) ? id.hashCode() : 0;
}
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
}
public Date getCorrectDate() {
return this.correctDate;
}
public void setCorrectDate(java.util.Date correctDate) {
this.correctDate = correctDate;
}
}
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import javax.persistence.Entity;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.OneToMany;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
@Entity
@Inheritance(strategy = InheritanceType.JOINED)
@Table(name = "tmp_test_class")
@SequenceGenerator(name = "seq",
sequenceName = "sq_test_class_id",
allocationSize = 1)
public class TestClass extends DBObject implements Serializable{
private static final long serialVersionUID = -8753086349251775837L;
@OneToMany(mappedBy = "testClass")
protected Collection<TestParent> tests = new ArrayList<>();
public Collection<TestParent> getTests() {
return tests;
}
public void setTests(Collection<TestParent> tests) {
this.tests = tests;
}
}
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
@Entity
@Inheritance(strategy = InheritanceType.JOINED)
@Table(name = "tmp_test_parent")
@SequenceGenerator(name = "seq",
sequenceName = "sq_test_entry_id",
allocationSize = 1)
public class TestParent extends DBObject implements Serializable{
private static final long serialVersionUID = -8753086349251775837L;
@Column
private String name;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "test_id")
protected TestClass testClass;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public TestClass getTestClass() {
return testClass;
}
public void setTestClass(TestClass testClass) {
this.testClass = testClass;
}
}
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
@Entity
@Table(name = "tmp_test_child1")
public class TestChild1 extends TestParent{
private static final long serialVersionUID = -2363194053234011840L;
@Column
private String field1;
public String getField1() {
return field1;
}
public void setField1(String field1) {
this.field1 = field1;
}
}
import java.util.Collection;
import org.hibernate.SessionFactory;
import org.springframework.context.support.GenericXmlApplicationContext;
Class, where I test collection loading:
Code:
public class MainClass {
public static void main(String[] args) throws Exception {
GenericXmlApplicationContext ctx = new GenericXmlApplicationContext();
ctx.load("classpath:applicationContext.xml");
ctx.refresh();
SessionFactory sessionFactory = (SessionFactory)ctx.getBean("sessionFactory");
TestClass test = sessionFactory.openSession().get(TestClass.class, 10098);
Collection<TestParent> tests = test.getTests();
System.out.println(tests.size());
}
}
SQL-queries:
Code:
SELECT testclass0_.id AS id1_1_0_,
testclass0_.correctdt AS correctdt2_1_0_
FROM tmp_test_class testclass0_
WHERE testclass0_.id=?
SELECT tests0_.test_id AS test_id4_2_0_,
tests0_.id AS id1_2_0_,
tests0_.id AS id1_2_1_,
tests0_.correctdt AS correctdt2_2_1_,
tests0_.name AS name3_2_1_,
tests0_.test_id AS test_id4_2_1_,
tests0_1_.field1 AS field1_0_1_,
CASE
WHEN tests0_1_.id IS NOT NULL
THEN 1
WHEN tests0_.id IS NOT NULL
THEN 0
END AS clazz_1_
FROM tmp_test_parent tests0_,
tmp_test_child1 tests0_1_
WHERE tests0_.test_id=?
Login
FAQ
Search
