CloneSet669


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
21220.978statement_sequence[2]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
13078
E:/TSE/Projects-CloneDR/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/InstanceParentExpander.java
22177
E:/TSE/Projects-CloneDR/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/SessionParentExpander.java
Next
Last
Clone Instance
1
Line Count
30
Source Line
78
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/InstanceParentExpander.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;


First
Previous
Clone Instance
2
Line Count
21
Source Line
77
Source File
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()) {
    // 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;


Clone AbstractionParameter Count: 2Parameter Bindings

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 Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1cc251c0]]
null 
12[[#1cc251c0]]
schemaName 
21[[#1cc251e0]]
INSTANCE 
22[[#1cc251e0]]
SESSION