Package org.xmlBlaster.contrib.replication

Examples of org.xmlBlaster.contrib.replication.TableToWatchInfo

176
177
178
179
180
181
182
183
184
185
186
187
188
         boolean doWarn = false;
         boolean force = true;
         dbSpecific.bootstrap(conn, doWarn, force);
         String destination = null;
         boolean forceSend = false;
         TableToWatchInfo tableToWatch = new TableToWatchInfo(" ", specificHelper.getOwnSchema(dbPool), this.tableName);
         tableToWatch.setActions("");
         tableToWatch.setTrigger("DUMMY");
         dbSpecific.addTableToWatch(tableToWatch, false, new String[] { destination }, forceSend);
      }
      catch (Exception ex) {
         if (conn != null)
            dbPool.release(conn);
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
235
            log.fine("parsed message: " + msg1);
            int numOfCols = dbUpdateInfo.getDescription().getColumns().length;
            assertTrue("Number of columns must be at least one (to detect that metadata is retrieved)", numOfCols > 0);
            assertXMLEqual("Parsing of message is working correctly: output xml is not the same as input xml", msg, msg1);

            TableToWatchInfo tableToWatch = new TableToWatchInfo();
            tableToWatch.setActions("IDU");
            String functionAndTrigger = dbSpecific.createTableTrigger(dbUpdateInfo.getDescription(), tableToWatch);
           
            log.fine("-- ---------------------------------------------------------------------------");
            log.fine(functionAndTrigger);
            log.fine("-- ---------------------------------------------------------------------------");
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
154
         boolean doWarn = false;
         boolean force = true;
         this.dbSpecific.bootstrap(conn, doWarn, force);
         String destination = null;
         boolean forceSend = false;
         TableToWatchInfo tableToWatch = new TableToWatchInfo(null, this.specificHelper.getOwnSchema(this.pool), this.dbHelper.getIdentifier(this.tableName));
         tableToWatch.setActions("IDU");
         this.dbSpecific.addTableToWatch(tableToWatch, false, new String[] { destination }, forceSend);
      }
      catch (Exception ex) {
         log.warning(ex.getMessage());
         if (conn != null)
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
668
669
         {
            sql = "{? = call " + this.replPrefix + "add_table(?,?,?,?)}"; // name text, content text)
            try {
               boolean force = false;
               boolean forceSend = false;
               TableToWatchInfo tableToWatch = new TableToWatchInfo(null, this.specificHelper.getOwnSchema(this.pool), "TEST_REPLICATION");
               tableToWatch.setActions("");
               tableToWatch.setTrigger(null);
               this.dbSpecific.addTableToWatch(tableToWatch, force, null, forceSend);
               CallableStatement st = conn.prepareCall(sql);
               st.setString(2, null);
               st.setString(3, this.specificHelper.getOwnSchema(this.pool));
               st.setString(4, "TEST_REPLICATION");
View Full Code Here
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
      if (doReplicate)
         flags = "IDU";
      boolean force = false;
      String destination = null;
      boolean forceSend = false;
      TableToWatchInfo tableToWatch = new TableToWatchInfo(catalog, schema, tableName);
      tableToWatch.setActions(flags);
      tableToWatch.setTrigger(null);
      this.dbSpecific.addTableToWatch(tableToWatch, force, new String[] { destination }, forceSend);
      Statement st = conn.createStatement();
      ResultSet rs = st.executeQuery("SELECT * from " + this.replPrefix + "tables WHERE tablename='" + this.dbHelper.getIdentifier(tableName) + "'");
      assertTrue("testing '" + tableName + "' went wrong since no entries found", rs.next());
      String name = rs.getString(3);
View Full Code Here
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
         // add the tables to be detected to the repl_tables table
         boolean force = false;
         String destination = null;
         boolean forceSend = false;

         TableToWatchInfo tableToWatch = new TableToWatchInfo(null, this.specificHelper.getOwnSchema(pool), tableName);
         tableToWatch.setActions("IDU");
         tableToWatch.setTrigger(null);
         this.dbSpecific.addTableToWatch(tableToWatch, force, new String[] { destination }, forceSend);
        
         // force a call to the function which detects CREATE / DROP / ALTER operations: writes on repl_items
         this.dbSpecific.forceTableChangeCheck();
View Full Code Here
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
         // add the tables to be detected to the repl_tables table
         boolean force = false;
         String destination = null;
         boolean forceSend = false;
         TableToWatchInfo tableToWatch = new TableToWatchInfo(null, this.specificHelper.getOwnSchema(pool), tableName);
         tableToWatch.setActions("IDU");
         tableToWatch.setTrigger(null);
         this.dbSpecific.addTableToWatch(tableToWatch, force, new String[] { destination }, forceSend);

         // check that nothing has been written in repl_items
         Statement st = conn.createStatement();
         ResultSet rs = st.executeQuery("SELECT * from " + this.replPrefix + "items");
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
275
         String sql = null;
         try {
            boolean force = false;
            String destination = null;
            boolean forceSend = false;
            TableToWatchInfo tableToWatch = new TableToWatchInfo(null, this.specificHelper.getOwnSchema(pool), tableName);
            tableToWatch.setActions("IDU");
            getDbSpecific().addTableToWatch(tableToWatch, force, new String[] { destination }, forceSend);
         }
         catch (Exception ex) {
            ex.printStackTrace();
            assertTrue("Testing if addition of table '" + tableName + "' to tables to replicate (" + this.replPrefix + "tables) succeeded: An exception should not occur here", false);
View Full Code Here
412
413
414
415
416
417
418
419
420
421
422
423
         String sql = null;
         try {
            boolean force = false;
            String destination = null;
            boolean forceSend = false;
            TableToWatchInfo tableToWatch = new TableToWatchInfo(null, this.specificHelper.getOwnSchema(pool), tableName);
            tableToWatch.setActions("IDU");
            getDbSpecific().addTableToWatch(tableToWatch, force, new String[] { destination }, forceSend);
         }
         catch (Exception ex) {
            ex.printStackTrace();
            assertTrue("Testing if addition of table '" + tableName + "' to tables to replicate (" + this.replPrefix + "tables) succeeded: An exception should not occur here", false);
View Full Code Here
810
811
812
813
814
815
816
817
818
819
820
  
   /**
    * @see org.xmlBlaster.contrib.replication.I_DbSpecific#addTrigger(java.sql.Connection, java.lang.String, java.lang.String, java.lang.String, org.xmlBlaster.contrib.dbwriter.info.SqlInfo)
    */
   public void addTrigger(Connection conn, String catalog, String schema, String tableName) throws Exception {
      TableToWatchInfo tableToWatch = getTableToWatch(conn, catalog, schema, tableName);
      SqlInfo sqlInfo = new SqlInfo(this.info);
      if (sqlInfo.fillMetadata(conn, catalog, schema, tableName, null, null)) {
         final boolean force = true;
         addTrigger(conn, tableToWatch, sqlInfo, force);
      }
View Full Code Here
TOP

Related Classes of org.xmlBlaster.contrib.replication.TableToWatchInfo

  • org.xmlBlaster.contrib.dbwriter.info.SqlColumn
  • org.xmlBlaster.contrib.dbwriter.info.SqlDescription
  • org.xmlBlaster.contrib.dbwriter.info.SqlInfo
  • org.xmlBlaster.contrib.I_Info
  • org.xmlBlaster.contrib.PropertiesInfo
  • org.xmlBlaster.contrib.replication.impl.SpecificDefault
  • org.xmlBlaster.test.contrib.replication.TestDbBasics
  • org.xmlBlaster.test.contrib.replication.TestDbSpecific
  • org.xmlBlaster.test.contrib.replication.TestHelperClasses
  • org.xmlBlaster.test.contrib.replication.TestReplication
    • 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.