Examples of org.xmlBlaster.contrib.dbwriter.info.SqlInfo.fillMetadata()

Package org.xmlBlaster.contrib.dbwriter.info

Class org.xmlBlaster.contrib.dbwriter.info.SqlInfo

Examples of org.xmlBlaster.contrib.dbwriter.info.SqlInfo.fillMetadata()

org.xmlBlaster.contrib.dbwriter.info.SqlInfo.fillMetadata()

            if (st != null)
               st.close();
            return;
         }
         SqlInfo obj = new SqlInfo(this.info);
         obj.fillMetadata(conn, null, schemaName, tableName, rs, null);


         int maxCount = 20;
         int count = 0;
         while (rs.next() && count < maxCount) {
            obj.fillOneRowWithObjects(rs, null);

View Full Code Here

             SqlInfo sqlInfo = new SqlInfo(info);
             String catalog = tables[i].getCatalog();
             String schema =  tables[i].getSchema();
             String tableName = tables[i].getTable();
             tableMap.put(tableName, tables[i]);
             sqlInfo.fillMetadata(conn, catalog, schema, tableName, null, null);
             toProcess.add(sqlInfo.getDescription());
          }
          catch (Throwable ex) {
             ex.printStackTrace();
             nonExisting.add(tables[i]);

View Full Code Here

    * @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);
      }
      else
         log.warning("The table='" + tableName + "' on schema='" + schema + "' and catalog='" + catalog + "' has not been found");

View Full Code Here

            catalog = this.dbMetaHelper.getIdentifier(catalog);
         if (schema != null)
            schema = this.dbMetaHelper.getIdentifier(schema);
         table = this.dbMetaHelper.getIdentifier(table);


         sqlInfo.fillMetadata(conn, catalog, schema, table, null, null);
         SqlDescription description = sqlInfo.getDescription();
         description.addAttributes(attrs);


         // check if function and trigger are necessary (they are only if the
         // table has to be replicated.

View Full Code Here

    */
   private synchronized SqlDescription getTableDescription(String catalog, String schema, String tableName, Connection conn) throws Exception {
      SqlInfo sqlInfo = getTableDescriptionFromCache(catalog, schema, tableName);
      if (sqlInfo == null) {
         sqlInfo = new SqlInfo(this.info);
         if (sqlInfo.fillMetadata(conn, catalog, schema, tableName, null, null))
            addToSqlInfoCache(sqlInfo);
      }
      return sqlInfo.getDescription();
   }

View Full Code Here

         String[] ret = (String[])vals.toArray(new String[vals.size()]);
         assertEquals("Wrong number of colums found", 4, ret.length);
         
         SqlInfo sqlInfo = new SqlInfo(info);
         Connection conn = pool.reserve();
         sqlInfo.fillMetadata(conn, null, "XMLBLASTER", "TABLE1", null, null);
         pool.release(conn);
         
         SqlDescription description = sqlInfo.getDescription();
         boolean isConfigured = description.isColumnSearchConfigured(null);
         assertTrue("shall be configured", isConfigured);

View Full Code Here

TOP

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.