Examples of DbLoader

org.apache.cayenne.access.DbLoader

Utility class that does reverse engineering of the database. It can create DataMaps using database meta data obtained via JDBC driver. @author Michael Shengaout @author Andrus Adamchik

org.jasig.portal.tools.dbloader.DbLoader

A tool to set up a uPortal database. This tool was created so that uPortal developers would only have to maintain a single set of xml documents to define the uPortal database schema and data. Previously it was necessary to maintain different scripts for each database we wanted to support.

DbLoader reads the generic types that are specified in tables.xml and tries to map them to local types by querying the database metadata via methods implemented by the JDBC driver. Fallback mappings can be supplied in dbloader.xml for cases where the JDBC driver is not able to determine the appropriate mapping. Such cases will be reported to standard out.

An xsl transformation is used to produce the DROP TABLE and CREATE TABLE SQL statements. These statements can be altered by modifying tables.xsl

Generic data types (as defined in java.sql.Types) which may be specified in tables.xml include: BIT, TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL, CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, NULL, OTHER, JAVA_OBJECT, DISTINCT, STRUCT, ARRAY, BLOB, CLOB, REF, DATALINK, BOOLEAN

WARNING: YOU MAY WANT TO MAKE A BACKUP OF YOUR DATABASE BEFORE RUNNING DbLoader

DbLoader will perform the following steps:

Read configurable properties from dbloader.xml
Get database connection from RDBMServices (reads JDBC database settings from rdbm.properties).
Read tables.xml and issue corresponding DROP TABLE and CREATE TABLE SQL statements.
Read data.xml and issue corresponding INSERT/UPDATE/DELETE SQL statements.

@author Ken Weiner, kweiner@unicon.net @author Mark Boyd, mboyd@sungardsct.com @version $Revision: 1.31 $ @see java.sql.Types @since uPortal 2.0

      DriverDataSource dataSource = new DriverDataSource((Driver) Class
          .forName(driver).newInstance(), url, username, password);


      // Load the data map and run the db importer.
      final LoaderDelegate loaderDelegate = new LoaderDelegate();
      final DbLoader loader = new DbLoader(dataSource.getConnection(),
          adapterInst, loaderDelegate);
      loader.setCreatingMeaningfulPK(meaningfulPk);


      if (namingStrategy != null) {
        final NamingStrategy namingStrategyInst = (NamingStrategy) Class
            .forName(namingStrategy).newInstance();
        loader.setNamingStrategy(namingStrategyInst);
      }


      final DataMap dataMap = map.exists() ? loadDataMap()
          : new DataMap();
      loader.loadDataMapFromDB(schemaName, tablePattern, dataMap);


      for (ObjEntity addedObjEntity : loaderDelegate
          .getAddedObjEntities()) {
        DeleteRuleUpdater.updateObjEntity(addedObjEntity);
      }


      if (importProcedures) {
        loader.loadProceduresFromDB(schemaName, procedurePattern,
            dataMap);
      }


      // Write the new DataMap out to disk.
      map.delete();

            config.setDropTables(dropTables);
            config.setPopulateTables(populateTables);
            config.setTablesURL(tablesURL);
            config.setDataURL(dataURL);
            
            DbLoader loader = new DbLoader(config);
            
            String dataString = "(no data definition)";
            if (dataURL != null) {
                dataString = dataURL.toString();
            }
            
            try
            {
                loader.process();
                logWriter.flush();
                if (config.getScriptWriter() != null )
                    config.getScriptWriter().flush();
                if (log.isInfoEnabled())
                    log.info(

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.

Examples of DbLoader

Examples of org.apache.cayenne.access.DbLoader

Examples of org.jasig.portal.tools.dbloader.DbLoader