Examples of org.xmlBlaster.contrib.db.DbMetaHelper

org.xmlBlaster.contrib.db.DbMetaHelper
DbMetaHelper offers methods which take care of stuff specific to particular databases. For example if a database stores table names in uppercase you don't need to bother about this knowledge. You just pass the name of the table to the method getUnquotedIdentifier and you get back the correct name (if uppercase it will be uppercase). @author Michele Laghi

      boolean forceCreationAndInit = true;
      this.dbSpecific = ReplicationConverter.getDbSpecific(this.info, forceCreationAndInit);
      assertNotNull("the dbSpecific shall not be null", dbSpecific);
      Connection conn = this.pool.reserve();
      try {
         this.dbHelper = new DbMetaHelper(this.pool);
         log.info("setUp: going to cleanup now ...");
         this.dbSpecific.cleanup(conn, false);
         log.info("setUp: cleanup done, going to bootstrap now ...");
         try {
            this.pool.update("DROP TABLE " + this.tableName);

View Full Code Here

      boolean forceCreationAndInit = true;
      this.dbSpecific = ReplicationConverter.getDbSpecific(this.info, forceCreationAndInit);
      assertNotNull("the dbSpecific shall not be null", dbSpecific);
      Connection conn = this.pool.reserve();
      try {
         this.dbHelper = new DbMetaHelper(this.pool);
         log.info("setUp: going to cleanup now ...");
         conn.setAutoCommit(true);
         this.dbSpecific.cleanup(conn, false);
         for (int i=1; i < 5; i++) { // make sure we have deleted all triggers
            try {

View Full Code Here

      // , "org.xmlBlaster.contrib.replication.impl.SpecificOracle";" +
      dbSpecific = setUpDbSpecific(info, dbSpecificName);
      Connection conn = null;
      try {
         conn = dbPool.reserve();
         this.dbHelper = new DbMetaHelper(dbPool);
         this.tableName = this.dbHelper.getIdentifier(this.tableName);
         log.info("setUp: going to cleanup now ...");
         dbSpecific.cleanup(conn, false);
         try {
            dbPool.update("DROP TABLE test_dbspecific");

View Full Code Here

      boolean forceCreationAndInit = true;
      this.dbSpecific = ReplicationConverter.getDbSpecific(this.info, forceCreationAndInit);
      Connection conn = null;
      try {
         conn = dbPool.reserve();
         this.dbHelper = new DbMetaHelper(this.dbPool);
         this.tableName = this.dbHelper.getIdentifier("TEST_WRITER");
         log.info("setUp: going to cleanup now ...");
         this.dbSpecific.cleanup(conn, false);
         log.info("setUp: cleanup done, going to bootstrap now ...");
         boolean doWarn = false;

View Full Code Here


      this.initialUpdater = new InitialUpdater(this);
      this.initialUpdater.init(info);


      this.dbPool = DbWatcher.getDbPool(this.info);
      this.dbMetaHelper = new DbMetaHelper(this.dbPool);
      this.rowsPerMessage = this.info.getInt("replication.maxRowsOnCreate", 250);
      
      if (this.isDbWriteable) {
         Connection conn = this.dbPool.reserve();
         try { // just to check that the configuration  is OK (better soon than later)

View Full Code Here

   }


   public void init(I_Info info) throws Exception {
      log.info("init");
      I_DbPool pool = (I_DbPool)info.getObject(DbWriter.DB_POOL_KEY);
      DbMetaHelper dbHelper = null;
      if (pool == null) {
         log.warning("DefaultMapper.init: the pool has not been configured, please check your '" + DbWriter.DB_POOL_KEY + "' configuration settings");
      }
      else
         dbHelper = new DbMetaHelper(pool);
      doInit(info, dbHelper);
   }

View Full Code Here

    * dbWriter.sqlPrePostStatement.sql.post.delete.${SCHEMA}.${TABLE}
    * 
    */
   public void init(I_Info info) throws Exception {
      I_DbPool dbPool = (I_DbPool)info.getObject("db.pool");
      DbMetaHelper dbMetaHelper = null;
      if (dbPool != null) {
         dbMetaHelper = new DbMetaHelper(dbPool);
      }
      else
         log.warning("The database pool has not been registered ('db.pool')");
      
      this.sqlInsertPre = getCodeMap("dbWriter.sqlPrePostStatement.sql.pre.insert.", info, dbMetaHelper);

View Full Code Here

      String name = readerInfo.get("replication.prefix", "repl_") + ".oldReplKey";
      persistentInfo.put(name, "0");


      Connection conn = null;
      try {
         this.dbHelper = new DbMetaHelper(pool);
         conn = pool.reserve();
         boolean doWarn = false; // we don't want warnings on SQL Exceptions here.
         log.info("setUp: going to cleanup now ...");
         this.sleepDelay = this.readerInfo.getLong("test.sleepDelay", -1L);
         if (this.sleepDelay < 0L)

View Full Code Here

TOP

Related Classes of org.xmlBlaster.contrib.db.DbMetaHelper

org.xmlBlaster.contrib.replication.impl.DefaultMapper

org.xmlBlaster.contrib.replication.impl.SpecificDefault

org.xmlBlaster.contrib.replication.SqlPrePostStatement

org.xmlBlaster.test.contrib.replication.TestDbBasics

org.xmlBlaster.test.contrib.replication.TestDbSpecific

org.xmlBlaster.test.contrib.replication.TestReplication

org.xmlBlaster.test.contrib.replication.TestReplicationWriter

org.xmlBlaster.test.contrib.replication.TestSyncPart

java.sql.ResultSet

java.util.TreeMap

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.