try { con.rollback(); } catch (Exception e) { e.printStackTrace(); }
try { connection.commit(); } catch (SQLException e) { log.error("Failed to commit connection - "+connection, e); }
Clone fragments detected by clone detection tool
File path: /sql12/test/mockobjects/net/sourceforge/squirrel_sql/client/session/MockSession.java File path: /sql12/plugins/dbcopy/src/net/sourceforge/squirrel_sql/plugins/dbcopy/CopyExecutor.java
Method name: void rollback() Method name: void commitConnection(ISQLConnection)
Number of AST nodes: 2 Number of AST nodes: 2
1
try {
1
try {
2
            con.rollback();
2
            connection.commit();
3
        } catch (Exception e) {
3
        } catch (SQLException e) {
4
            e.printStackTrace();
4
            log.error("Failed to commit connection - "+connection, e);
5
        }
5
        }
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.3
Clones locationClones are in different classes
Number of node comparisons4
  1. {Non-refactorable}
    Mapping Summary
    Number of mapped statements2
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)24.7
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    1
    try
    1
    try
    1
    try
    Differences
    Expression1Expression2Difference
    java.lang.Exceptionjava.sql.SQLExceptionSUBCLASS_TYPE_MISMATCH
    java.lang.Exceptionjava.sql.SQLExceptionSUBCLASS_TYPE_MISMATCH
    printStackTraceerrorMETHOD_INVOCATION_NAME_MISMATCH
    elogVARIABLE_NAME_MISMATCH
    java.lang.Exceptionnet.sourceforge.squirrel_sql.fw.util.log.ILoggerVARIABLE_TYPE_MISMATCH
    e.printStackTrace()log.error("Failed to commit connection - " + connection,e)ARGUMENT_NUMBER_MISMATCH
    Preondition Violations
    Expression e.printStackTrace() cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression log.error("Failed to commit connection - " + connection,e) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression e.printStackTrace() is a void method call, and thus it cannot be parameterized
    Expression log.error("Failed to commit connection - " + connection,e) is a void method call, and thus it cannot be parameterized
    Expression e cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Type java.lang.Exception of variable e does not match with type net.sourceforge.squirrel_sql.fw.util.log.ILogger of variable log
    • Make classes java.lang.Exception and net.sourceforge.squirrel_sql.fw.util.log.ILogger extend a common superclass
    Expression e.printStackTrace() cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression log.error("Failed to commit connection - " + connection,e) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression e.printStackTrace() is a void method call, and thus it cannot be parameterized
    Expression log.error("Failed to commit connection - " + connection,e) is a void method call, and thus it cannot be parameterized
    1
    try
    2
    con.rollback();
    2
    con.rollback();
    2
    connection.commit();
    Differences
    Expression1Expression2Difference
    rollbackcommitMETHOD_INVOCATION_NAME_MISMATCH
    conconnectionVARIABLE_NAME_MISMATCH
    net.sourceforge.squirrel_sql.fw.sql.SQLConnectionnet.sourceforge.squirrel_sql.fw.sql.ISQLConnectionSUBCLASS_TYPE_MISMATCH
    Preondition Violations
    Expression con.rollback() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    Expression connection.commit() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    Expression con.rollback() is a void method call, and thus it cannot be parameterized
    Expression connection.commit() is a void method call, and thus it cannot be parameterized
    2
    connection.commit();
    Precondition Violations (15)
    Row Violation
    1Expression e.printStackTrace() cannot be parameterized, because it has dependencies to/from statements that will be extracted
    2Expression log.error("Failed to commit connection - " + connection,e) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    3Expression e.printStackTrace() is a void method call, and thus it cannot be parameterized
    4Expression log.error("Failed to commit connection - " + connection,e) is a void method call, and thus it cannot be parameterized
    5Expression e cannot be parameterized, because it has dependencies to/from statements that will be extracted
    6Type java.lang.Exception of variable e does not match with type net.sourceforge.squirrel_sql.fw.util.log.ILogger of variable log
    7Expression e.printStackTrace() cannot be parameterized, because it has dependencies to/from statements that will be extracted
    8Expression log.error("Failed to commit connection - " + connection,e) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    9Expression e.printStackTrace() is a void method call, and thus it cannot be parameterized
    10Expression log.error("Failed to commit connection - " + connection,e) is a void method call, and thus it cannot be parameterized
    11Expression con.rollback() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    12Expression connection.commit() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    13Expression con.rollback() is a void method call, and thus it cannot be parameterized
    14Expression connection.commit() is a void method call, and thus it cannot be parameterized
    15The refactoring of the clones is infeasible, because classes net.sourceforge.squirrel_sql.client.session.MockSession and net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor do not have a common superclass