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
|