public class SequenceDetailsTab extends BasePreparedStatementTab { private static final StringManager s_stringMgr = StringManagerFactory.getStringManager(SequenceDetailsTab.class); /** Logger for this class. */ private final static ILogger s_log = LoggerController.createLogger(SequenceDetailsTab.class); /** * This interface defines locale specific strings. This should be * replaced with a property file. */ private interface i18n { // i18n[SequenceDetailsTab.title=Details] String TITLE = s_stringMgr.getString("SequenceDetailsTab.title"); // i18n[SequenceDetailsTab.hint=Display sequence details] String HINT = s_stringMgr.getString("SequenceDetailsTab.hint"); } /** SQL that retrieves the data. */ private static final String SQL = "SELECT SEQUENCE_CATALOG,SEQUENCE_SCHEMA, " + "CURRENT_VALUE,INCREMENT,IS_GENERATED,REMARKS " + "FROM INFORMATION_SCHEMA.SEQUENCES " + "WHERE SEQUENCE_SCHEMA = ? " + "AND SEQUENCE_NAME = ? "; public SequenceDetailsTab() { super(i18n.TITLE, i18n.HINT, true); } protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); if (s_log.isDebugEnabled()) { s_log.debug("Sequence details SQL: "+SQL); s_log.debug("Sequence schema: "+doi.getSchemaName()); s_log.debug("Sequence name: "+doi.getSimpleName()); } PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt;
public class TriggerDetailsTab extends BasePreparedStatementTab { private static final StringManager s_stringMgr = StringManagerFactory.getStringManager(TriggerDetailsTab.class); /** * This interface defines locale specific strings. This should be * replaced with a property file. */ private interface i18n { // i18n[TriggerDetailsTab.title=Details] String TITLE = s_stringMgr.getString("TriggerDetailsTab.title"); // i18n[TriggerDetailsTab.hint=Display trigger details] String HINT = s_stringMgr.getString("TriggerDetailsTab.hint"); } /** SQL that retrieves the data. */ private static String SQL = "SELECT TRIGGER_CATALOG,TRIGGER_SCHEMA,TRIGGER_NAME, " + "TRIGGER_TYPE,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME, " + "BEFORE,JAVA_CLASS,QUEUE_SIZE,NO_WAIT,REMARKS,SQL " + "FROM INFORMATION_SCHEMA.TRIGGERS " + "WHERE TABLE_SCHEMA = ? " + "AND TRIGGER_NAME = ? "; /** Logger for this class. */ private final static ILogger s_log = LoggerController.createLogger(TriggerDetailsTab.class); public TriggerDetailsTab() { super(i18n.TITLE, i18n.HINT, true); } protected PreparedStatement createStatement() throws SQLException { ISession session = getSession(); IDatabaseObjectInfo doi = getDatabaseObjectInfo(); if (s_log.isDebugEnabled()) { s_log.debug("Trigger details SQL: "+SQL); s_log.debug("Trigger schema: "+doi.getSchemaName()); s_log.debug("Trigger name: "+doi.getSimpleName()); } PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt;
Clone fragments detected by clone detection tool
File path: /sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/SequenceDetailsTab.java File path: /sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/TriggerDetailsTab.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public class SequenceDetailsTab extends BasePreparedStatementTab
1
public class TriggerDetailsTab extends BasePreparedStatementTab
2
{
2
{
3
	private static final StringManager s_stringMgr =
3
	private static final StringManager s_stringMgr =
4
		StringManagerFactory.getStringManager(SequenceDetailsTab.class);
4
		StringManagerFactory.getStringManager(
5
    /** Logger for this class. */
6
    private final static ILogger s_log =
7
        LoggerController.createLogger(SequenceDetailsTab.class);
5
TriggerDetailsTab.class);
8
	/**
6
	/**
9
	 * This interface defines locale specific strings. This should be
7
	 * This interface defines locale specific strings. This should be
10
	 * replaced with a property file.
8
	 * replaced with a property file.
11
	 */
9
	 */
12
	private interface i18n
10
	private interface i18n
13
	{
11
	{
14
		// i18n[SequenceDetailsTab.title=Details]
12
		// i18n[TriggerDetailsTab.title=Details]
15
		String TITLE = s_stringMgr.getString("SequenceDetailsTab.title");
13
		String TITLE = s_stringMgr.getString("TriggerDetailsTab.title");
16
		// i18n[SequenceDetailsTab.hint=Display sequence details]
14
		// i18n[TriggerDetailsTab.hint=Display trigger details]
17
		String HINT = s_stringMgr.getString("SequenceDetailsTab.hint");
15
		String HINT = s_stringMgr.getString("TriggerDetailsTab.hint");
18
	}
16
	}
19
	/** SQL that retrieves the data. */
17
	/** SQL that retrieves the data. */
20
	private static final String SQL =
18
	private static String SQL =
21
        "SELECT SEQUENCE_CATALOG,SEQUENCE_SCHEMA, " +
19
        "SELECT TRIGGER_CATALOG,
22
        "CURRENT_VALUE,INCREMENT,IS_GENERATED
20
TRIGGER_SCHEMA,TRIGGER_NAME, " +
21
        "TRIGGER_TYPE,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME, " +
23
,REMARKS " +
22
        "BEFORE,JAVA_CLASS,QUEUE_SIZE,NO_WAIT,REMARKS,SQL " +
24
        "FROM INFORMATION_SCHEMA.SEQUENCES " +
23
        "FROM INFORMATION_SCHEMA.TRIGGERS " +
25
        "WHERE SEQUENCE_SCHEMA = ? " +
24
        "WHERE TABLE_SCHEMA = ? " +
26
        "AND SEQUENCE_NAME = ? ";
25
        "AND TRIGGER_NAME = ? ";
27
    
26
    
28
	public Sequence
27
	/** Logger for this class. */
28
	private final static ILogger s_log =
29
		LoggerController.createLogger(TriggerDetailsTab.class);
29
DetailsTab()
30
	public TriggerDetailsTab()
30
	{
31
	{
31
		super(i18n.TITLE, i18n.HINT, true);
32
		super(i18n.TITLE, i18n.HINT, true);
32
	}
33
	}
33
	protected PreparedStatement createStatement() throws SQLException
34
	protected PreparedStatement createStatement() throws SQLException
34
	{
35
	{
35
		ISession session = getSession();
36
		ISession session = getSession();
36
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
37
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
37
        if (s_log.isDebugEnabled()) {
38
        if (s_log.isDebugEnabled()) {
38
            s_log.debug("Sequence details SQL: "+SQL);
39
            s_log.debug("Trigger details SQL: "+SQL);
39
            s_log.debug("Sequence schema: "+doi.getSchemaName());
40
            s_log.debug("Trigger schema: "+doi.getSchemaName());
40
            s_log.debug("Sequence name: "+doi.getSimpleName());
41
            s_log.debug("Trigger name: "+doi.getSimpleName());
41
        }
42
        }
42
		PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
43
		PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
43
        pstmt.setString(1, doi.getSchemaName());
44
        pstmt.setString(1, doi.getSchemaName());
44
        pstmt.setString(2, doi.getSimpleName());
45
		pstmt.setString(2, doi.getSimpleName());
45
		return pstmt;
46
		return pstmt;
46
	
47
	
Summary
Number of common nesting structure subtrees0
Number of refactorable cases0
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones location
Number of node comparisons0