DatabaseMetaData md = con.getMetaData(); String cat = "dbcopydest"; String schemaPattern = null; String tableNamePattern = null; ResultSet rs = md.getTables(cat, schemaPattern, tableNamePattern, new String[] { "TABLE" }); while (rs.next()) { /* * String catalog, String schema, String simpleName, String tableType, String remarks, */ String catalog = rs.getString(1); String schema = rs.getString(2); String simpleName = rs.getString(3); String tableType = rs.getString(4); String remarks = rs.getString(5); System.out.println("catalog: "+catalog); System.out.println("schema: "+schema); System.out.println("simpleName: "+simpleName); System.out.println("tableType: "+tableType); System.out.println("remarks: "+remarks); }
DatabaseMetaData md = con.getMetaData(); String cat = "DBCOPYDEST"; String schemaPattern = "MANNINGR"; String tableNamePattern = "TEST"; ResultSet rs = md.getTables(cat, schemaPattern, tableNamePattern, new String[] { "TABLE" }); while (rs.next()) { /* * String catalog, String schema, String simpleName, String tableType, String remarks, */ String catalog = rs.getString(1); String schema = rs.getString(2); String simpleName = rs.getString(3); String tableType = rs.getString(4); String remarks = rs.getString(5); System.out.println("catalog: "+catalog); System.out.println("schema: "+schema); System.out.println("simpleName: "+simpleName); System.out.println("tableType: "+tableType); System.out.println("remarks: "+remarks); }
Clone fragments detected by clone detection tool
File path: /sql12/test/adhoc/test/SybaseNonDboTableTest.java File path: /sql12/test/adhoc/test/ProgressGetTablesTest.java
Method name: void test(Connection) Method name: void test(Connection)
Number of AST nodes: 16 Number of AST nodes: 16
1
DatabaseMetaData md = con.getMetaData();
1
DatabaseMetaData md = con.getMetaData();
2
      
2
      
3
      String cat = "dbcopydest";
3
      String cat = "DBCOPYDEST";
4
      String schemaPattern = null;
4
      String schemaPattern = "MANNINGR";
5
      String tableNamePattern = null;
5
      String tableNamePattern = "TEST";
6
      ResultSet rs = md.getTables(cat,
6
      ResultSet rs = md.getTables(cat,
7
                                  schemaPattern,
7
                                  schemaPattern,
8
                                  tableNamePattern,
8
                                  tableNamePattern,
9
                                  new String[] { "TABLE" });
9
                                  new String[] { "TABLE" });
10
      while (rs.next()) {
10
      while (rs.next()) {
11
         /*
11
         /*
12
          * String catalog, String schema, String simpleName,
12
          * String catalog, String schema, String simpleName,
13
                String tableType, String remarks,
13
                String tableType, String remarks,
14
          */
14
          */
15
         String catalog = rs.getString(1);
15
         String catalog = rs.getString(1);
16
         String schema = rs.getString(2);
16
         String schema = rs.getString(2);
17
         String simpleName = rs.getString(3);
17
         String simpleName = rs.getString(3);
18
         String tableType = rs.getString(4);
18
         String tableType = rs.getString(4);
19
         String remarks = rs.getString(5);
19
         String remarks = rs.getString(5);
20
         System.out.println("catalog: "+catalog);
20
         System.out.println("catalog: "+catalog);
21
         System.out.println("schema: "+schema);
21
         System.out.println("schema: "+schema);
22
         System.out.println("simpleName: "+simpleName);
22
         System.out.println("simpleName: "+simpleName);
23
         System.out.println("tableType: "+tableType);
23
         System.out.println("tableType: "+tableType);
24
         System.out.println("remarks: "+remarks);
24
         System.out.println("remarks: "+remarks);
25
      }
25
      }
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.1
Clones locationClones are in different classes
Number of node comparisons146
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements16
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)12.5
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    1
    DatabaseMetaData md = con.getMetaData();
    1
    DatabaseMetaData md = con.getMetaData();
    2
    String cat = "dbcopydest";
    2
    String cat = "dbcopydest";
    2
    String cat = "DBCOPYDEST";
    Differences
    Expression1Expression2Difference
    "dbcopydest""DBCOPYDEST"LITERAL_VALUE_MISMATCH
    2
    String cat = "DBCOPYDEST";
    3
    String schemaPattern = null;
    3
    String schemaPattern = null;
    3
    String schemaPattern = "MANNINGR";
    Differences
    Expression1Expression2Difference
    null"MANNINGR"TYPE_COMPATIBLE_REPLACEMENT
    3
    String schemaPattern = "MANNINGR";
    4
    String tableNamePattern = null;
    4
    String tableNamePattern = null;
    4
    String tableNamePattern = "TEST";
    Differences
    Expression1Expression2Difference
    null"TEST"TYPE_COMPATIBLE_REPLACEMENT
    4
    String tableNamePattern = "TEST";
    5
    ResultSet rs = md.getTables(cat, schemaPattern, tableNamePattern, new String[] {"TABLE"});
    5
    ResultSet rs = md.getTables(cat, schemaPattern, tableNamePattern, new String[] {"TABLE"});
    6
    while (rs.next())
    6
    while (rs.next())
    7
    String catalog = rs.getString(1);
    7
    String catalog = rs.getString(1);
    8
    String schema = rs.getString(2);
    8
    String schema = rs.getString(2);
    9
    String simpleName = rs.getString(3);
    9
    String simpleName = rs.getString(3);
    10
    String tableType = rs.getString(4);
    10
    String tableType = rs.getString(4);
    11
    String remarks = rs.getString(5);
    11
    String remarks = rs.getString(5);
    12
    System.out.println("catalog: " + catalog);
    12
    System.out.println("catalog: " + catalog);
    13
    System.out.println("schema: " + schema);
    13
    System.out.println("schema: " + schema);
    14
    System.out.println("simpleName: " + simpleName);
    14
    System.out.println("simpleName: " + simpleName);
    15
    System.out.println("tableType: " + tableType);
    15
    System.out.println("tableType: " + tableType);
    16
    System.out.println("remarks: " + remarks);
    16
    System.out.println("remarks: " + remarks);
    Precondition Violations (0)
    Row Violation