Esempi in Java per HsqldbLocalServer.getHsqldbCompatibilityModeStatement

Esempio n. 1

File: HsqldbLocalServerIntegrationTest.java Progetto: RomanKovalik/hadoop-mini-clusters

  @Test
  public void testHsqldbMysqlCompatibilityMode() throws SQLException {
    Connection connection =
        DriverManager.getConnection(
            propertyParser.getProperty(ConfigVars.HSQLDB_JDBC_CONNECTION_STRING_PREFIX_KEY)
                + propertyParser.getProperty(ConfigVars.HSQLDB_HOSTNAME_KEY)
                + ":"
                + propertyParser.getProperty(ConfigVars.HSQLDB_PORT_KEY)
                + "/"
                + propertyParser.getProperty(ConfigVars.HSQLDB_DATABASE_NAME_KEY),
            "SA",
            "");
    Statement statement = connection.createStatement();
    statement.executeQuery(hsqldbLocalServer.getHsqldbCompatibilityModeStatement());

    statement = connection.createStatement();
    ResultSet resultSet =
        statement.executeQuery(
            "SELECT PROPERTY_VALUE FROM INFORMATION_SCHEMA.SYSTEM_PROPERTIES WHERE PROPERTY_NAME = 'sql.syntax_mys'");
    while (resultSet.next()) {
      assertTrue(Boolean.parseBoolean(resultSet.getString(1)));
    }
  }