Session s = openSession(); Transaction t = s.beginTransaction(); s.createQuery( "delete EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2" ).executeUpdate(); s.createQuery( "delete from EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2" ).executeUpdate(); s.createQuery( "delete from EntityWithCrazyCompositeKey e where e.id.id = 1 and e.id.otherId = 2" ).executeUpdate(); t.commit(); s.close();
Session s = openSession(); Transaction txn = s.beginTransaction(); s.createQuery( "delete Animal where description like 'grand%'" ).executeUpdate(); s.createQuery( "delete Animal where not description like 'root%'" ).executeUpdate(); s.createQuery( "delete Animal" ).executeUpdate(); txn.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/hql/ScrollableCollectionFetchingTest.java
Method name: void testDeleteSyntaxWithCompositeId() Method name: void cleanup()
Number of AST nodes: 7 Number of AST nodes: 7
1
Session s = openSession();
1
Session s = openSession();
2
		Transaction t = s.beginTransaction();
2
			Transaction txn = s.beginTransaction();
3
			
3
		s.createQuery( "delete EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2" ).executeUpdate();
4
			s.createQuery( "delete Animal where description like 'grand%'" ).executeUpdate();
4
		s.createQuery( "delete from EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2" ).executeUpdate();
5
			s.createQuery( "delete Animal where not description like 'root%'" ).executeUpdate();
5
		s.createQuery( "delete from EntityWithCrazyCompositeKey e where e.id.id = 1 and e.id.otherId = 2" ).executeUpdate();
6
			s.createQuery( "delete Animal" ).executeUpdate();
6
		t.commit();
7
			txn.commit();
7
		s.close();
8
			s.close();
Summary
Number of common nesting structure subtrees1
Number of refactorable cases0
Number of non-refactorable cases1
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones locationClones are in different classes
Number of node comparisons29
  1. {Non-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
    Transaction t = s.beginTransaction();
    2
    Transaction t = s.beginTransaction();
    2
    Transaction txn = s.beginTransaction();
    Differences
    Expression1Expression2Difference
    ttxnVARIABLE_NAME_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    2
    Transaction txn = s.beginTransaction();
    3
    s.createQuery("delete EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2").executeUpdate();
    3
    s.createQuery("delete EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2").executeUpdate();
    3
    s.createQuery("delete Animal where description like 'grand%'").executeUpdate();
    Differences
    Expression1Expression2Difference
    "delete EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2""delete Animal where description like 'grand%'"LITERAL_VALUE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    3
    s.createQuery("delete Animal where description like 'grand%'").executeUpdate();
    4
    s.createQuery("delete from EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2").executeUpdate();
    4
    s.createQuery("delete from EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2").executeUpdate();
    4
    s.createQuery("delete Animal where not description like 'root%'").executeUpdate();
    Differences
    Expression1Expression2Difference
    "delete from EntityWithCrazyCompositeKey where id.id = 1 and id.otherId = 2""delete Animal where not description like 'root%'"LITERAL_VALUE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    4
    s.createQuery("delete Animal where not description like 'root%'").executeUpdate();
    5
    s.createQuery("delete from EntityWithCrazyCompositeKey e where e.id.id = 1 and e.id.otherId = 2").executeUpdate();
    5
    s.createQuery("delete from EntityWithCrazyCompositeKey e where e.id.id = 1 and e.id.otherId = 2").executeUpdate();
    5
    s.createQuery("delete Animal").executeUpdate();
    Differences
    Expression1Expression2Difference
    "delete from EntityWithCrazyCompositeKey e where e.id.id = 1 and e.id.otherId = 2""delete Animal"LITERAL_VALUE_MISMATCH
    org.hibernate.classic.Sessionorg.hibernate.SessionSUBCLASS_TYPE_MISMATCH
    5
    s.createQuery("delete Animal").executeUpdate();
    6
    t.commit();
    6
    t.commit();
    6
    txn.commit();
    Differences
    Expression1Expression2Difference
    ttxnVARIABLE_NAME_MISMATCH
    6
    txn.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 (1)
    Row Violation
    1The refactoring of the clones is infeasible, because classes org.hibernate.test.hql.BulkManipulationTest and org.hibernate.test.hql.ScrollableCollectionFetchingTest.TestData do not have a common superclass