File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/tab/ProcedureSourceTab.java | File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/tab/ViewSourceTab.java | |||
Method name: PreparedStatement createStatement()
|
Method name: PreparedStatement createStatement()
|
|||
Number of AST nodes: 14 | Number of AST nodes: 14 | |||
1 | final ISession session = getSession();↵ | 1 | final ISession session = getSession();↵ | |
2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | 2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | |
3 | ISQLConnection conn = session.getSQLConnection();↵ | |||
3 | String sql = SQL;↵ | 4 | String sql = SQL;↵ | |
4 | if (isOS400) {↵ | 5 | if (isOS400) {↵ | |
5 | sql = OS_400_SQL;↵ | 6 | sql = OS_400_SQL;↵ | |
6 | }↵ | 7 | } ↵ | |
7 | if (s_log.isDebugEnabled()) {↵ | 8 | if (s_log.isDebugEnabled()) {↵ | |
8 | s_log.debug("Running SQL for procedure source: "+sql);↵ | 9 | s_log.debug("Running SQL for View source tab: "+sql);↵ | |
9 | s_log.debug("schema="+doi.getSchemaName());↵ | 10 | s_log.debug("schema="+doi.getSchemaName());↵ | |
10 | s_log.debug("procedure name="+doi.getSimpleName());↵ | 11 | s_log.debug("view name="+doi.getSimpleName());↵ | |
11 | }↵ | 12 | ↵ | |
12 | ISQLConnection conn = session.getSQLConnection();↵ | |||
13 | }↵ | |||
13 | PreparedStatement pstmt = conn.prepareStatement(sql);↵ | 14 | PreparedStatement pstmt = conn.prepareStatement(sql);↵ | |
14 | pstmt.setString(1, doi.getSchemaName());↵ | 15 | pstmt.setString(1, doi.getSchemaName());↵ | |
15 | pstmt.setString(2, doi.getSimpleName());↵ | 16 | pstmt.setString(2, doi.getSimpleName());↵ | |
16 | return pstmt; | 17 |
| |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 1 |
Number of non-refactorable cases | 0 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 1.5 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 93 |
Number of mapped statements | 14 |
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) | 6.0 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | final ISession session = getSession(); | 1 | final ISession session = getSession(); | |||||||||||
2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | 2 | final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | |||||||||||
3 | String sql = SQL; | 4 | String sql = SQL; | |||||||||||
4 | if (isOS400) | 5 | if (isOS400) | |||||||||||
5 | sql = OS_400_SQL; | 6 | sql = OS_400_SQL; | |||||||||||
6 | if (s_log.isDebugEnabled()) | 7 | if (s_log.isDebugEnabled()) | |||||||||||
7 | s_log.debug("Running SQL for procedure source: " + sql); |
| 8 | s_log.debug("Running SQL for View source tab: " + sql); | ||||||||||
8 | s_log.debug("schema=" + doi.getSchemaName()); | 9 | s_log.debug("schema=" + doi.getSchemaName()); | |||||||||||
9 | s_log.debug("procedure name=" + doi.getSimpleName()); |
| 10 | s_log.debug("view name=" + doi.getSimpleName()); | ||||||||||
10 | ISQLConnection conn = session.getSQLConnection(); | 3 | ISQLConnection conn = session.getSQLConnection(); | |||||||||||
11 | PreparedStatement pstmt = conn.prepareStatement(sql); | 11 | PreparedStatement pstmt = conn.prepareStatement(sql); | |||||||||||
12 | pstmt.setString(1, doi.getSchemaName()); | 12 | pstmt.setString(1, doi.getSchemaName()); | |||||||||||
13 | pstmt.setString(2, doi.getSimpleName()); | 13 | pstmt.setString(2, doi.getSimpleName()); | |||||||||||
14 | return pstmt; | 14 | return pstmt; |
Row | Violation |
---|