File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/tab/SequenceDetailsTab.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 | ↵ | |||
5 | {↵ | |||
10 | s_log.debug("Sequence details SQL: "+sql);↵ | 6 | s_log.debug("ModifySequence↵ | |
11 | s_log.debug("Sequence schema: "+doi.getSchemaName());↵ | |||
12 | s_log.debug("Sequence name: "+doi.getSimpl↵ | 7 | Command: running sql=" + sql);↵ | |
13 | eName());↵ | 8 | s_log.debug("param sequenceName = " + sequenceName↵ | |
14 | } ↵ | |||
9 | );↵ | |||
10 | }↵ | |||
15 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(sql);↵ | 11 | PreparedStatement stmt = _session.getSQLConnection().prepareStatement(sql); ↵ | |
16 | pstmt.setString(1, doi.getSchemaName());↵ | 12 | stmt.setString(1, sequenceName); ↵ | |
17 | pstmt.setString(2, doi.getSimpleName());↵ | 13 | result = stmt.executeQuery();↵ | |
14 | } else↵ | |||
15 | {↵ | |||
16 | s_log.debug("ModifySequenceCommand: running sql=" + sql);↵ | |||
17 | Statement stmt = _session.getSQLConnection().createStatement();↵ | |||
18 | result = stmt.executeQuery(sql);↵ | |||
19 | } ↵ | |||
18 | return pstmt; | 20 | return result; | |
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) | 1.1 |
Clones location | Clones are in different classes |
Number of node comparisons | 7 |
Number of mapped statements | 1 |
Number of unmapped statements in the first code fragment | 4 |
Number of unmapped statements in the second code fragment | 2 |
Time elapsed for statement mapping (ms) | 26.2 |
Clone type | Type 3 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ISession session = getSession(); | | ||||||||||||
2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | | ||||||||||||
3 | String sql = SQL; | | ||||||||||||
4 | if (isOS400) |
| 3 | if (s_log.isDebugEnabled()) | ||||||||||
|
| 4 | s_log.debug("ModifySequenceCommand: running sql=" + sql); | |||||||||||
|
| 5 | s_log.debug("param sequenceName = " + sequenceName); | |||||||||||
5 | sql = OS_400_SQL; | |
Row | Violation |
---|---|
1 | 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 |
2 | 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 |
3 | The refactoring of the clones is infeasible, because the number of macthed statements is equal to zero |