public void testCreatePool() throws Exception {
    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();
  }
  /**
   * This method handles the resource-like loading of the XUL fragment definitions based on
   * connection type and access method. If there is a common definition, and no connection specific
   * override definition, then the common definition is used. Connection specific definition
   * resources follow the naming pattern [connection type code]_[access method].xul.
   */
  public void refreshOptionsWithCallback(final IFragmentHandler.Callback callback) {

    connectionBox = (XulListbox) document.getElementById("connection-type-list"); // $NON-NLS-1$
    accessBox = (XulListbox) document.getElementById("access-type-list"); // $NON-NLS-1$

    String connectionKey = getSelectedString(connectionBox);
    if (connectionKey == null) {
      return;
    }
    //    DatabaseInterface database = DataHandler.connectionMap.get(connectionKey);
    IDatabaseType database = databaseTypeHelper.getDatabaseTypeByName(connectionKey);

    String accessKey = getSelectedString(accessBox);
    DatabaseAccessType access = DatabaseAccessType.getAccessTypeByName(accessKey);

    if (access == null) {
      return;
    }

    String fragment = null;

    DataHandler dataHandler = null;
    try {
      dataHandler = (DataHandler) xulDomContainer.getEventHandler("dataHandler"); // $NON-NLS-1$
      dataHandler.pushCache();
    } catch (XulException e) {
      // TODO not a critical function, but should log a problem...
    }

    switch (access) {
      case JNDI:
        fragment =
            getFragment(database, "_jndi.xul", "common_jndi.xul"); // $NON-NLS-1$ //$NON-NLS-2$
        break;
      case NATIVE:
        fragment =
            getFragment(database, "_native.xul", "common_native.xul"); // $NON-NLS-1$ //$NON-NLS-2$
        break;
      case OCI:
        fragment =
            getFragment(database, "_oci.xul", "common_native.xul"); // $NON-NLS-1$ //$NON-NLS-2$
        break;
      case ODBC:
        fragment =
            getFragment(database, "_odbc.xul", "common_odbc.xul"); // $NON-NLS-1$ //$NON-NLS-2$
        break;
      case PLUGIN:
        fragment =
            getFragment(database, "_plugin.xul", "common_native.xul"); // $NON-NLS-1$ //$NON-NLS-2$
        break;
    }

    try {
      loadDatabaseOptionsFragment(fragment.toLowerCase(), dataHandler, database, callback);
    } catch (XulException e) {
      // TODO should be reporting as an error dialog; need error dialog in XUL framework
      showMessage(
          messages.getString(
              "FragmentHandler.USER.CANT_LOAD_OPTIONS", database.getName()) // $NON-NLS-1$
          );
    }
  }