Examples of SQLScript

com.celum.dbplugin.installer.SqlScript
representing SQL script. @author Zdenko Vrabel (zdenko.vrabel@celum.com)
nexj.core.meta.persistence.sql.SQLScript
SQL script container that switches the SQL script based on the adapter.
org.apache.oodt.commons.database.SqlScript
@author mattmann @version $Revision$
Abstract layer around a SQL script
.
org.flywaydb.core.internal.dbsupport.SqlScript
org.jitterbit.integration.data.structure.database.SqlScript
Class that represents the information in SQLScriptTab in TRANDB. This is used by transformations with Flat database sources. A SqlScript instances contains information about the SQL statement that will be executed on the flat source, as well as primary key information. @see org.jitterbit.integration.data.structure.database.DbTables @see org.jitterbit.integration.data.structure.database.DbFields @see org.jitterbit.integration.data.structure.database.DbTranRelations @see org.jitterbit.integration.data.entity.Transformation @author Torgil Zethson

Examples of org.apache.oodt.commons.database.SqlScript


        publicDataSource = DatabaseConnectionBuilder.buildDataSource(user, pass,
                driver, url);
        try {
            URL scriptUrl = this.getClass().getResource("/testcat.sql");
            SqlScript coreSchemaScript = new SqlScript(new File(
                scriptUrl.getFile()).getAbsolutePath(), publicDataSource);
            coreSchemaScript.loadScript();
            coreSchemaScript.execute();
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());
        }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

     * 
     * @see junit.framework.TestCase#setUp()
     */
    protected void setUp() throws Exception {
        ds = DatabaseConnectionBuilder.buildDataSource("sa", "", "org.hsqldb.jdbcDriver", "jdbc:hsqldb:file:" + tmpDirPath + "/testCat;shutdown=true");
        SqlScript coreSchemaScript = new SqlScript("src/testdata/workflow.sql", ds);
        coreSchemaScript.loadScript();
        coreSchemaScript.execute();
        ds.getConnection().commit();
    }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

public class InMemoryIngestMapper extends DataSourceIngestMapper {


  public InMemoryIngestMapper(String user, String pass, String driver,
      String jdbcUrl, String tablesFile) throws Exception {
    super(user, pass, driver, jdbcUrl);
        SqlScript coreSchemaScript = new SqlScript(new File(tablesFile).getAbsolutePath(), this.dataSource);
        coreSchemaScript.loadScript();
        coreSchemaScript.execute();
  }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

public class InMemoryIndex extends DataSourceIndex {


  public InMemoryIndex(String user, String pass, String driver,
      String jdbcUrl, boolean useUTF8, String tablesFile) throws SQLException, IOException {
    super(user, pass, driver, jdbcUrl, useUTF8);
        SqlScript coreSchemaScript = new SqlScript(new File(tablesFile).getAbsolutePath(), this.dataSource);
        coreSchemaScript.loadScript();
        coreSchemaScript.execute();
  }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

                .getProperty("org.apache.oodt.cas.filemgr.catalog.datasource.jdbc.driver");


        DataSource ds = DatabaseConnectionBuilder.buildDataSource(user, pass,
                driver, url);
        try {
            SqlScript coreSchemaScript = new SqlScript(
                    new File(getSchemaPath()).getAbsolutePath(), ds);
            coreSchemaScript.loadScript();
            coreSchemaScript.execute();
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());
        }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

                .getProperty("org.apache.oodt.cas.filemgr.catalog.datasource.jdbc.driver");


        publicDataSource = DatabaseConnectionBuilder.buildDataSource(user, pass,
                driver, url);
        try {
            SqlScript coreSchemaScript = new SqlScript(new File(
                    "./src/testdata/testcat.sql").getAbsolutePath(), publicDataSource);
            coreSchemaScript.loadScript();
            coreSchemaScript.execute();
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());
        }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

                .getProperty("org.apache.oodt.cas.filemgr.catalog.datasource.jdbc.driver");


        DataSource ds = DatabaseConnectionBuilder.buildDataSource(user, pass,
                driver, url);
        try {
            SqlScript coreSchemaScript = new SqlScript(
                    new File(getSchemaPath()).getAbsolutePath(), ds);
            coreSchemaScript.loadScript();
            coreSchemaScript.execute();
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());
        }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

                .getProperty("org.apache.oodt.cas.filemgr.catalog.datasource.jdbc.driver");


        publicDataSource = DatabaseConnectionBuilder.buildDataSource(user, pass,
                driver, url);
        try {
            SqlScript coreSchemaScript = new SqlScript(new File(
                    "./src/testdata/testcat.sql").getAbsolutePath(), publicDataSource);
            coreSchemaScript.loadScript();
            coreSchemaScript.execute();
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());
        }

View Full Code Here

Examples of org.apache.oodt.commons.database.SqlScript

                .getProperty("org.apache.oodt.cas.filemgr.catalog.datasource.jdbc.driver");


        DataSource ds = DatabaseConnectionBuilder.buildDataSource(user, pass,
                driver, url);
        try {
            SqlScript coreSchemaScript = new SqlScript(
                    new File(getSchemaPath()).getAbsolutePath(), ds);
            coreSchemaScript.loadScript();
            coreSchemaScript.execute();
        } catch (Exception e) {
            e.printStackTrace();
            fail(e.getMessage());
        }

View Full Code Here

Examples of org.flywaydb.core.internal.dbsupport.SqlScript

            // Create a Flyway DbSupport object (based on our connection)
            // This is how Flyway determines the database *type* (e.g. Postgres vs Oracle)
            DbSupport dbSupport = DbSupportFactory.createDbSupport(connection, false);


            // Load our SQL string & execute via Flyway's SQL parser
            SqlScript script = new SqlScript(sqlToExecute, dbSupport);
            script.execute(dbSupport.getJdbcTemplate());
        }
        catch(FlywayException fe)
        {
            // If any FlywayException (Runtime) is thrown, change it to a SQLException
            throw new SQLException("Flyway executeSql() error occurred", fe);

View Full Code Here

0 1 2

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.