File path: /sql12/plugins/derby/src/net/sourceforge/squirrel_sql/plugins/derby/tab/TriggerDetailsTab.java | File path: /sql12/plugins/mysql/src/net/sourceforge/squirrel_sql/plugins/mysql/tab/MysqlTriggerDetailsTab.java | |||
Method name: PreparedStatement createStatement()
|
Method name: PreparedStatement createStatement()
|
|||
Number of AST nodes: 10 | Number of AST nodes: 10 | |||
1 | ISession session = getSession();↵ | 1 | ISession session = getSession();↵ | |
2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | 2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | |
3 | if (s_log.isDebugEnabled()) {↵ | 3 | if (s_log.isDebugEnabled()) {↵ | |
4 | s_log.debug("Trigger details SQL: "+SQL);↵ | 4 | s_log.debug("Trigger details SQL: "+SQL);↵ | |
5 | s_log.debug("Trigger name: "+doi.getSimpleName());↵ | 5 | s_log.debug("Trigger catalog: "+doi.getCatalogName());↵ | |
6 | s_log.debug("Trigger schema: "+doi.getSchemaName());↵ | 6 | s_log.debug("Trigger name: "+doi.getSimpleName());↵ | |
7 | }↵ | 7 | }↵ | |
8 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);↵ | 8 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);↵ | |
9 | pstmt.setString(1, doi.getSimpleName());↵ | 9 | pstmt.setString(1, doi.getCatalogName());↵ | |
10 | pstmt.setString(2, doi.getSchemaName());↵ | 10 | pstmt.setString(2, doi.getSimpleName());↵ | |
11 | return pstmt; | 11 |
| |
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) | 0.2 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 52 |
Number of mapped statements | 10 |
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) | 76.3 |
Clone type | Type 2 |
ID | Statement | ID | Statement | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ISession session = getSession(); | 1 | ISession session = getSession(); | ||||||||||||||||
2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | 2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | ||||||||||||||||
3 | if (s_log.isDebugEnabled()) | 3 | if (s_log.isDebugEnabled()) | ||||||||||||||||
4 | s_log.debug("Trigger details SQL: " + SQL); | 4 | s_log.debug("Trigger details SQL: " + SQL); | ||||||||||||||||
5 | s_log.debug("Trigger name: " + doi.getSimpleName()); | 6 | s_log.debug("Trigger name: " + doi.getSimpleName()); | ||||||||||||||||
6 | s_log.debug("Trigger schema: " + doi.getSchemaName()); |
| 5 | s_log.debug("Trigger catalog: " + doi.getCatalogName()); | |||||||||||||||
7 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); | 7 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); | ||||||||||||||||
8 | pstmt.setString(1, doi.getSimpleName()); |
| 9 | pstmt.setString(2, doi.getSimpleName()); | |||||||||||||||
9 | pstmt.setString(2, doi.getSchemaName()); |
| 8 | pstmt.setString(1, doi.getCatalogName()); | |||||||||||||||
10 | return pstmt; | 10 | return pstmt; |
Row | Violation |
---|---|
1 | Expression doi.getSchemaName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
2 | Expression doi.getCatalogName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression doi.getSchemaName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
4 | Expression doi.getCatalogName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |