Example usage for org.apache.commons.dbcp BasicDataSource setUrl

Introduction

In this page you can find the example usage for org.apache.commons.dbcp BasicDataSource setUrl.

Prototype

public synchronized void setUrl(String url) 

Source Link

Document

Sets the #url .

Note: this method currently has no effect once the pool has been initialized.

Usage

From source file:org.wso2.carbon.appmgt.impl.utils.APIMgtDBUtil.java

/**
 * Initializes the data source/*from  w w  w . j  a  v a 2  s .c  o  m*/
 *
 * @throws org.wso2.carbon.appmgt.api.AppManagementException if an error occurs while loading DB configuration
 */
public static void initialize() throws Exception {
    if (dataSource != null) {
        return;
    }
    AppManagerConfiguration config = ServiceReferenceHolder.getInstance().getAPIManagerConfigurationService()
            .getAPIManagerConfiguration();

    synchronized (APIMgtDBUtil.class) {
        if (dataSource == null) {
            if (log.isDebugEnabled()) {
                log.debug("Initializing data source");
            }
            String dataSourceName = config.getFirstProperty(DATA_SOURCE_NAME);

            if (dataSourceName != null) {
                dataSource = initializeDataSource(dataSourceName);
            } else {
                DBConfiguration configuration = getDBConfig(config);
                String dbUrl = configuration.getDbUrl();
                String driver = configuration.getDriverName();
                String username = configuration.getUserName();
                String password = configuration.getPassword();
                if (dbUrl == null || driver == null || username == null || password == null) {
                    log.warn(
                            "Required DB configuration parameters unspecified. So WebApp Store and WebApp Publisher "
                                    + "will not work as expected.");
                }

                BasicDataSource basicDataSource = new BasicDataSource();
                basicDataSource.setDriverClassName(driver);
                basicDataSource.setUrl(dbUrl);
                basicDataSource.setUsername(username);
                basicDataSource.setPassword(password);
                dataSource = basicDataSource;
            }
        }

        // initializing the UI Activity Publish specific data source
        if (uiActivityPublishDataSource == null) {
            if (log.isDebugEnabled()) {
                log.debug("Initializing UI-Activity-Publish data source");
            }
            String dataSourceName = config.getFirstProperty(UI_ACTIVITY_PUBLISH_DATA_SOURCE_NAME);

            if (dataSourceName != null) {
                uiActivityPublishDataSource = initializeDataSource(dataSourceName);
            }
        }
        setupAPIManagerDatabase();
    }
}

---

From source file:org.wso2.carbon.appmgt.impl.utils.AppMgtDataSourceProvider.java

public static void initialize() throws Exception {
    if (dataSource != null) {
        return;//from   w w  w. j av  a  2  s.c om
    }
    AppManagerConfiguration config = ServiceReferenceHolder.getInstance().getAPIManagerConfigurationService()
            .getAPIManagerConfiguration();

    synchronized (AppMgtDataSourceProvider.class) {
        if (dataSource == null) {
            if (log.isDebugEnabled()) {
                log.debug("Initializing data source");
            }
            String dataSourceName = config.getFirstProperty(AppMConstants.APPM_DATA_SOURCES_STORAGE);

            if (dataSourceName != null) {
                dataSource = initializeDataSource(dataSourceName);
            } else {
                DBConfiguration configuration = getDBConfig(config);
                String dbUrl = configuration.getDbUrl();
                String driver = configuration.getDriverName();
                String username = configuration.getUserName();
                String password = configuration.getPassword();
                if (dbUrl == null || driver == null || username == null || password == null) {
                    log.warn(
                            "Required DB configuration parameters unspecified. So WebApp Store and WebApp Publisher "
                                    + "will not work as expected.");
                }

                BasicDataSource basicDataSource = new BasicDataSource();
                basicDataSource.setDriverClassName(driver);
                basicDataSource.setUrl(dbUrl);
                basicDataSource.setUsername(username);
                basicDataSource.setPassword(password);
                dataSource = basicDataSource;
            }
        }
        setupStorageDB();
    }
}

---

From source file:org.wso2.carbon.core.util.PasswordUpdater.java

private void run(String[] args) {
    String wso2wsasHome = System.getProperty(ServerConstants.CARBON_HOME);
    if (wso2wsasHome == null) {
        wso2wsasHome = new File(".").getAbsolutePath();
        System.setProperty(ServerConstants.CARBON_HOME, wso2wsasHome);
    }//from   www . jav  a2s. com

    if (args.length == 0) {
        printUsage();
        System.exit(0);
    }

    String dbURL = getParam(DB_URL, args);

    if (dbURL == null || dbURL.indexOf("jdbc:") != 0) {
        System.err.println(" Invalid database DB_URL : " + dbURL);
        printUsage();
        System.exit(0);
    }

    // ------- DB Connection params
    String dbDriver = getParam(DB_DRIVER, args);
    if (dbDriver == null) {
        dbDriver = "org.h2.Driver";
    }
    String dbUsername = getParam(DB_USERNAME, args);
    if (dbUsername == null) {
        dbUsername = "wso2carbon";
    }
    String dbPassword = getParam(DB_PASSWORD, args);
    if (dbPassword == null) {
        dbPassword = "wso2carbon";
    }

    // ------------ Load the DB Driver
    try {
        Class.forName(dbDriver);
    } catch (ClassNotFoundException e) {
        System.err.println(" Database driver [" + dbDriver + "] not found in classpath.");
        System.exit(1);
    }

    // Connect to the database
    Connection conn = null;
    try {
        conn = DriverManager.getConnection(dbURL, dbUsername, dbPassword);
    } catch (Exception e) {
        System.err.println("Cannot connect to database. \n"
                + "Please make sure that the JDBC URL is correct and that you have \n"
                + "stopped WSO2 Carbon before running this script. Root cause is : \n" + e);
        System.exit(1);
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    // --------- Capture the service username and password
    String username = getParam(USERNAME, args);
    while (username == null || username.trim().length() == 0) {
        System.out.print("Username: ");
        try {
            username = InputReader.readInput();
        } catch (IOException e) {
            System.err.println(" Could not read username : " + e);
            System.exit(1);
        }
    }

    String password = getParam(NEW_PASSWORD, args);
    if (password == null || password.trim().length() == 0) {
        String passwordRepeat = null;
        while (password == null || password.trim().length() == 0) {
            try {
                password = InputReader.readPassword("New password: ");
            } catch (IOException e) {
                System.err.println("Unable to read password : " + e);
                System.exit(1);
            }
        }
        while (passwordRepeat == null || passwordRepeat.trim().length() == 0) {
            try {
                passwordRepeat = InputReader.readPassword("Re-enter new password: ");
            } catch (IOException e) {
                System.err.println("Unable to read re-entered password : " + e);
                System.exit(1);
            }
        }
        if (!password.equals(passwordRepeat)) {
            System.err.println(" Password and re-entered password do not match");
            System.exit(1);
        }
    }

    // DataSource is created to connect to user store DB using input parameters given by user

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(dbURL);
    ds.setDriverClassName(dbDriver);
    ds.setUsername(dbUsername);
    ds.setPassword(dbPassword);

    try {
        RealmConfiguration realmConfig = new RealmConfigXMLProcessor().buildRealmConfigurationFromFile();
        JDBCUserStoreManager userStore = new JDBCUserStoreManager(ds, realmConfig);
        userStore.doUpdateCredentialByAdmin(username, password);
        System.out.println("Password updated successfully.");
    } catch (UserStoreException ex) {
        System.err.println("Error updating credentials for user " + username + " : " + ex);
    }
}

---

From source file:org.wso2.carbon.device.mgt.core.authorization.DeviceAccessAuthorizationServiceTest.java

private RegistryService getRegistryService() throws RegistryException, UserStoreException {
    RealmService realmService = new InMemoryRealmService();
    PrivilegedCarbonContext.getThreadLocalCarbonContext().setUsername(ADMIN_USER);
    BasicDataSource dataSource = new BasicDataSource();
    String connectionUrl = "jdbc:h2:./target/databasetest/CARBON_TEST";
    dataSource.setUrl(connectionUrl);
    dataSource.setDriverClassName("org.h2.Driver");
    JDBCTenantManager jdbcTenantManager = new JDBCTenantManager(dataSource,
            MultitenantConstants.SUPER_TENANT_DOMAIN_NAME);
    realmService.setTenantManager(jdbcTenantManager);
    RegistryDataHolder.getInstance().setRealmService(realmService);
    DeviceManagementDataHolder.getInstance().setRealmService(realmService);
    InputStream is = this.getClass().getClassLoader()
            .getResourceAsStream("carbon-home/repository/conf/registry.xml");
    RegistryContext context = RegistryContext.getBaseInstance(is, realmService);
    context.setSetup(true);/*from   w w  w  . j a va  2s .  c  om*/
    return context.getEmbeddedRegistryService();
}

---

From source file:org.wso2.carbon.identity.common.testng.MockInitialContextFactory.java

private static BasicDataSource createDb(String dbName, Class clazz, String[] files)
        throws TestCreationException {

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUsername("username");
    dataSource.setPassword("password");
    dataSource.setUrl("jdbc:h2:mem:test" + dbName);
    try (Connection connection = dataSource.getConnection()) {
        for (String f : files) {
            File fileFromClasspathResource = getClasspathAccessibleFile(f, clazz);
            String scriptPath = null;
            File tempFile = null;
            if (fileFromClasspathResource != null && fileFromClasspathResource.exists()) {
                scriptPath = fileFromClasspathResource.getAbsolutePath();
            } else {
                //This may be from jar.
                tempFile = copyTempFile(f, clazz);
                scriptPath = tempFile.getAbsolutePath();
            }//  w  w w  .  j  a va 2  s  .  c o  m
            if (scriptPath != null) {
                try (Statement statement = connection.createStatement()) {
                    statement.executeUpdate("RUNSCRIPT FROM '" + scriptPath + "'"); //NOSONAR
                } catch (SQLException e) {
                    throw new TestCreationException(
                            "Error while loading data to the in-memory H2 Database located from resource : "
                                    + fileFromClasspathResource + "\nabsolute path : " + scriptPath,
                            e);
                }
            }
            if (tempFile != null) {
                tempFile.delete();
            }
        }
        return dataSource;
    } catch (SQLException e) {
        throw new TestCreationException("Error while creating the in-memory H2 Database : ", e);
    }
}

---

From source file:org.wso2.carbon.identity.oauth.dao.TestOAuthDAOBase.java

protected void initiateH2Base(String databaseName, String scriptPath) throws Exception {

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUsername("username");
    dataSource.setPassword("password");
    dataSource.setUrl("jdbc:h2:mem:test" + databaseName);
    try (Connection connection = dataSource.getConnection()) {
        connection.createStatement().executeUpdate("RUNSCRIPT FROM '" + scriptPath + "'");
    }//from   w  w w  . j  a va 2 s  .co m
    dataSourceMap.put(databaseName, dataSource);
}

---

From source file:org.wso2.carbon.identity.oauth.endpoint.user.impl.TestUtils.java

public static void initiateH2Base() throws Exception {

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUsername("username");
    dataSource.setPassword("password");
    dataSource.setUrl("jdbc:h2:mem:test" + DB_NAME);
    try (Connection connection = dataSource.getConnection()) {
        connection.createStatement().executeUpdate("RUNSCRIPT FROM '" + getFilePath(H2_SCRIPT_NAME) + "'");
    }//from  ww  w  .  j av  a 2  s  .  c  o  m
    dataSourceMap.put(DB_NAME, dataSource);
}

---

From source file:org.wso2.carbon.identity.oauth.endpoint.util.TestOAthEndpointBase.java

protected void initiateInMemoryH2() throws Exception {
    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUsername("username");
    dataSource.setPassword("password");
    dataSource.setUrl("jdbc:h2:mem:test");

    connection = dataSource.getConnection();
    connection.createStatement().executeUpdate("RUNSCRIPT FROM 'src/test/resources/dbscripts/h2.sql'");
}

---

From source file:org.wso2.carbon.identity.oauth2.dao.util.DAOUtils.java

public static void initializeDataSource(String databaseName, String scriptPath) throws Exception {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUsername("username");
    dataSource.setPassword("password");
    dataSource.setUrl("jdbc:h2:mem:" + databaseName);

    try (Connection connection = dataSource.getConnection()) {
        connection.createStatement().executeUpdate("RUNSCRIPT FROM '" + scriptPath + "'");
    }//from w w w.j a v a2s. c o m
    dataSourceMap.put(databaseName, dataSource);
}

---

From source file:org.wso2.carbon.identity.openidconnect.DefaultOIDCClaimsCallbackHandlerTest.java

@BeforeClass
public void setUp() throws Exception {

    System.setProperty(CarbonBaseConstants.CARBON_HOME, CARBON_HOME);
    BasicDataSource dataSource1 = new BasicDataSource();
    dataSource1.setDriverClassName("org.h2.Driver");
    dataSource1.setUsername("username");
    dataSource1.setPassword("password");
    dataSource1.setUrl("jdbc:h2:mem:test" + DB_NAME);
    connection = dataSource1.getConnection();
    connection.createStatement().executeUpdate("RUNSCRIPT FROM '" + getFilePath(H2_SCRIPT_NAME) + "'");

    mockStatic(FrameworkUtils.class);
    when(FrameworkUtils.getMultiAttributeSeparator()).thenReturn(MULTI_ATTRIBUTE_SEPARATOR_DEFAULT);

    RequestObjectService requestObjectService = Mockito.mock(RequestObjectService.class);
    List<RequestedClaim> requestedClaims = Collections.emptyList();
    when(requestObjectService.getRequestedClaimsForIDToken(anyString())).thenReturn(requestedClaims);
    when(requestObjectService.getRequestedClaimsForUserInfo(anyString())).thenReturn(requestedClaims);

    // Skipping filtering with user consent.
    // TODO: Remove mocking claims filtering based on consent when fixing https://github.com/wso2/product-is/issues/2676
    OpenIDConnectClaimFilterImpl openIDConnectClaimFilter = spy(new OpenIDConnectClaimFilterImpl());
    when(openIDConnectClaimFilter.getClaimsFilteredByUserConsent(anyMap(), any(AuthenticatedUser.class),
            anyString(), anyString())).thenAnswer(invocation -> invocation.getArguments()[0]);
    OpenIDConnectServiceComponentHolder.getInstance().getOpenIDConnectClaimFilters()
            .add(openIDConnectClaimFilter);

    OpenIDConnectServiceComponentHolder.setRequestObjectService(requestObjectService);
    defaultOIDCClaimsCallbackHandler = new DefaultOIDCClaimsCallbackHandler();

}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »