File path: /sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/TriggerSourceTab.java | File path: /sql12/plugins/mysql/src/net/sourceforge/squirrel_sql/plugins/mysql/tab/MysqlViewSourceTab.java | |||
Method name: PreparedStatement createStatement()
|
Method name: PreparedStatement createStatement()
|
|||
Number of AST nodes: 11 | Number of AST nodes: 11 | |||
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 | if (s_log.isDebugEnabled()) {↵ | 4 | if (s_log.isDebugEnabled()) {↵ | |
4 | s_log.debug("Running SQL: "+SQL);↵ | 5 | s_log.debug("Running SQL for View source tab: "+SQL);↵ | |
5 | s_log.debug("schema="+doi.getSchemaName()↵ | 6 | s_log.debug("Binding catalog name "+doi.getCatalogName()+↵ | |
6 | );↵ | 7 | " as first bind value");↵ | |
7 | s_log.debug("trigname="+doi.getSimpleName());↵ | 8 | s_log.debug("Binding table name "+doi.getSimpleName()+↵ | |
8 | }↵ | 9 | ↵ | |
9 | ISQLConnection conn = session.getSQLConnection();↵ | 10 | " as second bind value"); ↵ | |
11 | ↵ | |||
12 | }↵ | |||
10 | PreparedStatement pstmt = conn.prepareStatement(SQL);↵ | 13 | PreparedStatement pstmt = conn.prepareStatement(SQL);↵ | |
14 | ↵ | |||
11 | pstmt.setString(1, doi.getSchemaName());↵ | 15 | pstmt.setString(1, doi.getCatalogName());↵ | |
12 | pstmt.setString(2, doi.getSimpleName());↵ | 16 | pstmt.setString(2, doi.getSimpleName());↵ | |
13 | 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) | 0.1 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 65 |
Number of mapped statements | 11 |
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) | 77.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 | if (s_log.isDebugEnabled()) | 4 | if (s_log.isDebugEnabled()) | |||||||||||||||||||||
4 | s_log.debug("Running SQL: " + SQL); |
| 5 | s_log.debug("Running SQL for View source tab: " + SQL); | ||||||||||||||||||||
5 | s_log.debug("schema=" + doi.getSchemaName()); |
| 7 | s_log.debug("Binding table name " + doi.getSimpleName() + " as second bind value"); | ||||||||||||||||||||
6 | s_log.debug("trigname=" + doi.getSimpleName()); |
| 6 | s_log.debug("Binding catalog name " + doi.getCatalogName() + " as first bind value"); | ||||||||||||||||||||
7 | ISQLConnection conn = session.getSQLConnection(); | 3 | ISQLConnection conn = session.getSQLConnection(); | |||||||||||||||||||||
8 | PreparedStatement pstmt = conn.prepareStatement(SQL); | 8 | PreparedStatement pstmt = conn.prepareStatement(SQL); | |||||||||||||||||||||
9 | pstmt.setString(1, doi.getSchemaName()); |
| 10 | pstmt.setString(2, doi.getSimpleName()); | ||||||||||||||||||||
10 | pstmt.setString(2, doi.getSimpleName()); |
| 9 | pstmt.setString(1, doi.getCatalogName()); | ||||||||||||||||||||
11 | return pstmt; | 11 | 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.getSimpleName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression "schema=" + doi.getSchemaName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
4 | Expression "Binding table name " + doi.getSimpleName() + " as second bind value" cannot be parameterized, because it has dependencies to/from statements that will be extracted |
5 | Expression doi.getSimpleName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
6 | Expression doi.getCatalogName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
7 | Expression "trigname=" + doi.getSimpleName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
8 | Expression "Binding catalog name " + doi.getCatalogName() + " as first bind value" cannot be parameterized, because it has dependencies to/from statements that will be extracted |
9 | Expression doi.getSchemaName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
10 | Expression doi.getSimpleName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
11 | Expression doi.getSimpleName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
12 | Expression doi.getCatalogName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |