Java Code Examples for org.h2.tools.RunScript#execute()

The following examples show how to use org.h2.tools.RunScript#execute() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: TestServer.java From light-oauth2 with Apache License 2.0

6 votes

private TestServer() {
    DataSource ds = (DataSource) SingletonServiceFactory.getBean(DataSource.class);
    try (Connection connection = ds.getConnection()) {
        String schemaResourceName = "/create_h2.sql";
        InputStream in = TestServer.class.getResourceAsStream(schemaResourceName);

        if (in == null) {
            throw new RuntimeException("Failed to load resource: " + schemaResourceName);
        }
        InputStreamReader reader = new InputStreamReader(in, UTF_8);
        RunScript.execute(connection, reader);

    } catch (SQLException e) {
        e.printStackTrace();
    }

}

Example 2

Source File: AuditHandlerTest.java From light-oauth2 with Apache License 2.0

6 votes

@BeforeClass
public static void runOnceBeforeClass() {
    System.out.println("@BeforeClass - runOnceBeforeClass");
    DataSource ds = (DataSource) SingletonServiceFactory.getBean(DataSource.class);
    try (Connection connection = ds.getConnection()) {
        String schemaResourceName = "/create_h2.sql";
        InputStream in = AuditHandlerTest.class.getResourceAsStream(schemaResourceName);

        if (in == null) {
            throw new RuntimeException("Failed to load resource: " + schemaResourceName);
        }
        InputStreamReader reader = new InputStreamReader(in, UTF_8);
        RunScript.execute(connection, reader);

    } catch (SQLException e) {
        e.printStackTrace();
    }

}

Example 3

Source File: TestServer.java From light-oauth2 with Apache License 2.0

6 votes

private TestServer() {
    DataSource ds = (DataSource) SingletonServiceFactory.getBean(DataSource.class);
    try (Connection connection = ds.getConnection()) {
        String schemaResourceName = "/create_h2.sql";
        InputStream in = TestServer.class.getResourceAsStream(schemaResourceName);

        if (in == null) {
            throw new RuntimeException("Failed to load resource: " + schemaResourceName);
        }
        InputStreamReader reader = new InputStreamReader(in, UTF_8);
        RunScript.execute(connection, reader);

    } catch (SQLException e) {
        e.printStackTrace();
    }

}

Example 4

Source File: TestServer.java From light-oauth2 with Apache License 2.0

6 votes

private TestServer() {
    DataSource ds = (DataSource) SingletonServiceFactory.getBean(DataSource.class);
    try (Connection connection = ds.getConnection()) {
        String schemaResourceName = "/create_h2.sql";
        InputStream in = TestServer.class.getResourceAsStream(schemaResourceName);

        if (in == null) {
            throw new RuntimeException("Failed to load resource: " + schemaResourceName);
        }
        InputStreamReader reader = new InputStreamReader(in, UTF_8);
        RunScript.execute(connection, reader);

    } catch (SQLException e) {
        e.printStackTrace();
    }

}

Example 5

Source File: TestServer.java From light-oauth2 with Apache License 2.0

6 votes

private TestServer() {
    DataSource ds = (DataSource) SingletonServiceFactory.getBean(DataSource.class);
    try (Connection connection = ds.getConnection()) {
        String schemaResourceName = "/create_h2.sql";
        InputStream in = TestServer.class.getResourceAsStream(schemaResourceName);

        if (in == null) {
            throw new RuntimeException("Failed to load resource: " + schemaResourceName);
        }
        InputStreamReader reader = new InputStreamReader(in, UTF_8);
        RunScript.execute(connection, reader);

    } catch (SQLException e) {
        e.printStackTrace();
    }

}

Example 6

Source File: QueryDataSourceTest.java From obevo with Apache License 2.0

5 votes

@BeforeClass
public static void loadDriverTest() throws Exception {
    Class.forName("org.h2.Driver");
    activeConn = getConnection();

    Connection conn = getConnection();
    RunScript.execute(conn, new FileReader("src/test/resources/testdb.ddl"));
    conn.close();
}

Example 7

Source File: MultiDatabaseTestCase.java From Zebra with Apache License 2.0

5 votes

@Before
public void createTableAndImportDataSet() throws Exception {
	for (DataSourceEntry entry : getDataSourceEntryArray()) {
		RunScript.execute(entry.getJdbcUrl(), USER, PASSWORD, getSchema(), "UTF8", false);
		cleanlyInsert(JDBC_DRIVER, entry.getJdbcUrl(), USER, PASSWORD, readDataSet(entry.getDataSets()));
		if (entry.isWrite()) {
			writeDs = createRealDataSource(entry.getJdbcUrl(), USER, PASSWORD, JDBC_DRIVER);
		} else {
			readDses.add(createRealDataSource(entry.getJdbcUrl(), USER, PASSWORD, JDBC_DRIVER));
		}
	}
}

Example 8

Source File: H2DBTestServer.java From che with Eclipse Public License 2.0

5 votes

@Override
public void shutdown() {
  try (Connection conn = getDataSource().getConnection()) {
    RunScript.execute(conn, new StringReader("SHUTDOWN"));
  } catch (SQLException x) {
    throw new RuntimeException(x);
  }
}

Example 9

Source File: SchemaEnvironmentManager.java From shardingsphere with Apache License 2.0

5 votes

private static void dropTable(final SchemaEnvironment databaseEnvironmentSchema, final DatabaseType databaseType) {
    for (String each : databaseEnvironmentSchema.getDatabases()) {
        DataSource dataSource = DataSourceUtil.createDataSource(databaseType, each);
        try (Connection connection = dataSource.getConnection();
             StringReader stringReader = new StringReader(Joiner.on(";\n").join(databaseEnvironmentSchema.getTableDropSQLs()))) {
            RunScript.execute(connection, stringReader);
        } catch (final SQLException ex) {
            // TODO table maybe not exist
        }
    }
}

Example 10

Source File: AbstractShardingSphereDataSourceForShardingTest.java From shardingsphere with Apache License 2.0

5 votes

@Before
public void initTable() {
    try {
        ShardingSphereConnection conn = shardingSphereDataSource.getConnection();
        RunScript.execute(conn, new InputStreamReader(AbstractSQLTest.class.getClassLoader().getResourceAsStream("jdbc_data.sql")));
        conn.close();
    } catch (final SQLException ex) {
        ex.printStackTrace();
    }
}

Example 11

Source File: TransactionTest.java From registry with Apache License 2.0

5 votes

private void runScript(String fileName) throws SQLException, IOException {
    Connection connection = null;
    try {
        connection = connectionBuilder.getConnection();
        RunScript.execute(connection, load(fileName));
    } finally {
        connection.close();
    }
}

Example 12

Source File: CamelSqlTest.java From jbpm-work-items with Apache License 2.0

5 votes

/**
 * Prepares test table containing a single data row.
 */
private static void setupDb() throws SQLException, URISyntaxException {
    File script = new File(CamelSqlTest.class.getResource("/init-db.sql").toURI());
    RunScript.execute("jdbc:h2:mem:jbpm-db;MVCC=true",
                      "sa",
                      "",
                      script.getAbsolutePath(),
                      StandardCharsets.UTF_8,
                      false);
}

Example 13

Source File: AbstractShardingSphereDataSourceForEncryptTest.java From shardingsphere with Apache License 2.0

5 votes

@Before
public void initTable() {
    try (ShardingSphereConnection connection = encryptDataSource.getConnection()) {
        RunScript.execute(connection, new InputStreamReader(AbstractSQLTest.class.getClassLoader().getResourceAsStream("encrypt_data.sql")));
    } catch (final SQLException ex) {
        ex.printStackTrace();
    }
}

Example 14

Source File: DbH2ServerStartup.java From ignite with Apache License 2.0

5 votes

/**
 * Populate sample database.
 *
 * @throws SQLException if
 */
public static void populateDatabase() throws SQLException {
    // Try to connect to database TCP server.
    JdbcConnectionPool dataSrc = JdbcConnectionPool.create("jdbc:h2:tcp://localhost/mem:ExampleDb", "sa", "");

    // Create Person table in database.
    RunScript.execute(dataSrc.getConnection(), new StringReader(CREATE_PERSON_TABLE));

    // Populates Person table with sample data in database.
    RunScript.execute(dataSrc.getConnection(), new StringReader(POPULATE_PERSON_TABLE));
}

Example 15

Source File: ActionSetToken.java From o2oa with GNU Affero General Public License v3.0

5 votes

private void changeInternalDataServerPassword(String oldPassword, String newPassword) throws Exception {
	org.h2.Driver.load();
	for (Entry<String, DataServer> en : Config.nodes().dataServers().entrySet()) {
		DataServer o = en.getValue();
		if (BooleanUtils.isTrue(o.getEnable())) {
			try (Connection conn = DriverManager.getConnection(
					"jdbc:h2:tcp://" + en.getKey() + ":" + o.getTcpPort() + "/X", "sa", oldPassword)) {
				RunScript.execute(conn, new StringReader("ALTER USER SA SET PASSWORD '" + newPassword + "'"));
			} catch (Exception e) {
				throw new Exception("Verify that the dataServer:" + en.getKey()
						+ " is started and that the dataServer password is updated synchronously.", e);
			}
		}
	}
}

Example 16

Source File: DbH2ServerStartup.java From ignite with Apache License 2.0

5 votes

/**
 * Start H2 database TCP server.
 *
 * @param args Command line arguments, none required.
 * @throws IgniteException If start H2 database TCP server failed.
 */
public static void main(String[] args) throws IgniteException {
    try {
        // Start H2 database TCP server in order to access sample in-memory database from other processes.
        Server.createTcpServer("-tcpDaemon").start();

        populateDatabase();

        // Try to connect to database TCP server.
        JdbcConnectionPool dataSrc = JdbcConnectionPool.create("jdbc:h2:tcp://localhost/mem:ExampleDb", "sa", "");

        // Create Person table in database.
        RunScript.execute(dataSrc.getConnection(), new StringReader(CREATE_PERSON_TABLE));

        // Populates Person table with sample data in database.
        RunScript.execute(dataSrc.getConnection(), new StringReader(POPULATE_PERSON_TABLE));
    }
    catch (SQLException e) {
        throw new IgniteException("Failed to start database TCP server", e);
    }

    try {
        do {
            System.out.println("Type 'q' and press 'Enter' to stop H2 TCP server...");
        }
        while ('q' != System.in.read());
    }
    catch (IOException ignored) {
        // No-op.
    }
}

Example 17

Source File: H2JpaCleaner.java From che with Eclipse Public License 2.0

5 votes

@Override
public void clean() {
  super.clean();
  if (server != null) {
    server.shutdown();
  } else {
    try (Connection conn = dataSource.getConnection()) {
      RunScript.execute(conn, new StringReader("SHUTDOWN"));
    } catch (SQLException x) {
      throw new RuntimeException(x.getMessage(), x);
    }
  }
}

Example 18

Source File: CleanupStrategyProviderTest.java From jpa-unit with Apache License 2.0

4 votes

@BeforeClass
public static void createSchema() throws Exception {
    RunScript.execute(CONNECTION_URL, USER_NAME, PASSWORD, DB_SETUP_SCRIPT, StandardCharsets.UTF_8, false);
}

Example 19

Source File: H2DatabaseTestCase.java From Zebra with Apache License 2.0

4 votes

@Before
public void createTableAndImportDataSet() throws Exception {
	RunScript.execute(JDBC_URL, USER, PASSWORD, getSchema(), "UTF8", false);
	cleanlyInsert(JDBC_DRIVER, JDBC_URL, USER, PASSWORD, readDataSet());
}

Example 20

Source File: FlywaySchemaInitializerTest.java From che with Eclipse Public License 2.0

4 votes

private ResultSet execQuery(String query) throws SQLException {
  try (Connection conn = dataSource.getConnection()) {
    return RunScript.execute(conn, new StringReader(query));
  }
}