File path: /sql12/plugins/firebird/src/org/firebirdsql/squirrel/exp/AllIndexesParentExpander.java | File path: /sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/InstanceParentExpander.java | |||
Method name: List
|
Method name: List
|
|||
Number of AST nodes: 6 | Number of AST nodes: 6 | |||
1 | try↵ | 1 | try↵ | |
2 | {↵ | |||
3 | ↵ | 2 | {↵ | |
4 | pstmt = conn.prepareStatement(ALL_INDICES_SQL);↵ | 3 | pstmt = conn.prepareStatement(↵ | |
5 | final ResultSet ↵ | 4 | SQL);↵ | |
6 | rs = pstmt.executeQuery();↵ | 5 | rs = pstmt.executeQuery();↵ | |
7 | while (rs.next())↵ | 6 | while (rs.next())↵ | |
8 | {↵ | |||
9 | ↵ | 7 | {↵ | |
10 | IDatabaseObjectInfo doi = new DatabaseObjectInfo(↵ | 8 | IDatabaseObjectInfo doi = new DatabaseObjectInfo(↵ | |
11 | null, null,↵ | 9 | null, null,↵ | |
12 | rs.getString(1),↵ | |||
13 | DatabaseObjectType.INDEX, md);↵ | |||
14 | ↵ | 10 | rs.getString(1), IObjectTypes.INSTANCE, md);↵ | |
11 | // final Map map = new HashMap();↵ | |||
12 | // map.put("Instance Number", new Integer(rs.getInt(1)));↵ | |||
13 | // map.put("Name", rs.getString(2));↵ | |||
14 | // map.put("Host Name", rs.getString(3));↵ | |||
15 | // map.put("Version", rs.getString(4));↵ | |||
16 | // map.put("Startup Time", rs.getDate(5));↵ | |||
17 | // map.put("Instance Status", rs.getString(6));↵ | |||
18 | // map.put("Parallel", rs.getString(7));↵ | |||
19 | // map.put("Thread #", new Integer(rs.getInt(8)));↵ | |||
20 | // map.put("Archiver", rs.getString(9));↵ | |||
21 | // map.put("Log Switch Wait", rs.getString(10));↵ | |||
22 | // map.put("Logins", rs.getString(11));↵ | |||
23 | // map.put("Shutdown Pending", rs.getString(12));↵ | |||
24 | // map.put("Database Status", rs.getString(13));↵ | |||
25 | // map.put("Instance Role", rs.getString(14));↵ | |||
15 | childNodes.add(new ObjectTreeNode(session, doi));↵ | 26 | childNodes.add(new ObjectTreeNode(session, doi));↵ | |
16 | }↵ | |||
17 | }↵ | |||
18 | finally↵ | |||
19 | {↵ | |||
20 | ↵ | 27 | }↵ | |
28 | } finally↵ | |||
29 | {↵ | |||
21 | SQLUtilities.closeStatement(pstmt);↵ | 30 | SQLUtilities.close↵ | |
22 | ↵ | 31 | ResultSet(rs, true);↵ | |
23 | } | 32 | } | |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 0 |
Number of non-refactorable cases | 1 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.5 |
Clones location | Clones are in different classes |
Number of node comparisons | 18 |
Number of mapped statements | 7 |
Number of unmapped statements in the first code fragment | 0 |
Number of unmapped statements in the second code fragment | 0 |
Time elapsed for statement mapping (ms) | 19.9 |
Clone type | Type 2 |
ID | Statement | ID | Statement | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | try |
| 6 | try | |||||||||||||||||||||
6 | pstmt = conn.prepareStatement(ALL_INDICES_SQL); |
| 7 | pstmt = conn.prepareStatement(SQL); | |||||||||||||||||||||
7 | final ResultSet rs = pstmt.executeQuery(); | 8 | rs = pstmt.executeQuery(); | ||||||||||||||||||||||
8 | while (rs.next()) | 9 | while (rs.next()) | ||||||||||||||||||||||
9 | IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, null, rs.getString(1), DatabaseObjectType.INDEX, md); |
| 10 | IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, null, rs.getString(1), IObjectTypes.INSTANCE, md); | |||||||||||||||||||||
10 | childNodes.add(new ObjectTreeNode(session, doi)); | 11 | childNodes.add(new ObjectTreeNode(session, doi)); |
Row | Violation |
---|---|
1 | Expression SQLUtilities.closeStatement(pstmt) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
2 | Expression SQLUtilities.closeResultSet(rs,true) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression SQLUtilities.closeStatement(pstmt) is a void method call, and thus it cannot be parameterized |
4 | Expression SQLUtilities.closeResultSet(rs,true) is a void method call, and thus it cannot be parameterized |
5 | Expression SQLUtilities.closeStatement(pstmt) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
6 | Expression SQLUtilities.closeResultSet(rs,true) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
7 | Expression SQLUtilities.closeStatement(pstmt) is a void method call, and thus it cannot be parameterized |
8 | Expression SQLUtilities.closeResultSet(rs,true) is a void method call, and thus it cannot be parameterized |
9 | Type net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType does not match with type net.sourceforge.squirrel_sql.plugins.oracle.IObjectTypes |