ISession session = getSession(); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); String sql = SQL; if (isOS400) { sql = OS_400_SQL; } if (s_log.isDebugEnabled()) { s_log.debug("UDF details SQL: "+sql); s_log.debug("UDF schema: "+doi.getSchemaName()); s_log.debug("UDF name: "+doi.getSimpleName()); } PreparedStatement pstmt = session.getSQLConnection().prepareStatement(sql); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt;
ResultSet result = null; if (sql.endsWith("?") || sql.endsWith("?)")) { if (s_log.isDebugEnabled()) { s_log.debug("ModifySequenceCommand: running sql=" + sql); s_log.debug("param sequenceName = " + sequenceName); } PreparedStatement stmt = _session.getSQLConnection().prepareStatement(sql); stmt.setString(1, sequenceName); result = stmt.executeQuery(); } else { s_log.debug("ModifySequenceCommand: running sql=" + sql); Statement stmt = _session.getSQLConnection().createStatement(); result = stmt.executeQuery(sql); } return result;
Clone fragments detected by clone detection tool
File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/tab/UDFDetailsTab.java File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/ModifySequenceCommand.java
Method name: PreparedStatement createStatement() Method name: ResultSet executeQuery(String, String)
Number of AST nodes: 13 Number of AST nodes: 12
1
ISession session = getSession();
2
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
3
        String sql = SQL;
4
        if (isOS400) {
5
            sql = OS_400_SQL;
6
        }
7
        
1
ResultSet result = null;
2
		if (sql.endsWith("?") || sql.endsWith("?)"))
3
		{
8
if (s_log.isDebugEnabled()) {
4
			if (s_log.isDebugEnabled())
9
            s_log.debug("UDF details SQL: "+sql);
10
            s_log.debug("UDF schema: "+doi.getSchemaName());
11
            s_log.debug("UDF name: "+doi.getSimpl
5
			{
6
				s_log.debug("ModifySequenceCommand: running sql=" + sql);
12
eName());
7
				s_log.debug("param sequenceName = " + sequenceName
13
        }
8
);
9
			}
14
		PreparedStatement pstmt = session.getSQLConnection().prepareStatement(sql);
10
			PreparedStatement stmt = _session.getSQLConnection().prepareStatement(sql);
15
        p
16
stmt.setString(1, doi.getSchemaName());
11
			stmt.setString(1, sequenceName);
17
		pstmt.setString(2, doi.getSimpleName());
12
			result = stmt.executeQuery();
13
		} else
14
		{
15
			s_log.debug("ModifySequenceCommand: running sql=" + sql);
16
			Statement stmt = _session.getSQLConnection().createStatement();
17
			result = stmt.executeQuery(sql);
18
		}
18
		return pstmt;
19
		return result;
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)1.2
Clones locationClones are in different classes
Number of node comparisons7
  1. {Non-refactorable}
    Mapping Summary
    Number of mapped statements1
    Number of unmapped statements in the first code fragment4
    Number of unmapped statements in the second code fragment2
    Time elapsed for statement mapping (ms)29.8
    Clone typeType 3
    Mapped Statements
    ID Statement ID Statement
    1
    ISession session = getSession();
                                                                      
    2
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
                                                                                                          
    3
    String sql = SQL;
                                        
    4
    if (isOS400)
    4
    if (isOS400)
    3
    if (s_log.isDebugEnabled())
    Differences
    Expression1Expression2Difference
    isOS400s_log.isDebugEnabled()TYPE_COMPATIBLE_REPLACEMENT
    3
    if (s_log.isDebugEnabled())
                                                                                                                            
    4
    s_log.debug("ModifySequenceCommand: running sql=" + sql);
    Preondition Violations
    Unmatched statement s_log.debug("ModifySequenceCommand: running sql=" + sql); cannot be moved before the extracted code, because it has control dependencies from statements that will be extracted
    4
    s_log.debug("ModifySequenceCommand: running sql=" + sql);
                                                                                                                  
    5
    s_log.debug("param sequenceName = " + sequenceName);
    Preondition Violations
    Unmatched statement s_log.debug("param sequenceName = " + sequenceName); cannot be moved before the extracted code, because it has control dependencies from statements that will be extracted
    5
    s_log.debug("param sequenceName = " + sequenceName);
    5
    sql = OS_400_SQL;
                                        
    Precondition Violations (3)
    Row Violation
    1Unmatched statement s_log.debug("ModifySequenceCommand: running sql=" + sql); cannot be moved before the extracted code, because it has control dependencies from statements that will be extracted
    2Unmatched statement s_log.debug("param sequenceName = " + sequenceName); cannot be moved before the extracted code, because it has control dependencies from statements that will be extracted
    3The refactoring of the clones is infeasible, because the number of macthed statements is equal to zero