int offset = 1; Object entry = entries.next(); PreparedStatement st = null; if ( collection.needsInserting( entry, i, elementType ) ) { if ( useBatch ) { if ( st == null ) { if ( callable ) { st = session.getBatcher().prepareBatchCallableStatement( sql ); } else { st = session.getBatcher().prepareBatchStatement( sql ); } } } else { if ( callable ) { st = session.getBatcher().prepareCallableStatement( sql ); } else { st = session.getBatcher().prepareStatement( sql ); } } try { offset += expectation.prepare( st ); //TODO: copy/paste from recreate() offset = writeKey( st, id, offset, session ); if ( hasIdentifier ) { offset = writeIdentifier( st, collection.getIdentifier(entry, i), offset, session ); } if ( hasIndex /*&& !indexIsFormula*/ ) { offset = writeIndex( st, collection.getIndex(entry, i, this), offset, session ); } writeElement(st, collection.getElement(entry), offset, session ); if ( useBatch ) { session.getBatcher().addToBatch( expectation ); } else { expectation.verifyOutcome( st.executeUpdate(), st, -1 ); } collection.afterRowInsert( this, entry, i ); count++; } catch ( SQLException sqle ) { if ( useBatch ) { session.getBatcher().abortBatch( sqle ); } throw sqle; } finally { if ( !useBatch ) { session.getBatcher().closeStatement( st ); } } } i++;
if ( collection.needsUpdating( entry, i, elementType ) ) { int offset = 1; if ( useBatch ) { if ( st == null ) { if ( callable ) { st = session.getBatcher().prepareBatchCallableStatement( sql ); } else { st = session.getBatcher().prepareBatchStatement( sql ); } } } else { if ( callable ) { st = session.getBatcher().prepareCallableStatement( sql ); } else { st = session.getBatcher().prepareStatement( sql ); } } try { offset+= expectation.prepare( st ); int loc = writeElement( st, collection.getElement( entry ), offset, session ); if ( hasIdentifier ) { writeIdentifier( st, collection.getIdentifier( entry, i ), loc, session ); } else { loc = writeKey( st, id, loc, session ); if ( hasIndex && !indexContainsFormula ) { writeIndexToWhere( st, collection.getIndex( entry, i, this ), loc, session ); } else { writeElementToWhere( st, collection.getSnapshotElement( entry, i ), loc, session ); } } if ( useBatch ) { session.getBatcher().addToBatch( expectation ); } else { expectation.verifyOutcome( st.executeUpdate(), st, -1 ); } } catch ( SQLException sqle ) { if ( useBatch ) { session.getBatcher().abortBatch( sqle ); } throw sqle; } finally { if ( !useBatch ) { session.getBatcher().closeStatement( st ); } } count++; }
Clone fragments detected by clone detection tool
File path: /hibernate-distribution-3.3.2.GA/project/core/src/main/java/org/hibernate/persister/collection/AbstractCollectionPersister.java File path: /hibernate-distribution-3.3.2.GA/project/core/src/main/java/org/hibernate/persister/collection/BasicCollectionPersister.java
Method name: void insertRows(PersistentCollection, Serializable, SessionImplementor) Method name: int doUpdateRows(Serializable, PersistentCollection, SessionImplementor)
Number of AST nodes: 26 Number of AST nodes: 23
1
int offset = 1;
2
					Object entry = entries.next();
3
					PreparedStatement st = null;
4
					if ( collection.needsInserting( entry, i, elementType ) ) {
1
if ( collection.needsUpdating( entry, i, elementType ) ) {
5
	
2
					int offset = 1;
6
					if ( useBatch ) {
3
					if ( useBatch ) {
7
							if ( st == null ) {
4
						if ( st == null ) {
8
								if ( callable ) {
5
							if ( callable ) {
9
									st = session.getBatcher().prepareBatchCallableStatement( sql );
6
								st = session.getBatcher().prepareBatchCallableStatement( sql );
10
								}
7
							}
11
								else {
8
							else {
12
									st = session.getBatcher().prepareBatchStatement( sql );
9
								st = session.getBatcher().prepareBatchStatement( sql );
13
								}
10
							}
14
							}
11
						}
15
						}
12
					}
16
						else {
13
					else {
17
							if ( callable ) {
14
						if ( callable ) {
18
								st = session.getBatcher().prepareCallableStatement( sql );
15
							st = session.getBatcher().prepareCallableStatement( sql );
19
							}
16
						}
20
							else {
17
						else {
21
								st = session.getBatcher().prepareStatement( sql );
18
							st = session.getBatcher().prepareStatement( sql );
22
							}
19
						}
23
						}
20
					}
24
						try {
21
					try {
25
							offset += expectation.prepare( st );
22
						offset+= expectation.prepare( st );
26
							//TODO: copy/paste from recreate()
23
						
27
							offset = writeKey( st, id, offset, session );
24
int loc = writeElement( st, collection.getElement( entry ), offset, session );
28
							if ( hasIdentifier ) {
25
						if ( hasIdentifier ) {
29
								offset = writeIdentifier( st, collection.getIdentifier(entry, i), offset, session );
26
							writeIdentifier( st, collection.getIdentifier( entry, i ), loc, session );
30
							}
27
						}
28
						else {
29
							loc = writeKey( st, id, loc, session );
31
							if ( hasIndex /*&& !indexIsFormula*/ ) {
30
							if ( hasIndex && !indexContainsFormula ) {
32
								offset = writeIndex( st, collection.getIndex(entry, i, this), offset, session );
31
								writeIndexToWhere( st, collection.getIndex( entry, i, this ), loc, session );
33
							}
32
							}
34
							
33
							else {
35
writeElement(st, collection.getElement(entry), offset, session );
34
								writeElementToWhere( st, collection.getSnapshotElement( entry, i ), loc, session );
36
			
35
							}
36
						}
37
				if ( useBatch ) {
37
						if ( useBatch ) {
38
								session.getBatcher().addToBatch( expectation );
38
							session.getBatcher().addToBatch( expectation );
39
							}
39
						}
40
							else {
40
						else {
41
								expectation.verifyOutcome( st.executeUpdate(), st, -1 );
41
							expectation.verifyOutcome( st.executeUpdate(), st, -1 );
42
							}
42
						}
43
							collection.afterRowInsert( this, entry, i );
43
					
44
							count++;
45
						}
44
}
46
						catch ( SQLException sqle ) {
45
					catch ( SQLException sqle ) {
47
							if ( useBatch ) {
46
						if ( useBatch ) {
48
								session.getBatcher().abortBatch( sqle );
47
							session.getBatcher().abortBatch( sqle );
49
							}
48
						}
50
							throw sqle;
49
						throw sqle;
51
						}
50
					}
52
						finally {
51
					finally {
53
							if ( !useBatch ) {
52
						if ( !useBatch ) {
54
								session.getBatcher().closeStatement( st );
53
							session.getBatcher().closeStatement( st );
55
							}
54
						}
56
						}
55
					}
57
					}
56
					
58
					i++;
57
count++;
58
				}
Summary
Number of common nesting structure subtrees2
Number of refactorable cases0
Number of non-refactorable cases2
Time elapsed for finding largest common nesting structure subtrees (ms)1.7
Clones locationClones are in different classes having the same super class
Number of node comparisons56
  1. {Non-refactorable}
    Mapping Summary
    Number of mapped statements9
    Number of unmapped statements in the first code fragment3
    Number of unmapped statements in the second code fragment14
    Time elapsed for statement mapping (ms)8.0
    Clone typeType 3
    Mapped Statements
    ID Statement ID Statement
    14
    int offset = 1;
                                      
    15
    Object entry = entries.next();
    15
    Object entry = entries.next();
    Preondition Violations
    Unmatched statement Object entry=entries.next(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
                                                                    
    16
    PreparedStatement st = null;
    16
    PreparedStatement st = null;
    Preondition Violations
    Unmatched statement PreparedStatement st=null; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
                                                                
    17
    if (collection.needsInserting(entry, i, elementType))
    17
    if (collection.needsInserting(entry, i, elementType))
    14
    if (collection.needsUpdating(entry, i, elementType))
    Differences
    Expression1Expression2Difference
    needsInsertingneedsUpdatingMETHOD_INVOCATION_NAME_MISMATCH
    14
    if (collection.needsUpdating(entry, i, elementType))
                                      
    15
    int offset = 1;
    18
    if (useBatch)
    16
    if (useBatch)
    19
    if (st == null)
    17
    if (st == null)
    20
    if (callable)
    18
    if (callable)
    21
    st = session.getBatcher().prepareBatchCallableStatement(sql);
    19
    st = session.getBatcher().prepareBatchCallableStatement(sql);
    else
    else
    22
    st = session.getBatcher().prepareBatchStatement(sql);
    20
    st = session.getBatcher().prepareBatchStatement(sql);
    else
    else
    23
    if (callable)
    21
    if (callable)
    24
    st = session.getBatcher().prepareCallableStatement(sql);
    22
    st = session.getBatcher().prepareCallableStatement(sql);
    else
    else
    25
    st = session.getBatcher().prepareStatement(sql);
    23
    st = session.getBatcher().prepareStatement(sql);
                  
    24
    try
                                                                            
    25
    offset += expectation.prepare(st);
    Preondition Violations
    Unmatched statement offset+=expectation.prepare(st); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    25
    offset += expectation.prepare(st);
                                                                                                                                                      
    26
    int loc = writeElement(st, collection.getElement(entry), offset, session);
    Preondition Violations
    Unmatched statement int loc=writeElement(st,collection.getElement(entry),offset,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    26
    int loc = writeElement(st, collection.getElement(entry), offset, session);
                                              
    27
    if (hasIdentifier)
                                                                                                                                                
    28
    writeIdentifier(st, collection.getIdentifier(entry, i), loc, session);
    Preondition Violations
    Unmatched statement writeIdentifier(st,collection.getIdentifier(entry,i),loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    28
    writeIdentifier(st, collection.getIdentifier(entry, i), loc, session);
            
    else
                                                                            
    29
    loc = writeKey(st, id, loc, session);
    Preondition Violations
    Unmatched statement loc=writeKey(st,id,loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    29
    loc = writeKey(st, id, loc, session);
                                                                                      
    30
    if (hasIndex && !indexContainsFormula)
                                                                                                                                                    
    31
    writeIndexToWhere(st, collection.getIndex(entry, i, this), loc, session);
    Preondition Violations
    Unmatched statement writeIndexToWhere(st,collection.getIndex(entry,i,this),loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    31
    writeIndexToWhere(st, collection.getIndex(entry, i, this), loc, session);
            
    else
                                                                                                                                                                  
    32
    writeElementToWhere(st, collection.getSnapshotElement(entry, i), loc, session);
    Preondition Violations
    Unmatched statement writeElementToWhere(st,collection.getSnapshotElement(entry,i),loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    32
    writeElementToWhere(st, collection.getSnapshotElement(entry, i), loc, session);
                                    
    33
    if (useBatch)
                                                                                                      
    34
    session.getBatcher().addToBatch(expectation);
            
    else
                                                                                                                    
    35
    expectation.verifyOutcome(st.executeUpdate(), st, -1);
    Preondition Violations
    Unmatched statement expectation.verifyOutcome(st.executeUpdate(),st,-1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    35
    expectation.verifyOutcome(st.executeUpdate(), st, -1);
                            
    36
    count++;
    Precondition Violations (9)
    Row Violation
    1Unmatched statement Object entry=entries.next(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    2Unmatched statement PreparedStatement st=null; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    3Unmatched statement offset+=expectation.prepare(st); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    4Unmatched statement int loc=writeElement(st,collection.getElement(entry),offset,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    5Unmatched statement writeIdentifier(st,collection.getIdentifier(entry,i),loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    6Unmatched statement loc=writeKey(st,id,loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    7Unmatched statement writeIndexToWhere(st,collection.getIndex(entry,i,this),loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    8Unmatched statement writeElementToWhere(st,collection.getSnapshotElement(entry,i),loc,session); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    9Unmatched statement expectation.verifyOutcome(st.executeUpdate(),st,-1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
  2. {Non-refactorable}
    Mapping Summary
    Number of mapped statements1
    Number of unmapped statements in the first code fragment3
    Number of unmapped statements in the second code fragment2
    Time elapsed for statement mapping (ms)0.7
    Clone typeType 3
    Mapped Statements
    ID Statement ID Statement
    29
    if (hasIdentifier)
    29
    if (hasIdentifier)
    18
    if (callable)
    Differences
    Expression1Expression2Difference
    hasIdentifiercallableVARIABLE_NAME_MISMATCH
    18
    if (callable)
                                                                                                                                  
    19
    st = session.getBatcher().prepareBatchCallableStatement(sql);
    Preondition Violations
    Unmatched statement st=session.getBatcher().prepareBatchCallableStatement(sql); cannot be moved, because it updates a variable modified in other unmapped statements
    19
    st = session.getBatcher().prepareBatchCallableStatement(sql);
            
    else
                                                                                                                  
    20
    st = session.getBatcher().prepareBatchStatement(sql);
    Preondition Violations
    Unmatched statement st=session.getBatcher().prepareBatchStatement(sql); cannot be moved, because it updates a variable modified in other unmapped statements
    20
    st = session.getBatcher().prepareBatchStatement(sql);
    30
    offset = writeIdentifier(st, collection.getIdentifier(entry, i), offset, session);
                                                                                                                                                                    
    Precondition Violations (2)
    Row Violation
    1Unmatched statement st=session.getBatcher().prepareBatchCallableStatement(sql); cannot be moved, because it updates a variable modified in other unmapped statements
    2Unmatched statement st=session.getBatcher().prepareBatchStatement(sql); cannot be moved, because it updates a variable modified in other unmapped statements