CloneSet121


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
15430.978method_declaration
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
11551
E:/TSE/Projects-CloneDR/sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/TriggerSourceTab.java
21652
E:/TSE/Projects-CloneDR/sql12/plugins/mysql/src/net/sourceforge/squirrel_sql/plugins/mysql/tab/MysqlProcedureSourceTab.java
31853
E:/TSE/Projects-CloneDR/sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/tab/ProcedureSourceTab.java
41595
E:/TSE/Projects-CloneDR/sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/tab/TriggerSourceTab.java
Next
Last
Clone Instance
1
Line Count
15
Source Line
51
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/TriggerSourceTab.java

protected PreparedStatement createStatement() throws SQLException {
  final ISession session = getSession();
  final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
  if (s_log.isDebugEnabled()) {
    s_log.debug("Running SQL: " + SQL);
    s_log.debug("schema=" + doi.getSchemaName());
    s_log.debug("trigname=" + doi.getSimpleName());
  }
  ISQLConnection conn = session.getSQLConnection();
  PreparedStatement pstmt = conn.prepareStatement(SQL);
  pstmt.setString(1, doi.getSchemaName());
  pstmt.setString(2, doi.getSimpleName());
  return pstmt;
}


Next
Previous
Clone Instance
2
Line Count
16
Source Line
52
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/mysql/src/net/sourceforge/squirrel_sql/plugins/mysql/tab/MysqlProcedureSourceTab.java

protected PreparedStatement createStatement() throws SQLException {
  final ISession session = getSession();
  final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
  if (s_log.isDebugEnabled()) {
    s_log.debug("Running SQL for procedure source: " + SQL);
    s_log.debug("schema=" + doi.getCatalogName());
    s_log.debug("procedure name=" + doi.getSimpleName());
  }
  ISQLConnection conn = session.getSQLConnection();
  PreparedStatement pstmt = conn.prepareStatement(SQL);
  pstmt.setString(1, doi.getCatalogName());
  pstmt.setString(2, doi.getSimpleName());
  return pstmt;
}


Next
Previous
Clone Instance
3
Line Count
18
Source Line
53
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/tab/ProcedureSourceTab.java

protected PreparedStatement createStatement() throws SQLException {
  final ISession session = getSession();
  final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
  if (s_log.isDebugEnabled()) {
    s_log.debug("Running SQL for procedure source: " + SQL);
    s_log.debug("schema=" + doi.getSchemaName());
    s_log.debug("procedure name=" + doi.getSimpleName());
  }
  ISQLConnection conn = session.getSQLConnection();
  PreparedStatement pstmt = conn.prepareStatement(SQL);
  // Postgres pg_proc table doesn't appear to have schema.  I couldn't
  // locate another table to join with to get this info either.
  pstmt.setString(1, doi.getSchemaName());
  pstmt.setString(2, doi.getSimpleName());
  return pstmt;
}


First
Previous
Clone Instance
4
Line Count
15
Source Line
95
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/tab/TriggerSourceTab.java

protected PreparedStatement createStatement() throws SQLException {
  final ISession session = getSession();
  final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
  if (s_log.isDebugEnabled()) {
    s_log.debug("Running SQL: " + SQL);
    s_log.debug("schema=" + doi.getSchemaName());
    s_log.debug("trigname=" + doi.getSimpleName());
  }
  ISQLConnection conn = session.getSQLConnection();
  PreparedStatement pstmt = conn.prepareStatement(SQL);
  pstmt.setString(1, doi.getSchemaName());
  pstmt.setString(2, doi.getSimpleName());
  return pstmt;
}


Clone AbstractionParameter Count: 3Parameter Bindings

protected PreparedStatement createStatement() throws SQLException {
  final ISession session = getSession();
  final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
  if (s_log.isDebugEnabled()) {
    s_log.debug( [[#variable1af45c60]] + SQL);
    s_log.debug("schema=" + doi. [[#variable1af45bc0]]());
    s_log.debug( [[#variable1af45b40]] + doi.getSimpleName());
  }
  ISQLConnection conn = session.getSQLConnection();
  PreparedStatement pstmt = conn.prepareStatement(SQL);
  // Postgres pg_proc table doesn't appear to have schema.  I couldn't
  // locate another table to join with to get this info either.
  pstmt.setString(1, doi. [[#variable1af45bc0]]());
  pstmt.setString(2, doi.getSimpleName());
  return pstmt;
}
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1af45c60]]
"Running SQL: " 
12[[#1af45c60]]
"Running SQL for procedure source: " 
13[[#1af45c60]]
"Running SQL for procedure source: " 
14[[#1af45c60]]
"Running SQL: " 
21[[#1af45bc0]]
getSchemaName 
22[[#1af45bc0]]
getCatalogName 
23[[#1af45bc0]]
getSchemaName 
24[[#1af45bc0]]
getSchemaName 
31[[#1af45b40]]
"trigname=" 
32[[#1af45b40]]
"procedure name=" 
33[[#1af45b40]]
"procedure name=" 
34[[#1af45b40]]
"trigname="