Session s = openSession(); s.beginTransaction(); s.createQuery( "insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h where h.mother.mother is not null" ).executeUpdate(); s.createQuery( "insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h join h.mother m where m.mother is not null" ).executeUpdate(); s.createQuery( "delete from Animal" ).executeUpdate(); s.getTransaction().commit(); s.close();
Session s = openSession(); s.beginTransaction(); s.createQuery( "delete Task" ).executeUpdate(); s.createQuery( "delete Resource" ).executeUpdate(); s.createQuery( "delete User" ).executeUpdate(); s.getTransaction().commit(); s.close();
Clone fragments detected by clone detection tool
File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/hql/BulkManipulationTest.java File path: /hibernate-distribution-3.3.2.GA/project/testsuite/src/test/java/org/hibernate/test/stateless/fetching/StatelessSessionFetchingTest.java
Method name: void testInsertWithSelectListUsingJoins() Method name: void cleanup()
Number of AST nodes: 7 Number of AST nodes: 7
1
Session s = openSession();
1
Session s = openSession();
2
		s.beginTransaction();
2
		s.beginTransaction();
3
		s.createQuery( "insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h where h.mother.mother is not null" ).executeUpdate();
3
		s.createQuery( "
4
		s.createQuery( "insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h join h.mother m where m.mother is not null
4
delete Task" ).executeUpdate();
5
" ).executeUpdate();
5
		s.createQuery( "delete Resource" ).executeUpdate();
6
		s.createQuery( "delete from Animal" ).executeUpdate();
6
		s.createQuery( "delete User" ).executeUpdate();
7
		s.getTransaction().commit();
7
		s.getTransaction().commit();
8
		s.close();
8
		s.close();
Summary
Number of common nesting structure subtrees1
Number of refactorable cases1
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones locationClones are in different classes having the same super class
Number of node comparisons49
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements7
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)0.0
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    1
    Session s = openSession();
    1
    Session s = openSession();
    1
    Session s = openSession();
    Differences
    Expression1Expression2Difference
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    1
    Session s = openSession();
    2
    s.beginTransaction();
    2
    s.beginTransaction();
    2
    s.beginTransaction();
    Differences
    Expression1Expression2Difference
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    2
    s.beginTransaction();
    3
    s.createQuery("insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h where h.mother.mother is not null").executeUpdate();
    3
    s.createQuery("insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h where h.mother.mother is not null").executeUpdate();
    3
    s.createQuery("delete Task").executeUpdate();
    Differences
    Expression1Expression2Difference
    "insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h where h.mother.mother is not null""delete Task"LITERAL_VALUE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    3
    s.createQuery("delete Task").executeUpdate();
    4
    s.createQuery("insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h join h.mother m where m.mother is not null").executeUpdate();
    4
    s.createQuery("insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h join h.mother m where m.mother is not null").executeUpdate();
    4
    s.createQuery("delete Resource").executeUpdate();
    Differences
    Expression1Expression2Difference
    "insert into Animal (description, bodyWeight) select h.description, h.bodyWeight from Human h join h.mother m where m.mother is not null""delete Resource"LITERAL_VALUE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    4
    s.createQuery("delete Resource").executeUpdate();
    5
    s.createQuery("delete from Animal").executeUpdate();
    5
    s.createQuery("delete from Animal").executeUpdate();
    5
    s.createQuery("delete User").executeUpdate();
    Differences
    Expression1Expression2Difference
    "delete from Animal""delete User"LITERAL_VALUE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    5
    s.createQuery("delete User").executeUpdate();
    6
    s.getTransaction().commit();
    6
    s.getTransaction().commit();
    6
    s.getTransaction().commit();
    Differences
    Expression1Expression2Difference
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    6
    s.getTransaction().commit();
    7
    s.close();
    7
    s.close();
    7
    s.close();
    Differences
    Expression1Expression2Difference
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    7
    s.close();
    Precondition Violations (0)
    Row Violation