Hibernate Version
3.5.0 Final
DB
Oracle 10g
The classes D/E are linked with the association table DE on non-primary key columns. When querying for D objects and calling the getter for a DE object, I receive the object, but it's association to D and E are null. I think, I've pinpointed the problem in the log file:
Code:
[11:55:18,563,Loader] loading entity: [E#component[deFormula]{deFormula=DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}}]
Here hibenrate tries to load an E entity based on its DE property, which does not work, because the entities are joined on the property objId, objIdD{Source/Target} and not on the primary keys.
Following the three annotated classes and superclass Versioned of D/E, and an excerpt from the log file.
Entity D
Code:
public class D extends Versioned {
private DE deFormula;
private String value;
@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(nullable=false, insertable = false, updatable = false, name= "OBJID", referencedColumnName = "objIdDTarget", unique=false)
@ForeignKey(name="none")
public DE getDeFormula() {
return this.deFormula;
}
public void setDeFormula(DE deFormula) {
this.deFormula = deFormula;
}
public String getValue() {
return value;
}
public void setValue(String value) {
this.value = value;
}
}
Entity DE
Code:
@Entity
public class DE implements Versionable, Serializable {
private String id;
private String objIdDTarget;
private String objIdETarget;
private String objIdDSource;
private String objIdESource;
private Date valid_from;
private Date valid_until;
private String author_from;
private String author_until;
private String branch_ID;
private D d;
private E e;
@Id
@GeneratedValue(generator = "PgGUID")
@GenericGenerator(name = "PgGUID", strategy = "de.iac_leipzig.polygis.core.util.GUIDGenerator")
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public Date getValid_from() {
return valid_from;
}
public String getObjIdDTarget() {
return objIdDTarget;
}
public void setObjIdDTarget(String objIdDTarget) {
this.objIdDTarget = objIdDTarget;
}
public String getObjIdETarget() {
return objIdETarget;
}
public void setObjIdETarget(String objIdETarget) {
this.objIdETarget = objIdETarget;
}
public String getObjIdDSource() {
return objIdDSource;
}
public void setObjIdDSource(String objIdDSource) {
this.objIdDSource = objIdDSource;
}
public String getObjIdESource() {
return objIdESource;
}
public void setObjIdESource(String objIdESource) {
this.objIdESource = objIdESource;
}
public void setValid_from(Date valid_from) {
this.valid_from = valid_from;
}
public Date getValid_until() {
return valid_until;
}
public void setValid_until(Date valid_until) {
this.valid_until = valid_until;
}
public String getAuthor_from() {
return author_from;
}
public void setAuthor_from(String author_from) {
this.author_from = author_from;
}
public String getAuthor_until() {
return author_until;
}
public void setAuthor_until(String author_until) {
this.author_until = author_until;
}
@Override
public String getBranch_ID() {
return branch_ID;
}
@Override
public void setBranch_ID(String branch_ID) {
this.branch_ID = branch_ID;
}
@ManyToOne(fetch=FetchType.EAGER)
@JoinColumn(unique=false, nullable = false, insertable = false, updatable = false, name = "OBJIDDSOURCE", referencedColumnName = "OBJID")
@ForeignKey(name="none")
public D getD() {
return this.d;
}
public void setD(D d) {
this.d = d;
}
@ManyToOne(fetch=FetchType.EAGER)
@JoinColumn(unique=false, nullable = false, insertable = false, updatable = false, name = "OBJIDESOURCE", referencedColumnName = "OBJID")
@ForeignKey(name="none")
public E getE() {
return this.e;
}
public void setE(E e) {
this.e = e;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((id == null) ? 0 : id.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (!(obj instanceof DE))
return false;
DE other = (DE) obj;
if (id == null) {
if (other.id != null)
return false;
} else if (!id.equals(other.id))
return false;
return true;
}
}
Entity E
Code:
public class E extends Versioned{
private DE deFormula;
private String value;
@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(nullable=false,insertable = false, updatable = false, name= "OBJID", referencedColumnName = "objIdETarget", unique=false)
@ForeignKey(name="none")
public DE getDeFormula() {
return this.deFormula;
}
public void setDeFormula(DE deFormula) {
this.deFormula = deFormula;
}
public String getValue() {
return value;
}
public void setValue(String value) {
this.value = value;
}
}
MappedSuperclass Versioned
Code:
@MappedSuperclass
public abstract class Versioned implements Serializable, Versionable {
private static long rpiIdCounter = System.currentTimeMillis();
public static final String PROP_ID = "id";
private String id;
public static final String PROP_OBJID = "objId";
private String objId;
public static final String PROP_BRANCH_ID = "branch_id";
private String branch_ID;
public static final String PROP_VALID_FROM = "valid_from";
private Date valid_from;
public static final String PROP_VALID_UNTIL = "valid_until";
private Date valid_until;
public static final String PROP_AUTHOR_FROM = "author_from";
private String author_from;
public static final String PROP_AUTHOR_UNTIL = "author_until";
private String author_until;
@Id
@GeneratedValue(generator = "PgGUID")
@GenericGenerator(name = "PgGUID", strategy = "de.iac_leipzig.polygis.core.util.GUIDGenerator")
@Type( type="de.iac_leipzig.polygis.data.core.GUIDType" )
public String getId() {
return id;
}
public void setId( String id ) {
this.id = id;
}
@Column(name = "OBJID",unique=false)
public String getObjId() {
return objId;
}
public void setObjId( String obj_id ) {
this.objId = obj_id;
}
@Override
@Column(name = "BRANCHID")
public String getBranch_ID() {
return branch_ID;
}
public void setBranch_ID( String branch_ID ) {
this.branch_ID = branch_ID;
}
@Override
@Column(name = "VALIDFROM")
public Date getValid_from() {
return valid_from;
}
public void setValid_from( Date valid_from ) {
this.valid_from = valid_from;
}
@Override
@Column(name = "VALIDUNTIL")
public Date getValid_until() {
return valid_until;
}
@Override
public void setValid_until( Date valid_until ) {
this.valid_until = valid_until;
}
@Override
@Column(name = "AUTHORFROM")
public String getAuthor_from() {
return author_from;
}
@Override
public void setAuthor_from( String author_from ) {
this.author_from = author_from;
}
@Override
@Column(name = "AUTHORUNTIL")
public String getAuthor_until() {
return author_until;
}
@Override
public void setAuthor_until( String author_until ) {
this.author_until = author_until;
}
@Override
public int hashCode() {
return (getId() != null ? getId().hashCode() : 0);
}
@Override
public boolean equals( Object o ) {
if (this == o)
return true;
if (o == null || getClass() != o.getClass())
return false;
Versioned that = (Versioned)o;
return this.getId().equals( that.getId() );
}
}
Excerpt from log file:
Code:
[11:55:18,422,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[11:55:18,422,SQL]
/* criteria query */ select
this_.id as id3_0_,
this_.AUTHORFROM as AUTHORFROM3_0_,
this_.AUTHORUNTIL as AUTHORUN3_3_0_,
this_.BRANCHID as BRANCHID3_0_,
this_.OBJID as OBJID3_0_,
this_.rpiid as rpiid3_0_,
this_.VALIDFROM as VALIDFROM3_0_,
this_.VALIDUNTIL as VALIDUNTIL3_0_,
this_.value as value3_0_
from
D this_
where
(
this_.VALIDUNTIL is null
)
[11:55:18,422,AbstractBatcher] preparing statement
[11:55:18,500,Loader] Bound [1] parameters total
[11:55:18,532,AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[11:55:18,532,Loader] processing result set
[11:55:18,532,Loader] result set row: 0
[11:55:18,532,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,532,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}]
[11:55:18,532,Loader] Initializing object from ResultSet: [D#{D2945CCA-D6F1-422E-996E-79DF8E349785}]
[11:55:18,532,AbstractEntityPersister] Hydrating entity: [D#{D2945CCA-D6F1-422E-996E-79DF8E349785}]
[11:55:18,532,StringType] returning 'tim' as column: AUTHORFROM3_0_
[11:55:18,532,StringType] returning null as column: AUTHORUN3_3_0_
[11:55:18,532,StringType] returning '0' as column: BRANCHID3_0_
[11:55:18,532,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: OBJID3_0_
[11:55:18,532,RPIIdType] returning '0' as column: rpiid3_0_
[11:55:18,532,TimestampType] returning '2010-04-06 11:51:33' as column: VALIDFROM3_0_
[11:55:18,532,TimestampType] returning null as column: VALIDUNTIL3_0_
[11:55:18,532,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: OBJID3_0_
[11:55:18,532,StringType] returning 'testNewVersionD' as column: value3_0_
[11:55:18,532,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: OBJID3_0_
[11:55:18,532,Loader] done processing result set (1 rows)
[11:55:18,532,AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,532,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,532,AbstractBatcher] closing statement
[11:55:18,532,Loader] total objects hydrated: 1
[11:55:18,532,TwoPhaseLoad] resolving associations for [D#{D2945CCA-D6F1-422E-996E-79DF8E349785}]
[11:55:18,532,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objiddtarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,532,Loader] loading entity: [DE#component[objIdDTarget]{objIdDTarget={D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}}]
[11:55:18,532,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[11:55:18,547,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objiddtarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,547,AbstractBatcher] preparing statement
[11:55:18,547,StringType] binding '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' to parameter: 1
[11:55:18,547,Loader] Bound [2] parameters total
[11:55:18,547,AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[11:55:18,547,Loader] processing result set
[11:55:18,547,Loader] result set row: 0
[11:55:18,547,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,547,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,547,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,547,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,547,Loader] Initializing object from ResultSet: [E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}]
[11:55:18,547,AbstractEntityPersister] Hydrating entity: [E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}]
[11:55:18,547,StringType] returning 'tim' as column: AUTHORFROM4_1_
[11:55:18,547,StringType] returning null as column: AUTHORUN3_4_1_
[11:55:18,547,StringType] returning '0' as column: BRANCHID4_1_
[11:55:18,547,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: OBJID4_1_
[11:55:18,547,RPIIdType] returning '0' as column: rpiid4_1_
[11:55:18,547,TimestampType] returning '2010-04-06 11:51:31' as column: VALIDFROM4_1_
[11:55:18,547,TimestampType] returning null as column: VALIDUNTIL4_1_
[11:55:18,547,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: OBJID4_1_
[11:55:18,547,StringType] returning 'testNewVersionE' as column: value4_1_
[11:55:18,547,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: OBJID4_1_
[11:55:18,547,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objidetarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,547,Loader] loading entity: [DE#component[objIdETarget]{objIdETarget={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}}]
[11:55:18,547,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,547,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objidetarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,547,AbstractBatcher] preparing statement
[11:55:18,547,StringType] binding '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' to parameter: 1
[11:55:18,547,Loader] Bound [2] parameters total
[11:55:18,547,AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,547,Loader] processing result set
[11:55:18,547,Loader] result set row: 0
[11:55:18,547,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,547,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,547,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,547,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,547,Loader] Initializing object from ResultSet: [DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,547,AbstractEntityPersister] Hydrating entity: [DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,547,StringType] returning 'tim' as column: author2_12_2_
[11:55:18,547,StringType] returning null as column: author3_12_2_
[11:55:18,547,StringType] returning '0' as column: branch4_12_2_
[11:55:18,547,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: OBJIDDSO5_12_2_
[11:55:18,547,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objiddtarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,547,Loader] loading entity: [DE#component[objIdDTarget]{objIdDTarget={D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}}]
[11:55:18,547,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 2, globally: 2)
[11:55:18,547,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objiddtarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,547,AbstractBatcher] preparing statement
[11:55:18,547,StringType] binding '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' to parameter: 1
[11:55:18,547,Loader] Bound [2] parameters total
[11:55:18,563,AbstractBatcher] about to open ResultSet (open ResultSets: 2, globally: 2)
[11:55:18,563,Loader] processing result set
[11:55:18,563,Loader] result set row: 0
[11:55:18,563,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,563,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,563,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,563,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,563,Loader] done processing result set (1 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 3, globally: 3)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 3, globally: 3)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 0
[11:55:18,563,Loader] done entity load
[11:55:18,563,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: OBJIDESO7_12_2_
[11:55:18,563,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objidetarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,563,Loader] loading entity: [DE#component[objIdETarget]{objIdETarget={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}}]
[11:55:18,563,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 2, globally: 2)
[11:55:18,563,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objidetarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,563,AbstractBatcher] preparing statement
[11:55:18,563,StringType] binding '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' to parameter: 1
[11:55:18,563,Loader] Bound [2] parameters total
[11:55:18,563,AbstractBatcher] about to open ResultSet (open ResultSets: 2, globally: 2)
[11:55:18,563,Loader] processing result set
[11:55:18,563,Loader] result set row: 0
[11:55:18,563,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,563,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,563,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,563,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,563,Loader] done processing result set (1 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 3, globally: 3)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 3, globally: 3)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 0
[11:55:18,563,Loader] done entity load
[11:55:18,563,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: objiddso5_12_2_
[11:55:18,563,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: objiddta6_12_2_
[11:55:18,563,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: objideso7_12_2_
[11:55:18,563,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: objideta8_12_2_
[11:55:18,563,TimestampType] returning '2010-04-06 11:51:31' as column: valid9_12_2_
[11:55:18,563,TimestampType] returning null as column: valid10_12_2_
[11:55:18,563,StringType] returning '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' as column: objiddta6_12_2_
[11:55:18,563,StringType] returning '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' as column: objideta8_12_2_
[11:55:18,563,Loader] done processing result set (1 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 1
[11:55:18,563,TwoPhaseLoad] resolving associations for [DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,563,EntityLoader] Static select for entity D [NONE]: /* load D */ select d0_.id as id3_0_, d0_.AUTHORFROM as AUTHORFROM3_0_, d0_.AUTHORUNTIL as AUTHORUN3_3_0_, d0_.BRANCHID as BRANCHID3_0_, d0_.OBJID as OBJID3_0_, d0_.rpiid as rpiid3_0_, d0_.VALIDFROM as VALIDFROM3_0_, d0_.VALIDUNTIL as VALIDUNTIL3_0_, d0_.value as value3_0_ from D d0_ where d0_.OBJID=? and (d0_.VALIDUNTIL is null)
[11:55:18,563,Loader] loading entity: [D#component[deFormula]{deFormula=DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}}]
[11:55:18,563,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,563,SQL]
/* load D */ select
d0_.id as id3_0_,
d0_.AUTHORFROM as AUTHORFROM3_0_,
d0_.AUTHORUNTIL as AUTHORUN3_3_0_,
d0_.BRANCHID as BRANCHID3_0_,
d0_.OBJID as OBJID3_0_,
d0_.rpiid as rpiid3_0_,
d0_.VALIDFROM as VALIDFROM3_0_,
d0_.VALIDUNTIL as VALIDUNTIL3_0_,
d0_.value as value3_0_
from
D d0_
where
d0_.OBJID=?
and (
d0_.VALIDUNTIL is null
)
[11:55:18,563,AbstractBatcher] preparing statement
[11:55:18,563,StringType] binding null to parameter: 1
[11:55:18,563,Loader] Bound [2] parameters total
[11:55:18,563,AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,563,Loader] processing result set
[11:55:18,563,Loader] done processing result set (0 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 0
[11:55:18,563,Loader] done entity load
[11:55:18,563,EntityLoader] Static select for entity E [NONE]: /* load E */ select e0_.id as id4_0_, e0_.AUTHORFROM as AUTHORFROM4_0_, e0_.AUTHORUNTIL as AUTHORUN3_4_0_, e0_.BRANCHID as BRANCHID4_0_, e0_.OBJID as OBJID4_0_, e0_.rpiid as rpiid4_0_, e0_.VALIDFROM as VALIDFROM4_0_, e0_.VALIDUNTIL as VALIDUNTIL4_0_, e0_.value as value4_0_ from E e0_ where e0_.OBJID=? and (e0_.VALIDUNTIL is null)
[11:55:18,563,Loader] loading entity: [E#component[deFormula]{deFormula=DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}}]
[11:55:18,563,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,563,SQL]
/* load E */ select
e0_.id as id4_0_,
e0_.AUTHORFROM as AUTHORFROM4_0_,
e0_.AUTHORUNTIL as AUTHORUN3_4_0_,
e0_.BRANCHID as BRANCHID4_0_,
e0_.OBJID as OBJID4_0_,
e0_.rpiid as rpiid4_0_,
e0_.VALIDFROM as VALIDFROM4_0_,
e0_.VALIDUNTIL as VALIDUNTIL4_0_,
e0_.value as value4_0_
from
E e0_
where
e0_.OBJID=?
and (
e0_.VALIDUNTIL is null
)
[11:55:18,563,AbstractBatcher] preparing statement
[11:55:18,563,StringType] binding null to parameter: 1
[11:55:18,563,Loader] Bound [2] parameters total
[11:55:18,563,AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,563,Loader] processing result set
[11:55:18,563,Loader] done processing result set (0 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 0
[11:55:18,563,Loader] done entity load
[11:55:18,563,TwoPhaseLoad] done materializing entity [DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,563,Loader] done entity load
[11:55:18,563,Loader] done processing result set (1 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 1
[11:55:18,563,TwoPhaseLoad] resolving associations for [E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}]
[11:55:18,563,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objidetarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,563,Loader] loading entity: [DE#component[objIdETarget]{objIdETarget={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}}]
[11:55:18,563,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[11:55:18,563,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objidetarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,563,AbstractBatcher] preparing statement
[11:55:18,563,StringType] binding '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' to parameter: 1
[11:55:18,563,Loader] Bound [2] parameters total
[11:55:18,563,AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[11:55:18,563,Loader] processing result set
[11:55:18,563,Loader] result set row: 0
[11:55:18,563,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,563,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,563,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,563,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,563,Loader] done processing result set (1 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 0
[11:55:18,563,Loader] done entity load
[11:55:18,563,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objidetarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,563,Loader] loading entity: [DE#component[objIdETarget]{objIdETarget={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}}]
[11:55:18,563,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[11:55:18,563,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objidetarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,563,AbstractBatcher] preparing statement
[11:55:18,563,StringType] binding '{C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}' to parameter: 1
[11:55:18,563,Loader] Bound [2] parameters total
[11:55:18,563,AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[11:55:18,563,Loader] processing result set
[11:55:18,563,Loader] result set row: 0
[11:55:18,563,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,563,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,563,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,563,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,563,Loader] done processing result set (1 rows)
[11:55:18,563,AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,563,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,563,AbstractBatcher] closing statement
[11:55:18,563,Loader] total objects hydrated: 0
[11:55:18,563,Loader] done entity load
[11:55:18,563,TwoPhaseLoad] done materializing entity [E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}]
[11:55:18,563,Loader] done entity load
[11:55:18,563,EntityLoader] Static select for entity DE [NONE]: /* load DE */ select de0_.id as id12_2_, de0_.author_from as author2_12_2_, de0_.author_until as author3_12_2_, de0_.branch_id as branch4_12_2_, de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_, de0_.OBJIDESOURCE as OBJIDESO7_12_2_, de0_.objiddsource as objiddso5_12_2_, de0_.objiddtarget as objiddta6_12_2_, de0_.objidesource as objideso7_12_2_, de0_.objidetarget as objideta8_12_2_, de0_.valid_from as valid9_12_2_, de0_.valid_until as valid10_12_2_, d1_.id as id3_0_, d1_.AUTHORFROM as AUTHORFROM3_0_, d1_.AUTHORUNTIL as AUTHORUN3_3_0_, d1_.BRANCHID as BRANCHID3_0_, d1_.OBJID as OBJID3_0_, d1_.rpiid as rpiid3_0_, d1_.VALIDFROM as VALIDFROM3_0_, d1_.VALIDUNTIL as VALIDUNTIL3_0_, d1_.value as value3_0_, e2_.id as id4_1_, e2_.AUTHORFROM as AUTHORFROM4_1_, e2_.AUTHORUNTIL as AUTHORUN3_4_1_, e2_.BRANCHID as BRANCHID4_1_, e2_.OBJID as OBJID4_1_, e2_.rpiid as rpiid4_1_, e2_.VALIDFROM as VALIDFROM4_1_, e2_.VALIDUNTIL as VALIDUNTIL4_1_, e2_.value as value4_1_ from DE de0_ inner join D d1_ on de0_.OBJIDDSOURCE=d1_.OBJID and (d1_.VALIDUNTIL is null) inner join E e2_ on de0_.OBJIDESOURCE=e2_.OBJID and (e2_.VALIDUNTIL is null) where de0_.objiddtarget=? and (de0_.VALID_UNTIL is null)
[11:55:18,563,Loader] loading entity: [DE#component[objIdDTarget]{objIdDTarget={D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}}]
[11:55:18,563,AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[11:55:18,563,SQL]
/* load DE */ select
de0_.id as id12_2_,
de0_.author_from as author2_12_2_,
de0_.author_until as author3_12_2_,
de0_.branch_id as branch4_12_2_,
de0_.OBJIDDSOURCE as OBJIDDSO5_12_2_,
de0_.OBJIDESOURCE as OBJIDESO7_12_2_,
de0_.objiddsource as objiddso5_12_2_,
de0_.objiddtarget as objiddta6_12_2_,
de0_.objidesource as objideso7_12_2_,
de0_.objidetarget as objideta8_12_2_,
de0_.valid_from as valid9_12_2_,
de0_.valid_until as valid10_12_2_,
d1_.id as id3_0_,
d1_.AUTHORFROM as AUTHORFROM3_0_,
d1_.AUTHORUNTIL as AUTHORUN3_3_0_,
d1_.BRANCHID as BRANCHID3_0_,
d1_.OBJID as OBJID3_0_,
d1_.rpiid as rpiid3_0_,
d1_.VALIDFROM as VALIDFROM3_0_,
d1_.VALIDUNTIL as VALIDUNTIL3_0_,
d1_.value as value3_0_,
e2_.id as id4_1_,
e2_.AUTHORFROM as AUTHORFROM4_1_,
e2_.AUTHORUNTIL as AUTHORUN3_4_1_,
e2_.BRANCHID as BRANCHID4_1_,
e2_.OBJID as OBJID4_1_,
e2_.rpiid as rpiid4_1_,
e2_.VALIDFROM as VALIDFROM4_1_,
e2_.VALIDUNTIL as VALIDUNTIL4_1_,
e2_.value as value4_1_
from
DE de0_
inner join
D d1_
on de0_.OBJIDDSOURCE=d1_.OBJID
and (
d1_.VALIDUNTIL is null
)
inner join
E e2_
on de0_.OBJIDESOURCE=e2_.OBJID
and (
e2_.VALIDUNTIL is null
)
where
de0_.objiddtarget=?
and (
de0_.VALID_UNTIL is null
)
[11:55:18,563,AbstractBatcher] preparing statement
[11:55:18,563,StringType] binding '{D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}' to parameter: 1
[11:55:18,563,Loader] Bound [2] parameters total
[11:55:18,578,AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[11:55:18,578,Loader] processing result set
[11:55:18,578,Loader] result set row: 0
[11:55:18,578,GUIDType] returning '{D2945CCA-D6F1-422E-996E-79DF8E349785}' as column: id3_0_
[11:55:18,578,GUIDType] returning '{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}' as column: id4_1_
[11:55:18,578,StringType] returning '{06EAAACA-2542-4208-8F29-E4CBF880D12A}' as column: id12_2_
[11:55:18,578,Loader] result row: EntityKey[D#{D2945CCA-D6F1-422E-996E-79DF8E349785}], EntityKey[E#{308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}], EntityKey[DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}]
[11:55:18,578,Loader] done processing result set (1 rows)
[11:55:18,578,AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[11:55:18,578,AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[11:55:18,578,AbstractBatcher] closing statement
[11:55:18,578,Loader] total objects hydrated: 0
[11:55:18,578,Loader] done entity load
[11:55:18,578,TwoPhaseLoad] done materializing entity [D#{D2945CCA-D6F1-422E-996E-79DF8E349785}]
[11:55:18,578,StatefulPersistenceContext] initializing non-lazy collections
[11:55:18,578,JDBCTransaction] commit
[11:55:18,578,SessionImpl] automatically flushing session
[11:55:18,578,AbstractFlushingEventListener] flushing session
[11:55:18,578,AbstractFlushingEventListener] processing flush-time cascades
[11:55:18,578,AbstractFlushingEventListener] dirty checking collections
[11:55:18,578,AbstractFlushingEventListener] Flushing entities and processing referenced collections
[11:55:18,578,AbstractFlushingEventListener] Processing unreferenced collections
[11:55:18,578,AbstractFlushingEventListener] Scheduling collection removes/(re)creates/updates
[11:55:18,578,AbstractFlushingEventListener] Flushed: 0 insertions, 0 updates, 0 deletions to 3 objects
[11:55:18,578,AbstractFlushingEventListener] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
[11:55:18,578,Printer] listing entities:
[11:55:18,578,Printer] D{id={D2945CCA-D6F1-422E-996E-79DF8E349785}, rpiId=0, deFormula=DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}, valid_from=2010-04-06 11:51:33, branch_ID=0, value=testNewVersionD, objId={D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}, valid_until=null, author_from=tim, author_until=null}
[11:55:18,578,Printer] DE{id={06EAAACA-2542-4208-8F29-E4CBF880D12A}, d=null, e=null, valid_from=2010-04-06 11:51:31, objIdETarget={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}, branch_ID=0, objIdESource={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}, objIdDTarget={D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}, valid_until=null, author_from=tim, author_until=null, objIdDSource={D0ABADD3-8B91-4BDD-B560-3F2A3C4CCBE6}}
[11:55:18,578,Printer] E{id={308A2E0D-4B7E-4BE1-8E7A-A958D77556D7}, rpiId=0, deFormula=DE#{06EAAACA-2542-4208-8F29-E4CBF880D12A}, valid_from=2010-04-06 11:51:31, branch_ID=0, value=testNewVersionE, objId={C0BE0ABA-67E0-4699-B2D4-D3DBC350208F}, valid_until=null, author_from=tim, author_until=null}
[11:55:18,578,AbstractFlushingEventListener] executing flush
[11:55:18,578,ConnectionManager] registering flush begin
[11:55:18,578,ConnectionManager] registering flush end
[11:55:18,578,AbstractFlushingEventListener] post flush
[11:55:18,578,JDBCContext] before transaction completion
[11:55:18,578,SessionImpl] before transaction completion
[11:55:18,578,JDBCTransaction] committed JDBC Connection
[11:55:18,578,JDBCContext] after transaction completion
[11:55:18,578,ConnectionManager] aggressively releasing JDBC connection
[11:55:18,578,ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
[11:55:18,578,DriverManagerConnectionProvider] returning connection to pool, pool size: 1
[11:55:18,578,SessionImpl] after transaction completion
[11:55:18,578,SessionImpl] automatically closing session
[11:55:18,578,SessionImpl] closing session
[11:55:18,578,ConnectionManager] connection already null in cleanup : no action
Login
FAQ
Search
