long start = 0, finish = 0; try { if (s_log.isDebugEnabled()) { s_log.debug(i18n.LOADING_TABLES_MSG); start = System.currentTimeMillis(); } int beginProgress = getLoadMethodProgress(progress++); setProgress(i18n.LOADING_TABLES_MSG, beginProgress); privateLoadTables(catalog, schema, tableNamePattern, types, i18n.LOADING_TABLES_MSG, beginProgress); if (s_log.isDebugEnabled()) { finish = System.currentTimeMillis(); s_log.debug("Tables loaded in " + (finish - start) + " ms"); } } catch (Exception ex) { s_log.error("Error loading tables", ex); } return progress;
long start = 0, finish = 0; try { if (s_log.isDebugEnabled()) { s_log.debug(i18n.LOADING_CATALOGS_MSG); start = System.currentTimeMillis(); } int beginProgress = getLoadMethodProgress(progress++); setProgress(i18n.LOADING_CATALOGS_MSG, beginProgress); privateLoadCatalogs(); if (s_log.isDebugEnabled()) { finish = System.currentTimeMillis(); s_log.debug("Catalogs loaded in " + (finish - start) + " ms"); } } catch (Exception ex) { s_log.error("Error loading catalogs", ex); } return progress;
Clone fragments detected by clone detection tool
File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/schemainfo/SchemaInfo.java File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/schemainfo/SchemaInfo.java
Method name: int loadTables(String, String, String, String[], int) Method name: int loadCatalogs(int)
Number of AST nodes: 12 Number of AST nodes: 12
1
long start = 0, finish = 0;
1
long start = 0, finish = 0;
2
      try
2
      try
3
      {
3
      {
4
         
5
         if (s_log.isDebugEnabled()) {
4
         if (s_log.isDebugEnabled()) {
6
             s_log.debug(i18n.LOADING_TABLES_MSG);
5
             s_log.debug(i18n.LOADING_CATALOGS_MSG);
7
             start = System.currentTimeMillis();
6
             start = System.currentTimeMillis();
8
         }
7
         }
9
         int beginProgress = getLoadMethodProgress(progress++);
8
         int beginProgress = getLoadMethodProgress(progress++);
10
         setProgress(i18n.LOADING_TABLES_MSG, beginProgress);
9
         setProgress(i18n.LOADING_CATALOGS_MSG, beginProgress);
11
         privateLoadTables(catalog, 
10
         privateLoad
12
                           schema, 
13
                           tableNamePattern, 
14
                           types, 
15
                           i18n.LOADING_TABLES_MSG, 
16
                           beginProgress);
11
Catalogs();
17
         if (s_log.isDebugEnabled()) {
12
         if (s_log.isDebugEnabled()) {
18
             finish = System.currentTimeMillis();
13
             finish = System.currentTimeMillis();
19
             s_log.debug("Tables loaded in " + (finish - start) + " ms");
14
             s_log.debug("Catalogs loaded in " + (finish - start) + " ms");
20
         }
15
         }
21
      }
16
      }
22
      catch (Exception ex)
17
      catch (Exception ex)
23
      {
18
      {
24
         s_log.error("Error loading tables", ex);
19
         s_log.error("Error loading catalogs", ex);
25
      }
20
      }
26
      return progress;
21
      return progress;
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.6
Clones locationClones are declared in the same class
Number of node comparisons48
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements12
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)222.6
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    1
    long start = 0, finish = 0;
    1
    long start = 0, finish = 0;
    2
    try
    2
    try
    2
    try
    Differences
    Expression1Expression2Difference
    "Error loading tables""Error loading catalogs"LITERAL_VALUE_MISMATCH
    2
    try
    3
    if (s_log.isDebugEnabled())
    3
    if (s_log.isDebugEnabled())
    4
    s_log.debug(i18n.LOADING_TABLES_MSG);
    4
    s_log.debug(i18n.LOADING_TABLES_MSG);
    4
    s_log.debug(i18n.LOADING_CATALOGS_MSG);
    Differences
    Expression1Expression2Difference
    LOADING_TABLES_MSGLOADING_CATALOGS_MSGVARIABLE_NAME_MISMATCH
    4
    s_log.debug(i18n.LOADING_CATALOGS_MSG);
    5
    start = System.currentTimeMillis();
    5
    start = System.currentTimeMillis();
    6
    int beginProgress = getLoadMethodProgress(progress++);
    6
    int beginProgress = getLoadMethodProgress(progress++);
    7
    setProgress(i18n.LOADING_TABLES_MSG, beginProgress);
    7
    setProgress(i18n.LOADING_TABLES_MSG, beginProgress);
    7
    setProgress(i18n.LOADING_CATALOGS_MSG, beginProgress);
    Differences
    Expression1Expression2Difference
    LOADING_TABLES_MSGLOADING_CATALOGS_MSGVARIABLE_NAME_MISMATCH
    7
    setProgress(i18n.LOADING_CATALOGS_MSG, beginProgress);
    8
    privateLoadTables(catalog, schema, tableNamePattern, types, i18n.LOADING_TABLES_MSG, beginProgress);
    8
    privateLoadTables(catalog, schema, tableNamePattern, types, i18n.LOADING_TABLES_MSG, beginProgress);
    8
    privateLoadCatalogs();
    Differences
    Expression1Expression2Difference
    privateLoadTablesprivateLoadCatalogsMETHOD_INVOCATION_NAME_MISMATCH
    privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress)privateLoadCatalogs()ARGUMENT_NUMBER_MISMATCH
    Preondition Violations
    Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    • Inline private method privateLoadTables
    Expression privateLoadCatalogs() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    • Inline private method privateLoadCatalogs
    Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) is a void method call, and thus it cannot be parameterized
    Expression privateLoadCatalogs() is a void method call, and thus it cannot be parameterized
    Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    • Inline private method privateLoadTables
    Expression privateLoadCatalogs() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    • Inline private method privateLoadCatalogs
    Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) is a void method call, and thus it cannot be parameterized
    Expression privateLoadCatalogs() is a void method call, and thus it cannot be parameterized
    8
    privateLoadCatalogs();
    9
    if (s_log.isDebugEnabled())
    9
    if (s_log.isDebugEnabled())
    10
    finish = System.currentTimeMillis();
    10
    finish = System.currentTimeMillis();
    11
    s_log.debug("Tables loaded in " + (finish - start) + " ms");
    11
    s_log.debug("Tables loaded in " + (finish - start) + " ms");
    11
    s_log.debug("Catalogs loaded in " + (finish - start) + " ms");
    Differences
    Expression1Expression2Difference
    "Tables loaded in ""Catalogs loaded in "LITERAL_VALUE_MISMATCH
    11
    s_log.debug("Catalogs loaded in " + (finish - start) + " ms");
    12
    return progress;
    12
    return progress;
    Precondition Violations (8)
    Row Violation
    1Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    2Expression privateLoadCatalogs() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    3Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) is a void method call, and thus it cannot be parameterized
    4Expression privateLoadCatalogs() is a void method call, and thus it cannot be parameterized
    5Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    6Expression privateLoadCatalogs() is a method call throwing exception(s) that should be caught by a try block that will be extracted
    7Expression privateLoadTables(catalog,schema,tableNamePattern,types,i18n.LOADING_TABLES_MSG,beginProgress) is a void method call, and thus it cannot be parameterized
    8Expression privateLoadCatalogs() is a void method call, and thus it cannot be parameterized