Previous CloneSet | Next CloneSet | Back to Main Report |
Clone Mass | Clones in CloneSet | Parameter Count | Clone Similarity | Syntax Category [Sequence Length] |
---|---|---|---|---|
21 | 2 | 2 | 0.978 | statement_sequence[2] |
Clone Abstraction | Parameter Bindings |
Clone Instance (Click to see clone) | Line Count | Source Line | Source File |
---|---|---|---|
1 | 30 | 78 | E:/TSE/Projects-CloneDR/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/InstanceParentExpander.java |
2 | 21 | 77 | E:/TSE/Projects-CloneDR/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/SessionParentExpander.java |
| |||||
try { pstmt = conn.prepareStatement(SQL); rs = pstmt.executeQuery(); while (rs.next()) { IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, null, rs.getString(1), IObjectTypes.INSTANCE, md); // final Map map = new HashMap(); // map.put("Instance Number", new Integer(rs.getInt(1))); // map.put("Name", rs.getString(2)); // map.put("Host Name", rs.getString(3)); // map.put("Version", rs.getString(4)); // map.put("Startup Time", rs.getDate(5)); // map.put("Instance Status", rs.getString(6)); // map.put("Parallel", rs.getString(7)); // map.put("Thread #", new Integer(rs.getInt(8))); // map.put("Archiver", rs.getString(9)); // map.put("Log Switch Wait", rs.getString(10)); // map.put("Logins", rs.getString(11)); // map.put("Shutdown Pending", rs.getString(12)); // map.put("Database Status", rs.getString(13)); // map.put("Instance Role", rs.getString(14)); childNodes.add(new ObjectTreeNode(session, doi)); } } finally { SQLUtilities.closeResultSet(rs, true); } return childNodes; |
| |||||
try { pstmt = conn.prepareStatement(SQL); rs = pstmt.executeQuery(); while (rs.next()) { // There is a reason that we don't want to use DatabaseObjectType.SESSION here. The "session" // nodes that this expander is creating should not be confused with the SQuirreL session. These // session nodes are Oracle sessions that an administrator has the privileges to see. So we // must not use DatabaseObjectType.SESSION, or else these nodes get expanded with the database // DefaultdatabasExpander. IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, schemaName, rs.getString(1), IObjectTypes.SESSION, md); childNodes.add(new ObjectTreeNode(session, doi)); } } finally { SQLUtilities.closeResultSet(rs, true); } return childNodes; |
| |||
try { pstmt = conn.prepareStatement(SQL); rs = pstmt.executeQuery(); while (rs.next()) { // There is a reason that we don't want to use DatabaseObjectType.SESSION here. The "session" // nodes that this expander is creating should not be confused with the SQuirreL session. These // session nodes are Oracle sessions that an administrator has the privileges to see. So we // must not use DatabaseObjectType.SESSION, or else these nodes get expanded with the database // DefaultdatabasExpander. IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, [[#variable1cc251c0]], rs.getString(1), IObjectTypes. [[#variable1cc251e0]], md); // final Map map = new HashMap(); // map.put("Instance Number", new Integer(rs.getInt(1))); // map.put("Name", rs.getString(2)); // map.put("Host Name", rs.getString(3)); // map.put("Version", rs.getString(4)); // map.put("Startup Time", rs.getDate(5)); // map.put("Instance Status", rs.getString(6)); // map.put("Parallel", rs.getString(7)); // map.put("Thread #", new Integer(rs.getInt(8))); // map.put("Archiver", rs.getString(9)); // map.put("Log Switch Wait", rs.getString(10)); // map.put("Logins", rs.getString(11)); // map.put("Shutdown Pending", rs.getString(12)); // map.put("Database Status", rs.getString(13)); // map.put("Instance Role", rs.getString(14)); childNodes.add(new ObjectTreeNode(session, doi)); } } finally { SQLUtilities.closeResultSet(rs, true); } return childNodes; |
CloneAbstraction |
Parameter Index | Clone Instance | Parameter Name | Value |
---|---|---|---|
1 | 1 | [[#1cc251c0]] | null |
1 | 2 | [[#1cc251c0]] | schemaName |
2 | 1 | [[#1cc251e0]] | INSTANCE |
2 | 2 | [[#1cc251e0]] | SESSION |