Examples of DatabaseConnection


Examples of org.pentaho.database.model.DatabaseConnection

  {
    final ObjectFactory objectFactory = ClassicEngineBoot.getInstance().getObjectFactory();
    final IDatabaseDialectService dialectService = objectFactory.get(IDatabaseDialectService.class);
    final DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper(dialectService.getDatabaseTypes());

    final DatabaseConnection con = new DatabaseConnection();
    con.setId("Memory");
    con.setName("Memory");
    con.setAccessType(DatabaseAccessType.NATIVE);
    con.setDatabaseType(databaseTypeHelper.getDatabaseTypeByShortName("GENERIC"));
    con.setUsername("pentaho_user");
    con.setPassword("password");
    final HashMap<String, String> attrs = new HashMap<String, String>();
    attrs.put(DatabaseConnection.ATTRIBUTE_CUSTOM_DRIVER_CLASS, "org.hsqldb.jdbcDriver");
    attrs.put(DatabaseConnection.ATTRIBUTE_CUSTOM_URL, "jdbc:hsqldb:mem:SampleData");
    con.setAttributes(attrs);

    final PoolingDataSource poolingDataSource = PooledDatasourceHelper.setupPooledDataSource(con);
    final Connection connection = poolingDataSource.getConnection();
    connection.close();
View Full Code Here

Examples of org.pentaho.database.model.DatabaseConnection

    return databaseConnection;
  }

  protected void startParsing(final Attributes attrs) throws SAXException
  {
    databaseConnection = new DatabaseConnection();

    final String databaseType = attrs.getValue(ConnectionModule.NAMESPACE, PROP_TYPE);
    if (databaseType != null)
    {
      databaseConnection.setDatabaseType(databaseTypeHelper.getDatabaseTypeByShortName(databaseType));
View Full Code Here

Examples of org.pentaho.database.model.DatabaseConnection

    assertEquals(connection1.getPassword(), connection2.getPassword());
  }

  public static IDatabaseConnection generateDatabaseConnection()
  {
    final IDatabaseConnection connection = new DatabaseConnection();
    connection.setName(UUID.randomUUID().toString());
    connection.setId(UUID.randomUUID().toString());
    connection.setAccessType(DatabaseAccessType.NATIVE);
    connection.setDataTablespace(UUID.randomUUID().toString());
    connection.setDatabaseName(UUID.randomUUID().toString());
    connection.setDatabasePort("12345");
    connection.setHostname(UUID.randomUUID().toString());
    connection.setIndexTablespace(UUID.randomUUID().toString());
    connection.setInformixServername(UUID.randomUUID().toString());
    connection.setUsername(UUID.randomUUID().toString());
    connection.setPassword(UUID.randomUUID().toString());

    final ObjectFactory objectFactory = ClassicEngineBoot.getInstance().getObjectFactory();
    final IDatabaseDialectService dialectService = objectFactory.get(IDatabaseDialectService.class);
    final DatabaseTypeHelper databaseTypeHelper = new DatabaseTypeHelper(dialectService.getDatabaseTypes());

    connection.setDatabaseType(databaseTypeHelper.getDatabaseTypeByShortName("GENERIC"));
    return connection;
  }
View Full Code Here

Examples of org.platformlayer.ops.postgres.DatabaseConnection

  public void handler() {
  }

  @Override
  protected void addChildren() throws OpsException {
    DatabaseConnection dbConnection;
    {
      dbConnection = addChild(DatabaseConnection.build(model.server));

      dbConnection.databaseName = model.databaseName;
      // We need to run as superuser
      // dbConnection.username = template.getAuthDatabaseUsername();
      // dbConnection.password = template.getAuthDatabasePassword();
    }

    {
      CreateDatabase db = dbConnection.addChild(CreateDatabase.class);
      db.databaseName = model.databaseName;
    }

    {
      CreateUser db = dbConnection.addChild(CreateUser.class);
      db.grantDatabaseName = model.databaseName;
      db.databaseUser = model.username;
      db.databasePassword = model.password;
    }

    {
      RunScript script = dbConnection.addChild(RunScript.class);
      try {
        script.sql = ResourceUtils.get(getClass(), "schema.sql");
      } catch (IOException e) {
        throw new OpsException("Error loading SQL script resource", e);
      }
View Full Code Here

Examples of org.platformlayer.ops.postgres.DatabaseConnection

  @Override
  protected void addChildren() throws OpsException {
    GerritDatabaseTemplate template = injected(GerritDatabaseTemplate.class);

    DatabaseConnection dbConnection;
    {
      dbConnection = addChild(DatabaseConnection.build(template.getDatabaseServerKey()));

      dbConnection.databaseName = template.getDatabaseName();
    }

    {
      CreateDatabase db = dbConnection.addChild(CreateDatabase.class);
      db.databaseName = template.getDatabaseName();
    }

    {
      CreateUser db = dbConnection.addChild(CreateUser.class);
      db.grantDatabaseName = template.getDatabaseName();
      db.databaseUser = template.getDatabaseUsername();
      db.databasePassword = template.getDatabasePassword();
    }

    {
      RunScript script = dbConnection.addChild(RunScript.class);
      try {
        script.sql = ResourceUtils.get(getClass(), "schema.sql");
      } catch (IOException e) {
        throw new OpsException("Error loading SQL script resource", e);
      }
View Full Code Here

Examples of org.platformlayer.ops.postgres.DatabaseConnection

  public void handler() {
  }

  @Override
  protected void addChildren() throws OpsException {
    DatabaseConnection dbConnection;
    {
      dbConnection = addChild(DatabaseConnection.build(model.server));

      dbConnection.databaseName = model.databaseName;
      // We need to run as superuser
      // dbConnection.username = template.getAuthDatabaseUsername();
      // dbConnection.password = template.getAuthDatabasePassword();
    }

    {
      CreateDatabase db = dbConnection.addChild(CreateDatabase.class);
      db.databaseName = model.databaseName;
    }

    {
      CreateUser db = dbConnection.addChild(CreateUser.class);
      db.grantDatabaseName = model.databaseName;
      db.databaseUser = model.username;
      db.databasePassword = model.password;
    }

    {
      RunScript script = dbConnection.addChild(RunScript.class);
      try {
        script.sql = ResourceUtils.get(getClass(), "auth_schema.sql");
      } catch (IOException e) {
        throw new OpsException("Error loading SQL script resource", e);
      }
View Full Code Here

Examples of org.platformlayer.ops.postgres.DatabaseConnection

  public void handler() throws OpsException {
  }

  @Override
  protected void addChildren() throws OpsException {
    DatabaseConnection dbConnection;
    {
      dbConnection = addChild(DatabaseConnection.build(model.server));

      dbConnection.databaseName = model.databaseName;
    }

    {
      CreateDatabase db = dbConnection.addChild(CreateDatabase.class);
      db.databaseName = model.databaseName;
    }

    {
      CreateUser db = dbConnection.addChild(CreateUser.class);
      db.grantDatabaseName = model.databaseName;
      db.databaseUser = model.username;
      db.databasePassword = model.password;
    }
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.