Package jp.co.ntt.oss

Examples of jp.co.ntt.oss.SyncDatabaseException

25
26
27
28
29
30
31
32
33
34
35
  public static final int MLOG_RECORD_NOT_FOUND = -1;

  public static String getTablePrint(final String schema, final String table)
      throws SyncDatabaseException {
    if (table == null) {
      throw new SyncDatabaseException("error.argument");
    }

    if (schema == null) {
      return table;
    }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
  public static Subscription getSubscription(final Connection conn,
      final String schema, final String table) throws SQLException,
      SyncDatabaseException {
    if (conn == null || schema == null || table == null) {
      throw new SyncDatabaseException("error.argument");
    }

    PreparedStatement pstmt = null;
    ResultSet rset = null;

    try {
      pstmt = conn.prepareStatement("SELECT * "
          + "FROM observer.v$subscription "
          + "WHERE nspname = ? AND relname = ?");
      pstmt.setString(1, schema);
      pstmt.setString(2, table);
      rset = pstmt.executeQuery();

      // not found
      if (!rset.next()) {
        throw new SyncDatabaseException("error.no_subscription",
            SyncDatabaseDAO.getTablePrint(schema, table));
      }

      return new Subscription(rset.getString(SUBSCRIPTION_NSPNAME), rset
          .getString(SUBSCRIPTION_RELNAME), rset
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
  private static final int SET_SUBSCRIPTION_LAST_TYPE = 3;

  public static void setSubscription(final Connection conn,
      final Subscription subs) throws SQLException, SyncDatabaseException {
    if (conn == null || subs == null) {
      throw new SyncDatabaseException("error.argument");
    }

    CallableStatement cstmt = null;

    try {
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
  private static final int SUBSCRIBER_LASTCOUNT = 12;

  public static Subscriber getSubscriber(final Connection conn,
      final long subsID) throws SQLException, SyncDatabaseException {
    if (conn == null) {
      throw new SyncDatabaseException("error.argument");
    }

    PreparedStatement pstmt = null;
    ResultSet rset = null;

    try {
      pstmt = conn.prepareStatement("SELECT * FROM mlog.v$subscriber "
          + "WHERE subsid = ?");
      pstmt.setLong(1, subsID);
      rset = pstmt.executeQuery();

      // not found
      if (!rset.next()) {
        throw new SyncDatabaseException("error.no_subscriber", subsID);
      }

      return new Subscriber(rset.getLong(SUBSCRIBER_SUBSID), rset
          .getString(SUBSCRIBER_NSPNAME), rset
          .getString(SUBSCRIBER_RELNAME), rset
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
  private static final int SET_SUBSCRIBER_LAST_COUNT = 4;

  public static void setSubscriber(final Connection conn,
      final Subscriber suber) throws SQLException, SyncDatabaseException {
    if (conn == null || suber == null) {
      throw new SyncDatabaseException("error.argument");
    }

    CallableStatement cstmt = null;

    try {
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
  public static ArrayList<MasterStatus> getMasterStatus(
      final Connection conn, final String schema, final String table)
      throws SQLException, SyncDatabaseException {
    if (conn == null) {
      throw new SyncDatabaseException("error.argument");
    }

    PreparedStatement pstmt = null;
    ResultSet rset = null;
View Full Code Here
323
324
325
326
327
328
329
330
331
332
333
  }

  protected static long getLogCount(final Connection conn,
      final String mlogName) throws SyncDatabaseException, SQLException {
    if (conn == null) {
      throw new SyncDatabaseException("error.argument");
    }

    if (mlogName == null) {
      return MasterStatus.INVALID_LOG_COUNT;
    }
View Full Code Here
391
392
393
394
395
396
397
398
399
400
401
  public static ArrayList<ReplicaStatus> getReplicaStatus(
      final Connection conn, final String schema, final String table)
      throws SQLException, SyncDatabaseException {
    if (conn == null) {
      throw new SyncDatabaseException("error.argument");
    }

    PreparedStatement pstmt = null;
    ResultSet rset = null;
View Full Code Here
457
458
459
460
461
462
463
464
465
466
467
  }

  public static long getMaxMlogID(final Connection conn, final String mlogName)
      throws SQLException, SyncDatabaseException {
    if (conn == null || mlogName == null) {
      throw new SyncDatabaseException("error.argument");
    }

    Statement stmt = null;
    ResultSet rset = null;
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
  public static Hashtable<Short, String> getPKNames(final Connection conn,
      final String schema, final String table) throws SQLException,
      SyncDatabaseException {
    if (conn == null || schema == null || table == null) {
      throw new SyncDatabaseException("error.argument");
    }

    // get replica table primary key definition
    final DatabaseMetaData dmd = conn.getMetaData();
    ResultSet rset = null;
View Full Code Here
TOP

Related Classes of jp.co.ntt.oss.SyncDatabaseException

  • jp.co.ntt.oss.data.DatabaseResource
  • jp.co.ntt.oss.data.JdbcResource
  • jp.co.ntt.oss.data.SyncDatabaseDAO
  • jp.co.ntt.oss.mapper.MappingData
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.