File path: /sql12/plugins/informix/src/net/sourceforge/squirrel_sql/plugins/informix/tab/ProcedureSourceTab.java | File path: /sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/tab/ObjectSourceTab.java | |||
Method name: PreparedStatement createStatement()
|
Method name: PreparedStatement createStatement()
|
|||
Number of AST nodes: 9 | Number of AST nodes: 8 | |||
1 | final ISession session = getSession();↵ | 1 | final ISession session = getSession();↵ | |
2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | 2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | |
3 | if (s_log.isDebugEnabled()) {↵ | |||
4 | s_log.debug("Running SQL: "+SQL);↵ | |||
5 | s_log.debug("procname="+doi.getSimpleName());↵ | |||
6 | }↵ | |||
7 | ISQLConnection conn = session.getSQLConnection();↵ | 3 | ISQLConnection conn = session.getSQLConnection();↵ | |
8 | PreparedStatement pstmt = conn.prepareStatement(SQL);↵ | 4 | PreparedStatement pstmt = conn.prepareStatement(SQL);↵ | |
9 | pstmt.setString(1,↵ | 5 | pstmt.setString(1, ObjectSourceTab.this._columnData);↵ | |
6 | pstmt.setString(2, doi.getSchemaName());↵ | |||
10 | doi.getSimpleName());↵ | 7 | pstmt.setString(3, doi.getSimpleName());↵ | |
11 | return pstmt; | 8 |
| |
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.0 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 48 |
Number of mapped statements | 6 |
Number of unmapped statements in the first code fragment | 0 |
Number of unmapped statements in the second code fragment | 2 |
Time elapsed for statement mapping (ms) | 0.0 |
Clone type | Type 3 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | final ISession session = getSession(); | 1 | final ISession session = getSession(); | |||||||||||
2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | 2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | |||||||||||
6 | ISQLConnection conn = session.getSQLConnection(); | 3 | ISQLConnection conn = session.getSQLConnection(); | |||||||||||
7 | PreparedStatement pstmt = conn.prepareStatement(SQL); | 4 | PreparedStatement pstmt = conn.prepareStatement(SQL); | |||||||||||
|
| 5 | pstmt.setString(1, ObjectSourceTab.this._columnData); | |||||||||||
|
| 6 | pstmt.setString(2, doi.getSchemaName()); | |||||||||||
8 | pstmt.setString(1, doi.getSimpleName()); |
| 7 | pstmt.setString(3, doi.getSimpleName()); | ||||||||||
9 | return pstmt; | 8 | return pstmt; |
Row | Violation |
---|---|
1 | Unmatched statement pstmt.setString(1,ObjectSourceTab.this._columnData); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
2 | Unmatched statement pstmt.setString(2,doi.getSchemaName()); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
3 | Clone fragment #1 returns variables doi , while Clone fragment #2 returns variables |